"config.read('dmarc.ini')"
]
},
+ {
+ "cell_type": "code",
+ "execution_count": 8,
+ "metadata": {
+ "collapsed": true
+ },
+ "outputs": [],
+ "source": [
+ "conn = psycopg2.connect(host=config['database']['server'],\n",
+ " database=config['database']['database'], \n",
+ " user=config['database']['username'], \n",
+ " password=config['database']['password'])"
+ ]
+ },
{
"cell_type": "code",
"execution_count": 3,
}
],
"source": [
- "conn = psycopg2.connect(host=config['database']['server'],\n",
- " database=config['database']['database'], \n",
- " user=config['database']['username'], \n",
- " password=config['database']['password'])\n",
"with conn:\n",
" with conn.cursor() as cur:\n",
" cur.execute(\"\"\"\n",
" ('1459216304.582931',),\n",
" ('1459302353.261157',),\n",
" ('14593873841710243963',),\n",
+ " ('1459391203.751219',),\n",
+ " ('1459475662.735732',),\n",
" ('14661842628106423589',),\n",
" ('14662396456930987863',),\n",
" ('15111277194568576101',),\n",
" ('8c177254c3cb41869dc3afab59f74c76@hotmail.com',),\n",
" ('9037150256193522538',),\n",
" ('9138782308848375092',),\n",
+ " ('9452413620101638402',),\n",
" ('9594298247075547297',),\n",
" ('a6b6aec1af1647eb8c6fd83baaed6bbe@hotmail.com',),\n",
" ('b6d15133598b4e00b21c8e2b7cbec05e@hotmail.com',),\n",
"sorted(results)"
]
},
+ {
+ "cell_type": "code",
+ "execution_count": 10,
+ "metadata": {
+ "collapsed": false
+ },
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "[('1448246712.259522',\n",
+ " datetime.datetime(2015, 11, 22, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('75eef2128eb84e9ca8e4837f3d4e31bd@hotmail.com',\n",
+ " datetime.datetime(2015, 11, 22, 23, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('9138782308848375092',\n",
+ " datetime.datetime(2015, 11, 23, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('840fc02d5cb847ec9f007fb236c0c190@hotmail.com',\n",
+ " datetime.datetime(2015, 11, 23, 23, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('15111277194568576101',\n",
+ " datetime.datetime(2015, 11, 24, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1448419746.206772',\n",
+ " datetime.datetime(2015, 11, 24, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1448592471.754446',\n",
+ " datetime.datetime(2015, 11, 26, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('c8e4fe772ae3434594e8396a8abf77b1@hotmail.com',\n",
+ " datetime.datetime(2015, 11, 26, 23, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('2273327349069127175',\n",
+ " datetime.datetime(2015, 11, 27, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1448851661.602960',\n",
+ " datetime.datetime(2015, 11, 29, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1448938177.97045',\n",
+ " datetime.datetime(2015, 11, 30, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('18203685646345145151',\n",
+ " datetime.datetime(2015, 11, 30, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('12700770160536483846',\n",
+ " datetime.datetime(2015, 12, 1, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1449024342.601561',\n",
+ " datetime.datetime(2015, 12, 1, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1fadaaf3d9d544568a41042a1f42df05@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 1, 23, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('3544432548848738700',\n",
+ " datetime.datetime(2015, 12, 2, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1449110875.443288',\n",
+ " datetime.datetime(2015, 12, 2, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1449197294.177690',\n",
+ " datetime.datetime(2015, 12, 3, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('10356602625290246518',\n",
+ " datetime.datetime(2015, 12, 4, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1449283514.868026',\n",
+ " datetime.datetime(2015, 12, 4, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('4654132158287507198',\n",
+ " datetime.datetime(2015, 12, 5, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('5164714352250096219',\n",
+ " datetime.datetime(2015, 12, 7, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1449542804.259788',\n",
+ " datetime.datetime(2015, 12, 7, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('20246ec4a70041caa276560032fdc595@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 7, 23, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('14089985608998676943',\n",
+ " datetime.datetime(2015, 12, 8, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1449629119.120001',\n",
+ " datetime.datetime(2015, 12, 8, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('c8f339f8f3364d78820dd03a84d11daa@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 8, 23, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1233953228184721030',\n",
+ " datetime.datetime(2015, 12, 9, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('17984785070730076605',\n",
+ " datetime.datetime(2015, 12, 11, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1449888489.668429',\n",
+ " datetime.datetime(2015, 12, 11, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('121bb39637c14847a40669dd3e7cdf49@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 11, 23, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('14661842628106423589',\n",
+ " datetime.datetime(2015, 12, 12, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1449974899.615312',\n",
+ " datetime.datetime(2015, 12, 12, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('7834597727856283739',\n",
+ " datetime.datetime(2015, 12, 14, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('f94f00dee713479fb8bfdbcad539da88@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 14, 23, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('17659080448126516391',\n",
+ " datetime.datetime(2015, 12, 15, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1450234735.690828',\n",
+ " datetime.datetime(2015, 12, 15, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('17880573400612806781',\n",
+ " datetime.datetime(2015, 12, 16, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1451184218.12383',\n",
+ " datetime.datetime(2015, 12, 26, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('6505353761044749597',\n",
+ " datetime.datetime(2015, 12, 29, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('02aca4c6bb144bb6b54773374c14a43a@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 29, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1451443783.692950',\n",
+ " datetime.datetime(2015, 12, 29, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('12137203242660163862',\n",
+ " datetime.datetime(2015, 12, 30, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('d1019291012e4f4589f59f1dacef31a3@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 30, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1451616408.476341',\n",
+ " datetime.datetime(2015, 12, 31, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('11743474449139138027',\n",
+ " datetime.datetime(2016, 1, 5, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('e245ef81f05b4697bea34bed977d8286@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 5, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1452134765.308922',\n",
+ " datetime.datetime(2016, 1, 6, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('271c80b9234a4c99bb9608abc5470c99@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 8, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('15974729567081493290',\n",
+ " datetime.datetime(2016, 1, 9, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('ba1e9c35eec5428b8c3d6a32d25daa46@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 9, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1452393953.83099',\n",
+ " datetime.datetime(2016, 1, 9, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('d71792d8afc246e9a4756bd13e600b59@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 10, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1452480188.666644',\n",
+ " datetime.datetime(2016, 1, 10, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1452566814.805501',\n",
+ " datetime.datetime(2016, 1, 11, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('fc0750780e0d4b1395c4c9f41cb9791f@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 12, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1452653275.294149',\n",
+ " datetime.datetime(2016, 1, 12, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1452741832.342075',\n",
+ " datetime.datetime(2016, 1, 13, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('2884439811958006165',\n",
+ " datetime.datetime(2016, 1, 13, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('3508955360705645678',\n",
+ " datetime.datetime(2016, 1, 12, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1452826445.971145',\n",
+ " datetime.datetime(2016, 1, 14, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1452912512.114840',\n",
+ " datetime.datetime(2016, 1, 15, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('eda16c25bbdb48b2bae0d18eab13f736@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 16, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('724976339745122723',\n",
+ " datetime.datetime(2016, 1, 17, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1453084984.369330',\n",
+ " datetime.datetime(2016, 1, 17, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1453171440.157305',\n",
+ " datetime.datetime(2016, 1, 18, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1862812391966551302',\n",
+ " datetime.datetime(2016, 1, 19, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1453258067.440890',\n",
+ " datetime.datetime(2016, 1, 19, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1453344550.144698',\n",
+ " datetime.datetime(2016, 1, 20, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('2002148329698541727',\n",
+ " datetime.datetime(2016, 1, 21, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('6110291457768008366',\n",
+ " datetime.datetime(2016, 1, 22, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('de651cefbc0749a3aa3d91cdc5084f5a@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 22, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1453517236.399019',\n",
+ " datetime.datetime(2016, 1, 22, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('14593873841710243963',\n",
+ " datetime.datetime(2016, 1, 24, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('ba64911adb0743d0b926588647ec5dcf@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 24, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1453689981.768611',\n",
+ " datetime.datetime(2016, 1, 24, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('13959504937502303973',\n",
+ " datetime.datetime(2016, 1, 25, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('3eba8b9e31724809aaf8d517e5656c4b@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 25, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1453776417.898739',\n",
+ " datetime.datetime(2016, 1, 25, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('9594298247075547297',\n",
+ " datetime.datetime(2016, 1, 26, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('d77c5b90344149f5bb7b50ff69400aeb@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 26, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1453862958.482897',\n",
+ " datetime.datetime(2016, 1, 26, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('3267388508667988463',\n",
+ " datetime.datetime(2016, 1, 27, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('580ca0a74948493ba8b7c6e62b8c81d9@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 28, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('6876229717666715946',\n",
+ " datetime.datetime(2016, 1, 28, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('6474240574237085621',\n",
+ " datetime.datetime(2016, 1, 31, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1454381343.228960',\n",
+ " datetime.datetime(2016, 2, 1, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('77b6c2aa32bf440aa240195db229cd4a@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 1, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1922265692629464594',\n",
+ " datetime.datetime(2016, 2, 2, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1454467952.258012',\n",
+ " datetime.datetime(2016, 2, 2, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1454640482.903992',\n",
+ " datetime.datetime(2016, 2, 4, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('16409503372348966326',\n",
+ " datetime.datetime(2016, 2, 4, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('456ffff78456494fbaed47b465259d46@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 4, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('543258397004515473',\n",
+ " datetime.datetime(2016, 2, 5, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('4158049796460953654',\n",
+ " datetime.datetime(2016, 2, 7, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('a6b6aec1af1647eb8c6fd83baaed6bbe@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 7, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1454986282.636073',\n",
+ " datetime.datetime(2016, 2, 8, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('8986675713054039362',\n",
+ " datetime.datetime(2016, 2, 9, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('30d5ef78d6d746a4a777c56e7ca6f1c6@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 9, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1455072659.49250',\n",
+ " datetime.datetime(2016, 2, 9, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('10744929815548178249',\n",
+ " datetime.datetime(2016, 2, 10, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1178c4fe34364ff39cb6e24a51219093@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 10, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('730219275619457',\n",
+ " datetime.datetime(2016, 2, 11, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('164180405175632647',\n",
+ " datetime.datetime(2016, 2, 12, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('16520810497197721925',\n",
+ " datetime.datetime(2016, 2, 13, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('13f28e952d67451281b90d55eee9c7c3@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 13, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1455418081.446180',\n",
+ " datetime.datetime(2016, 2, 13, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('641b4cc500334a7eb3f649b21af003ca@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 15, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('14416654486328871570',\n",
+ " datetime.datetime(2016, 2, 16, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('dbe2f49dbea947428b179e0ecec5f813@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 16, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1455679107.469767',\n",
+ " datetime.datetime(2016, 2, 16, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('7815164892280952980',\n",
+ " datetime.datetime(2016, 2, 17, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('511d6fbb8484454b916ad8d799938390@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 17, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1455763965.140751',\n",
+ " datetime.datetime(2016, 2, 17, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('10491829640821461358',\n",
+ " datetime.datetime(2016, 2, 18, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('13702792868066092542',\n",
+ " datetime.datetime(2016, 2, 19, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1456109267.60200',\n",
+ " datetime.datetime(2016, 2, 21, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('2cfe3d0ec75b43f89a6a7ae57777e25c@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 22, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('9037150256193522538',\n",
+ " datetime.datetime(2016, 2, 23, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('e327753089e04950906848d104a93695@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 23, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1456282325.455667',\n",
+ " datetime.datetime(2016, 2, 23, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('3584764172722215181',\n",
+ " datetime.datetime(2016, 2, 24, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1456455410.661669',\n",
+ " datetime.datetime(2016, 2, 25, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('16824795799639390032',\n",
+ " datetime.datetime(2016, 2, 25, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('14217880258295310962',\n",
+ " datetime.datetime(2016, 2, 26, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1456541727.873510',\n",
+ " datetime.datetime(2016, 2, 26, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1102163566627474204',\n",
+ " datetime.datetime(2016, 2, 28, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1456713880.905762',\n",
+ " datetime.datetime(2016, 2, 28, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1456800606.884839',\n",
+ " datetime.datetime(2016, 2, 29, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1bcc49be66744cc7a70ae1cc53515bbf@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 29, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('11019573554877343650',\n",
+ " datetime.datetime(2016, 3, 1, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1456886761.643377',\n",
+ " datetime.datetime(2016, 3, 1, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('36dd4e2b3f424bb6919d2d5d4c77c8dd@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 2, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('b6d15133598b4e00b21c8e2b7cbec05e@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 3, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1457059537.625770',\n",
+ " datetime.datetime(2016, 3, 3, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('85136d21c514431e9f5cf9d36faa4a22@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 4, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1457146943.63077',\n",
+ " datetime.datetime(2016, 3, 4, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1457232742.472142',\n",
+ " datetime.datetime(2016, 3, 5, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('ea3a96df66a845c5a666068ef8ca1368@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 5, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('17044038014166863505',\n",
+ " datetime.datetime(2016, 3, 6, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1457318880.887129',\n",
+ " datetime.datetime(2016, 3, 6, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('3689737760348689620',\n",
+ " datetime.datetime(2016, 3, 7, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('726a3261dfab4b4590b5fc898c561b08@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 7, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('129a9dc3ff2e40ae8a3890ecc1c291d9@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 8, 15, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1457491692.793016',\n",
+ " datetime.datetime(2016, 3, 8, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1207168150882246442',\n",
+ " datetime.datetime(2016, 3, 8, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('10706879170593875813',\n",
+ " datetime.datetime(2016, 3, 9, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('4226319448276355598',\n",
+ " datetime.datetime(2016, 3, 11, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1457750956.253773',\n",
+ " datetime.datetime(2016, 3, 11, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('12434676377746978866',\n",
+ " datetime.datetime(2016, 3, 13, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('43e7b5e2e0fb400aa914058360c8aaab@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 13, 14, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1457919850.989656',\n",
+ " datetime.datetime(2016, 3, 13, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('594749737641304465',\n",
+ " datetime.datetime(2016, 3, 14, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('18c9a966da81401e80ca2a22310ffee6@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 14, 14, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1458006833.731671',\n",
+ " datetime.datetime(2016, 3, 14, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('6996084840178215735',\n",
+ " datetime.datetime(2016, 3, 15, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1458093082.193350',\n",
+ " datetime.datetime(2016, 3, 15, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('3188090359734380692',\n",
+ " datetime.datetime(2016, 3, 17, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('7006513620611789399',\n",
+ " datetime.datetime(2016, 3, 18, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1458353823.362308',\n",
+ " datetime.datetime(2016, 3, 18, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('17071564483265101388',\n",
+ " datetime.datetime(2016, 3, 19, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1458524834.32161',\n",
+ " datetime.datetime(2016, 3, 20, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1458611429.595569',\n",
+ " datetime.datetime(2016, 3, 21, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('14662396456930987863',\n",
+ " datetime.datetime(2016, 3, 23, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1458784545.303847',\n",
+ " datetime.datetime(2016, 3, 23, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('13032699446207263761',\n",
+ " datetime.datetime(2016, 3, 24, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('8426152571808739514',\n",
+ " datetime.datetime(2016, 3, 25, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1458957186.548175',\n",
+ " datetime.datetime(2016, 3, 25, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('2150510829392606201',\n",
+ " datetime.datetime(2016, 3, 26, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('68aad5080a774e2c997d159b546569b9@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 26, 17, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('1459129809.695034',\n",
+ " datetime.datetime(2016, 3, 27, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('16143280651570354241',\n",
+ " datetime.datetime(2016, 3, 27, 0, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None))),\n",
+ " ('8c177254c3cb41869dc3afab59f74c76@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 27, 18, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('15410706527896810898',\n",
+ " datetime.datetime(2016, 3, 28, 1, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('1459216304.582931',\n",
+ " datetime.datetime(2016, 3, 28, 1, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('15497495941279624940',\n",
+ " datetime.datetime(2016, 3, 29, 1, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('1459302353.261157',\n",
+ " datetime.datetime(2016, 3, 29, 1, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('7773a696f4a54f1e8c01f4644fbb94ee@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 29, 18, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('15185964531645951164',\n",
+ " datetime.datetime(2016, 3, 30, 1, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('1459391203.751219',\n",
+ " datetime.datetime(2016, 3, 30, 1, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('9452413620101638402',\n",
+ " datetime.datetime(2016, 3, 31, 1, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None))),\n",
+ " ('1459475662.735732',\n",
+ " datetime.datetime(2016, 3, 31, 1, 0, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None)))]"
+ ]
+ },
+ "execution_count": 10,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "with conn:\n",
+ " with conn.cursor() as cur:\n",
+ " cur.execute(\"\"\"\n",
+ " select report_metadata_report_id, report_metadata_date_range_begin\n",
+ " from reports\"\"\")\n",
+ " results = cur.fetchall()\n",
+ "results"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 11,
+ "metadata": {
+ "collapsed": false
+ },
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "[('1448246712.259522', datetime.datetime(2015, 11, 22, 0, 0)),\n",
+ " ('75eef2128eb84e9ca8e4837f3d4e31bd@hotmail.com',\n",
+ " datetime.datetime(2015, 11, 22, 23, 0)),\n",
+ " ('9138782308848375092', datetime.datetime(2015, 11, 23, 0, 0)),\n",
+ " ('840fc02d5cb847ec9f007fb236c0c190@hotmail.com',\n",
+ " datetime.datetime(2015, 11, 23, 23, 0)),\n",
+ " ('15111277194568576101', datetime.datetime(2015, 11, 24, 0, 0)),\n",
+ " ('1448419746.206772', datetime.datetime(2015, 11, 24, 0, 0)),\n",
+ " ('1448592471.754446', datetime.datetime(2015, 11, 26, 0, 0)),\n",
+ " ('c8e4fe772ae3434594e8396a8abf77b1@hotmail.com',\n",
+ " datetime.datetime(2015, 11, 26, 23, 0)),\n",
+ " ('2273327349069127175', datetime.datetime(2015, 11, 27, 0, 0)),\n",
+ " ('1448851661.602960', datetime.datetime(2015, 11, 29, 0, 0)),\n",
+ " ('1448938177.97045', datetime.datetime(2015, 11, 30, 0, 0)),\n",
+ " ('18203685646345145151', datetime.datetime(2015, 11, 30, 0, 0)),\n",
+ " ('12700770160536483846', datetime.datetime(2015, 12, 1, 0, 0)),\n",
+ " ('1449024342.601561', datetime.datetime(2015, 12, 1, 0, 0)),\n",
+ " ('1fadaaf3d9d544568a41042a1f42df05@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 1, 23, 0)),\n",
+ " ('3544432548848738700', datetime.datetime(2015, 12, 2, 0, 0)),\n",
+ " ('1449110875.443288', datetime.datetime(2015, 12, 2, 0, 0)),\n",
+ " ('1449197294.177690', datetime.datetime(2015, 12, 3, 0, 0)),\n",
+ " ('10356602625290246518', datetime.datetime(2015, 12, 4, 0, 0)),\n",
+ " ('1449283514.868026', datetime.datetime(2015, 12, 4, 0, 0)),\n",
+ " ('4654132158287507198', datetime.datetime(2015, 12, 5, 0, 0)),\n",
+ " ('5164714352250096219', datetime.datetime(2015, 12, 7, 0, 0)),\n",
+ " ('1449542804.259788', datetime.datetime(2015, 12, 7, 0, 0)),\n",
+ " ('20246ec4a70041caa276560032fdc595@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 7, 23, 0)),\n",
+ " ('14089985608998676943', datetime.datetime(2015, 12, 8, 0, 0)),\n",
+ " ('1449629119.120001', datetime.datetime(2015, 12, 8, 0, 0)),\n",
+ " ('c8f339f8f3364d78820dd03a84d11daa@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 8, 23, 0)),\n",
+ " ('1233953228184721030', datetime.datetime(2015, 12, 9, 0, 0)),\n",
+ " ('17984785070730076605', datetime.datetime(2015, 12, 11, 0, 0)),\n",
+ " ('1449888489.668429', datetime.datetime(2015, 12, 11, 0, 0)),\n",
+ " ('121bb39637c14847a40669dd3e7cdf49@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 11, 23, 0)),\n",
+ " ('14661842628106423589', datetime.datetime(2015, 12, 12, 0, 0)),\n",
+ " ('1449974899.615312', datetime.datetime(2015, 12, 12, 0, 0)),\n",
+ " ('7834597727856283739', datetime.datetime(2015, 12, 14, 0, 0)),\n",
+ " ('f94f00dee713479fb8bfdbcad539da88@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 14, 23, 0)),\n",
+ " ('17659080448126516391', datetime.datetime(2015, 12, 15, 0, 0)),\n",
+ " ('1450234735.690828', datetime.datetime(2015, 12, 15, 0, 0)),\n",
+ " ('17880573400612806781', datetime.datetime(2015, 12, 16, 0, 0)),\n",
+ " ('1451184218.12383', datetime.datetime(2015, 12, 26, 0, 0)),\n",
+ " ('6505353761044749597', datetime.datetime(2015, 12, 29, 0, 0)),\n",
+ " ('02aca4c6bb144bb6b54773374c14a43a@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 29, 15, 0)),\n",
+ " ('1451443783.692950', datetime.datetime(2015, 12, 29, 0, 0)),\n",
+ " ('12137203242660163862', datetime.datetime(2015, 12, 30, 0, 0)),\n",
+ " ('d1019291012e4f4589f59f1dacef31a3@hotmail.com',\n",
+ " datetime.datetime(2015, 12, 30, 15, 0)),\n",
+ " ('1451616408.476341', datetime.datetime(2015, 12, 31, 0, 0)),\n",
+ " ('11743474449139138027', datetime.datetime(2016, 1, 5, 0, 0)),\n",
+ " ('e245ef81f05b4697bea34bed977d8286@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 5, 15, 0)),\n",
+ " ('1452134765.308922', datetime.datetime(2016, 1, 6, 0, 0)),\n",
+ " ('271c80b9234a4c99bb9608abc5470c99@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 8, 15, 0)),\n",
+ " ('15974729567081493290', datetime.datetime(2016, 1, 9, 0, 0)),\n",
+ " ('ba1e9c35eec5428b8c3d6a32d25daa46@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 9, 15, 0)),\n",
+ " ('1452393953.83099', datetime.datetime(2016, 1, 9, 0, 0)),\n",
+ " ('d71792d8afc246e9a4756bd13e600b59@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 10, 15, 0)),\n",
+ " ('1452480188.666644', datetime.datetime(2016, 1, 10, 0, 0)),\n",
+ " ('1452566814.805501', datetime.datetime(2016, 1, 11, 0, 0)),\n",
+ " ('fc0750780e0d4b1395c4c9f41cb9791f@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 12, 15, 0)),\n",
+ " ('1452653275.294149', datetime.datetime(2016, 1, 12, 0, 0)),\n",
+ " ('1452741832.342075', datetime.datetime(2016, 1, 13, 0, 0)),\n",
+ " ('2884439811958006165', datetime.datetime(2016, 1, 13, 0, 0)),\n",
+ " ('3508955360705645678', datetime.datetime(2016, 1, 12, 0, 0)),\n",
+ " ('1452826445.971145', datetime.datetime(2016, 1, 14, 0, 0)),\n",
+ " ('1452912512.114840', datetime.datetime(2016, 1, 15, 0, 0)),\n",
+ " ('eda16c25bbdb48b2bae0d18eab13f736@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 16, 15, 0)),\n",
+ " ('724976339745122723', datetime.datetime(2016, 1, 17, 0, 0)),\n",
+ " ('1453084984.369330', datetime.datetime(2016, 1, 17, 0, 0)),\n",
+ " ('1453171440.157305', datetime.datetime(2016, 1, 18, 0, 0)),\n",
+ " ('1862812391966551302', datetime.datetime(2016, 1, 19, 0, 0)),\n",
+ " ('1453258067.440890', datetime.datetime(2016, 1, 19, 0, 0)),\n",
+ " ('1453344550.144698', datetime.datetime(2016, 1, 20, 0, 0)),\n",
+ " ('2002148329698541727', datetime.datetime(2016, 1, 21, 0, 0)),\n",
+ " ('6110291457768008366', datetime.datetime(2016, 1, 22, 0, 0)),\n",
+ " ('de651cefbc0749a3aa3d91cdc5084f5a@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 22, 15, 0)),\n",
+ " ('1453517236.399019', datetime.datetime(2016, 1, 22, 0, 0)),\n",
+ " ('14593873841710243963', datetime.datetime(2016, 1, 24, 0, 0)),\n",
+ " ('ba64911adb0743d0b926588647ec5dcf@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 24, 15, 0)),\n",
+ " ('1453689981.768611', datetime.datetime(2016, 1, 24, 0, 0)),\n",
+ " ('13959504937502303973', datetime.datetime(2016, 1, 25, 0, 0)),\n",
+ " ('3eba8b9e31724809aaf8d517e5656c4b@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 25, 15, 0)),\n",
+ " ('1453776417.898739', datetime.datetime(2016, 1, 25, 0, 0)),\n",
+ " ('9594298247075547297', datetime.datetime(2016, 1, 26, 0, 0)),\n",
+ " ('d77c5b90344149f5bb7b50ff69400aeb@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 26, 15, 0)),\n",
+ " ('1453862958.482897', datetime.datetime(2016, 1, 26, 0, 0)),\n",
+ " ('3267388508667988463', datetime.datetime(2016, 1, 27, 0, 0)),\n",
+ " ('580ca0a74948493ba8b7c6e62b8c81d9@hotmail.com',\n",
+ " datetime.datetime(2016, 1, 28, 15, 0)),\n",
+ " ('6876229717666715946', datetime.datetime(2016, 1, 28, 0, 0)),\n",
+ " ('6474240574237085621', datetime.datetime(2016, 1, 31, 0, 0)),\n",
+ " ('1454381343.228960', datetime.datetime(2016, 2, 1, 0, 0)),\n",
+ " ('77b6c2aa32bf440aa240195db229cd4a@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 1, 15, 0)),\n",
+ " ('1922265692629464594', datetime.datetime(2016, 2, 2, 0, 0)),\n",
+ " ('1454467952.258012', datetime.datetime(2016, 2, 2, 0, 0)),\n",
+ " ('1454640482.903992', datetime.datetime(2016, 2, 4, 0, 0)),\n",
+ " ('16409503372348966326', datetime.datetime(2016, 2, 4, 0, 0)),\n",
+ " ('456ffff78456494fbaed47b465259d46@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 4, 15, 0)),\n",
+ " ('543258397004515473', datetime.datetime(2016, 2, 5, 0, 0)),\n",
+ " ('4158049796460953654', datetime.datetime(2016, 2, 7, 0, 0)),\n",
+ " ('a6b6aec1af1647eb8c6fd83baaed6bbe@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 7, 15, 0)),\n",
+ " ('1454986282.636073', datetime.datetime(2016, 2, 8, 0, 0)),\n",
+ " ('8986675713054039362', datetime.datetime(2016, 2, 9, 0, 0)),\n",
+ " ('30d5ef78d6d746a4a777c56e7ca6f1c6@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 9, 15, 0)),\n",
+ " ('1455072659.49250', datetime.datetime(2016, 2, 9, 0, 0)),\n",
+ " ('10744929815548178249', datetime.datetime(2016, 2, 10, 0, 0)),\n",
+ " ('1178c4fe34364ff39cb6e24a51219093@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 10, 15, 0)),\n",
+ " ('730219275619457', datetime.datetime(2016, 2, 11, 0, 0)),\n",
+ " ('164180405175632647', datetime.datetime(2016, 2, 12, 0, 0)),\n",
+ " ('16520810497197721925', datetime.datetime(2016, 2, 13, 0, 0)),\n",
+ " ('13f28e952d67451281b90d55eee9c7c3@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 13, 15, 0)),\n",
+ " ('1455418081.446180', datetime.datetime(2016, 2, 13, 0, 0)),\n",
+ " ('641b4cc500334a7eb3f649b21af003ca@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 15, 15, 0)),\n",
+ " ('14416654486328871570', datetime.datetime(2016, 2, 16, 0, 0)),\n",
+ " ('dbe2f49dbea947428b179e0ecec5f813@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 16, 15, 0)),\n",
+ " ('1455679107.469767', datetime.datetime(2016, 2, 16, 0, 0)),\n",
+ " ('7815164892280952980', datetime.datetime(2016, 2, 17, 0, 0)),\n",
+ " ('511d6fbb8484454b916ad8d799938390@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 17, 15, 0)),\n",
+ " ('1455763965.140751', datetime.datetime(2016, 2, 17, 0, 0)),\n",
+ " ('10491829640821461358', datetime.datetime(2016, 2, 18, 0, 0)),\n",
+ " ('13702792868066092542', datetime.datetime(2016, 2, 19, 0, 0)),\n",
+ " ('1456109267.60200', datetime.datetime(2016, 2, 21, 0, 0)),\n",
+ " ('2cfe3d0ec75b43f89a6a7ae57777e25c@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 22, 15, 0)),\n",
+ " ('9037150256193522538', datetime.datetime(2016, 2, 23, 0, 0)),\n",
+ " ('e327753089e04950906848d104a93695@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 23, 15, 0)),\n",
+ " ('1456282325.455667', datetime.datetime(2016, 2, 23, 0, 0)),\n",
+ " ('3584764172722215181', datetime.datetime(2016, 2, 24, 0, 0)),\n",
+ " ('1456455410.661669', datetime.datetime(2016, 2, 25, 0, 0)),\n",
+ " ('16824795799639390032', datetime.datetime(2016, 2, 25, 0, 0)),\n",
+ " ('14217880258295310962', datetime.datetime(2016, 2, 26, 0, 0)),\n",
+ " ('1456541727.873510', datetime.datetime(2016, 2, 26, 0, 0)),\n",
+ " ('1102163566627474204', datetime.datetime(2016, 2, 28, 0, 0)),\n",
+ " ('1456713880.905762', datetime.datetime(2016, 2, 28, 0, 0)),\n",
+ " ('1456800606.884839', datetime.datetime(2016, 2, 29, 0, 0)),\n",
+ " ('1bcc49be66744cc7a70ae1cc53515bbf@hotmail.com',\n",
+ " datetime.datetime(2016, 2, 29, 15, 0)),\n",
+ " ('11019573554877343650', datetime.datetime(2016, 3, 1, 0, 0)),\n",
+ " ('1456886761.643377', datetime.datetime(2016, 3, 1, 0, 0)),\n",
+ " ('36dd4e2b3f424bb6919d2d5d4c77c8dd@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 2, 15, 0)),\n",
+ " ('b6d15133598b4e00b21c8e2b7cbec05e@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 3, 15, 0)),\n",
+ " ('1457059537.625770', datetime.datetime(2016, 3, 3, 0, 0)),\n",
+ " ('85136d21c514431e9f5cf9d36faa4a22@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 4, 15, 0)),\n",
+ " ('1457146943.63077', datetime.datetime(2016, 3, 4, 0, 0)),\n",
+ " ('1457232742.472142', datetime.datetime(2016, 3, 5, 0, 0)),\n",
+ " ('ea3a96df66a845c5a666068ef8ca1368@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 5, 15, 0)),\n",
+ " ('17044038014166863505', datetime.datetime(2016, 3, 6, 0, 0)),\n",
+ " ('1457318880.887129', datetime.datetime(2016, 3, 6, 0, 0)),\n",
+ " ('3689737760348689620', datetime.datetime(2016, 3, 7, 0, 0)),\n",
+ " ('726a3261dfab4b4590b5fc898c561b08@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 7, 15, 0)),\n",
+ " ('129a9dc3ff2e40ae8a3890ecc1c291d9@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 8, 15, 0)),\n",
+ " ('1457491692.793016', datetime.datetime(2016, 3, 8, 0, 0)),\n",
+ " ('1207168150882246442', datetime.datetime(2016, 3, 8, 0, 0)),\n",
+ " ('10706879170593875813', datetime.datetime(2016, 3, 9, 0, 0)),\n",
+ " ('4226319448276355598', datetime.datetime(2016, 3, 11, 0, 0)),\n",
+ " ('1457750956.253773', datetime.datetime(2016, 3, 11, 0, 0)),\n",
+ " ('12434676377746978866', datetime.datetime(2016, 3, 13, 0, 0)),\n",
+ " ('43e7b5e2e0fb400aa914058360c8aaab@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 13, 14, 0)),\n",
+ " ('1457919850.989656', datetime.datetime(2016, 3, 13, 0, 0)),\n",
+ " ('594749737641304465', datetime.datetime(2016, 3, 14, 0, 0)),\n",
+ " ('18c9a966da81401e80ca2a22310ffee6@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 14, 14, 0)),\n",
+ " ('1458006833.731671', datetime.datetime(2016, 3, 14, 0, 0)),\n",
+ " ('6996084840178215735', datetime.datetime(2016, 3, 15, 0, 0)),\n",
+ " ('1458093082.193350', datetime.datetime(2016, 3, 15, 0, 0)),\n",
+ " ('3188090359734380692', datetime.datetime(2016, 3, 17, 0, 0)),\n",
+ " ('7006513620611789399', datetime.datetime(2016, 3, 18, 0, 0)),\n",
+ " ('1458353823.362308', datetime.datetime(2016, 3, 18, 0, 0)),\n",
+ " ('17071564483265101388', datetime.datetime(2016, 3, 19, 0, 0)),\n",
+ " ('1458524834.32161', datetime.datetime(2016, 3, 20, 0, 0)),\n",
+ " ('1458611429.595569', datetime.datetime(2016, 3, 21, 0, 0)),\n",
+ " ('14662396456930987863', datetime.datetime(2016, 3, 23, 0, 0)),\n",
+ " ('1458784545.303847', datetime.datetime(2016, 3, 23, 0, 0)),\n",
+ " ('13032699446207263761', datetime.datetime(2016, 3, 24, 0, 0)),\n",
+ " ('8426152571808739514', datetime.datetime(2016, 3, 25, 0, 0)),\n",
+ " ('1458957186.548175', datetime.datetime(2016, 3, 25, 0, 0)),\n",
+ " ('2150510829392606201', datetime.datetime(2016, 3, 26, 0, 0)),\n",
+ " ('68aad5080a774e2c997d159b546569b9@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 26, 17, 0)),\n",
+ " ('1459129809.695034', datetime.datetime(2016, 3, 27, 0, 0)),\n",
+ " ('16143280651570354241', datetime.datetime(2016, 3, 27, 0, 0)),\n",
+ " ('8c177254c3cb41869dc3afab59f74c76@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 27, 17, 0)),\n",
+ " ('15410706527896810898', datetime.datetime(2016, 3, 28, 0, 0)),\n",
+ " ('1459216304.582931', datetime.datetime(2016, 3, 28, 0, 0)),\n",
+ " ('15497495941279624940', datetime.datetime(2016, 3, 29, 0, 0)),\n",
+ " ('1459302353.261157', datetime.datetime(2016, 3, 29, 0, 0)),\n",
+ " ('7773a696f4a54f1e8c01f4644fbb94ee@hotmail.com',\n",
+ " datetime.datetime(2016, 3, 29, 17, 0)),\n",
+ " ('15185964531645951164', datetime.datetime(2016, 3, 30, 0, 0)),\n",
+ " ('1459391203.751219', datetime.datetime(2016, 3, 30, 0, 0)),\n",
+ " ('9452413620101638402', datetime.datetime(2016, 3, 31, 0, 0)),\n",
+ " ('1459475662.735732', datetime.datetime(2016, 3, 31, 0, 0))]"
+ ]
+ },
+ "execution_count": 11,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "with conn:\n",
+ " with conn.cursor() as cur:\n",
+ " cur.execute(\"\"\"\n",
+ " select report_metadata_report_id, report_metadata_date_range_begin at time zone 'UTC'\n",
+ " from reports\"\"\")\n",
+ " results = cur.fetchall()\n",
+ "results"
+ ]
+ },
{
"cell_type": "code",
"execution_count": 7,
},
"outputs": [],
"source": [
- "conn.close()"
+ "# conn.close()"
]
}
],
projects / dmarc.git / blobdiff