PREVIEW / futures_1hour / 2012-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-01.parquet
  size:    42 KB
  rows:    1,291

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2012-05-01 00:00:00	ES	Futures	1411.65	1413.42	1411.4	1412.92	3993.0
2012-05-01 01:00:00	ES	Futures	1412.92	1413.17	1410.64	1411.15	4741.0
2012-05-01 02:00:00	ES	Futures	1411.4	1411.65	1410.13	1411.4	3508.0
2012-05-01 03:00:00	ES	Futures	1411.15	1411.91	1410.13	1410.89	4484.0
2012-05-01 04:00:00	ES	Futures	1411.15	1411.91	1410.39	1410.64	4241.0
2012-05-01 05:00:00	ES	Futures	1410.89	1410.89	1408.62	1409.12	5106.0
2012-05-01 06:00:00	ES	Futures	1409.12	1410.89	1408.11	1410.64	8305.0
2012-05-01 07:00:00	ES	Futures	1410.89	1412.66	1410.39	1411.4	9160.0
2012-05-01 08:00:00	ES	Futures	1411.4	1411.91	1409.88	1410.64	13275.0
2012-05-01 09:00:00	ES	Futures	1410.39	1412.16	1407.86	1408.62	150252.0
2012-05-01 10:00:00	ES	Futures	1408.62	1424.55	1408.36	1423.54	403352.0
2012-05-01 11:00:00	ES	Futures	1423.8	1428.6	1423.29	1427.34	132378.0
2012-05-01 12:00:00	ES	Futures	1427.08	1427.59	1426.33	1426.58	50369.0
2012-05-01 13:00:00	ES	Futures	1426.83	1426.83	1424.05	1425.31	70431.0
2012-05-01 14:00:00	ES	Futures	1425.31	1425.82	1423.04	1423.8	95511.0
2012-05-01 15:00:00	ES	Futures	1423.8	1424.55	1417.72	1419.24	226903.0
2012-05-01 16:00:00	ES	Futures	1419.24	1419.5	1416.71	1417.98	101670.0
2012-05-01 17:00:00	ES	Futures	1417.98	1418.23	1416.71	1417.47	3714.0
2012-05-01 18:00:00	ES	Futures	1417.72	1418.48	1417.22	1417.72	4289.0
2012-05-01 19:00:00	ES	Futures	1417.47	1418.74	1417.22	1418.74	2357.0
2012-05-01 20:00:00	ES	Futures	1418.48	1418.74	1417.98	1417.98	5435.0
2012-05-01 21:00:00	ES	Futures	1418.23	1418.23	1417.22	1417.72	6085.0
2012-05-01 22:00:00	ES	Futures	1417.47	1418.48	1416.71	1417.98	4633.0
2012-05-01 23:00:00	ES	Futures	1418.23	1419.24	1417.98	1418.99	1861.0
2012-05-01 00:00:00	NQ	Futures	3146.5	3149.68	3145.06	3148.82	527.0
2012-05-01 01:00:00	NQ	Futures	3148.53	3148.53	3144.77	3145.35	372.0
2012-05-01 02:00:00	NQ	Futures	3145.06	3145.92	3142.74	3145.35	258.0
2012-05-01 03:00:00	NQ	Futures	3145.35	3146.21	3143.9	3145.35	274.0
2012-05-01 04:00:00	NQ	Futures	3145.63	3146.79	3144.19	3144.77	336.0
2012-05-01 05:00:00	NQ	Futures	3144.77	3145.06	3138.98	3141.01	681.0
2012-05-01 06:00:00	NQ	Futures	3140.72	3144.48	3139.56	3144.48	680.0
2012-05-01 07:00:00	NQ	Futures	3144.77	3152.0	3143.9	3149.97	1468.0
2012-05-01 08:00:00	NQ	Futures	3149.97	3150.55	3145.63	3146.5	2907.0
2012-05-01 09:00:00	NQ	Futures	3146.5	3156.62	3135.51	3145.35	31199.0
2012-05-01 10:00:00	NQ	Futures	3145.35	3179.18	3145.35	3173.69	43941.0
2012-05-01 11:00:00	NQ	Futures	3173.69	3184.68	3173.11	3180.34	13992.0
2012-05-01 12:00:00	NQ	Futures	3180.34	3181.78	3174.84	3176.58	8843.0
2012-05-01 13:00:00	NQ	Futures	3176.58	3176.87	3163.85	3166.17	13251.0
2012-05-01 14:00:00	NQ	Futures	3166.17	3170.22	3159.52	3163.56	23663.0
2012-05-01 15:00:00	NQ	Futures	3163.85	3167.04	3148.53	3148.82	27185.0
2012-05-01 16:00:00	NQ	Futures	3149.1	3149.97	3142.74	3145.35	9466.0
2012-05-01 17:00:00	NQ	Futures	3145.35	3145.35	3143.03	3144.48	150.0
2012-05-01 18:00:00	NQ	Futures	3145.06	3147.08	3145.06	3145.35	313.0
2012-05-01 19:00:00	NQ	Futures	3146.21	3147.37	3145.06	3147.37	217.0
2012-05-01 20:00:00	NQ	Futures	3147.08	3147.37	3145.63	3146.21	284.0
2012-05-01 21:00:00	NQ	Futures	3145.92	3147.08	3144.48	3146.5	403.0
2012-05-01 22:00:00	NQ	Futures	3146.5	3148.24	3145.35	3147.37	437.0
2012-05-01 23:00:00	NQ	Futures	3147.08	3152.0	3147.08	3151.71	979.0
2012-05-01 00:00:00	YM	Futures	13122.3	13137.2	13119.3	13134.2	316.0
2012-05-01 01:00:00	YM	Futures	13133.2	13133.2	13119.3	13121.3	449.0

> showing 50 of 1,291 rows — these rows as CSV

> unlock the full archive -- $79 one-time