PREVIEW / futures_1hour / 2012-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-05.parquet
  size:    44 KB
  rows:    1,323

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-04-05 00:00:00	ES	Futures	1411.65	1412.66	1411.15	1412.41	1940.0
2012-04-05 01:00:00	ES	Futures	1412.16	1413.68	1412.16	1412.92	6262.0
2012-04-05 02:00:00	ES	Futures	1413.17	1414.44	1412.66	1412.66	8123.0
2012-04-05 03:00:00	ES	Futures	1412.66	1413.93	1411.4	1413.42	25174.0
2012-04-05 04:00:00	ES	Futures	1413.42	1413.68	1406.09	1408.11	40441.0
2012-04-05 05:00:00	ES	Futures	1408.11	1409.63	1401.53	1402.55	73697.0
2012-04-05 06:00:00	ES	Futures	1402.55	1405.33	1400.52	1405.08	42881.0
2012-04-05 07:00:00	ES	Futures	1404.82	1405.58	1403.05	1405.58	38769.0
2012-04-05 08:00:00	ES	Futures	1405.33	1406.34	1401.79	1405.08	84401.0
2012-04-05 09:00:00	ES	Futures	1405.08	1410.13	1404.06	1408.36	231798.0
2012-04-05 10:00:00	ES	Futures	1408.11	1413.17	1408.11	1413.17	245881.0
2012-04-05 11:00:00	ES	Futures	1412.92	1413.93	1410.13	1411.65	184257.0
2012-04-05 12:00:00	ES	Futures	1411.65	1412.41	1409.12	1409.63	106974.0
2012-04-05 13:00:00	ES	Futures	1409.63	1410.89	1406.09	1407.6	96535.0
2012-04-05 14:00:00	ES	Futures	1407.6	1410.13	1407.1	1409.38	74190.0
2012-04-05 15:00:00	ES	Futures	1409.63	1411.15	1408.36	1409.38	154509.0
2012-04-05 16:00:00	ES	Futures	1409.63	1409.63	1406.09	1407.86	77254.0
2012-04-05 17:00:00	ES	Futures	1407.6	1408.11	1407.35	1407.86	892.0
2012-04-05 18:00:00	ES	Futures	1407.6	1408.36	1407.1	1407.86	1987.0
2012-04-05 19:00:00	ES	Futures	1408.11	1408.36	1406.85	1408.11	1283.0
2012-04-05 20:00:00	ES	Futures	1408.11	1410.89	1407.35	1410.89	4844.0
2012-04-05 21:00:00	ES	Futures	1410.89	1410.89	1409.38	1409.63	2048.0
2012-04-05 22:00:00	ES	Futures	1409.38	1410.13	1409.38	1409.88	423.0
2012-04-05 23:00:00	ES	Futures	1410.13	1410.13	1408.62	1408.87	1175.0
2012-04-05 00:00:00	NQ	Futures	3171.37	3173.4	3170.22	3173.11	248.0
2012-04-05 01:00:00	NQ	Futures	3173.4	3175.13	3172.53	3174.27	542.0
2012-04-05 02:00:00	NQ	Futures	3173.98	3176.0	3172.24	3173.4	710.0
2012-04-05 03:00:00	NQ	Futures	3173.4	3176.58	3170.22	3175.42	2230.0
2012-04-05 04:00:00	NQ	Futures	3175.71	3176.29	3158.94	3164.14	4628.0
2012-04-05 05:00:00	NQ	Futures	3163.85	3167.04	3150.26	3152.86	5980.0
2012-04-05 06:00:00	NQ	Futures	3152.58	3161.25	3149.39	3160.67	4068.0
2012-04-05 07:00:00	NQ	Futures	3160.67	3162.7	3156.62	3162.7	3613.0
2012-04-05 08:00:00	NQ	Futures	3162.7	3167.61	3155.18	3163.56	10450.0
2012-04-05 09:00:00	NQ	Futures	3163.56	3174.27	3161.83	3169.35	32736.0
2012-04-05 10:00:00	NQ	Futures	3169.35	3183.23	3168.19	3182.94	41514.0
2012-04-05 11:00:00	NQ	Futures	3183.23	3189.3	3181.78	3189.3	28087.0
2012-04-05 12:00:00	NQ	Futures	3189.3	3193.35	3186.99	3188.15	22742.0
2012-04-05 13:00:00	NQ	Futures	3188.44	3191.62	3182.94	3186.12	16523.0
2012-04-05 14:00:00	NQ	Futures	3186.12	3191.04	3183.81	3189.3	12206.0
2012-04-05 15:00:00	NQ	Futures	3189.59	3193.64	3185.54	3190.46	27908.0
2012-04-05 16:00:00	NQ	Futures	3190.46	3190.75	3185.83	3188.73	8464.0
2012-04-05 17:00:00	NQ	Futures	3189.01	3189.3	3188.44	3188.44	63.0
2012-04-05 18:00:00	NQ	Futures	3185.83	3189.3	3185.83	3189.01	196.0
2012-04-05 19:00:00	NQ	Futures	3188.15	3188.44	3185.25	3187.28	278.0
2012-04-05 20:00:00	NQ	Futures	3186.99	3194.22	3186.99	3194.22	411.0
2012-04-05 21:00:00	NQ	Futures	3193.93	3194.22	3191.62	3191.62	241.0
2012-04-05 22:00:00	NQ	Futures	3191.62	3192.48	3191.62	3192.48	94.0
2012-04-05 23:00:00	NQ	Futures	3192.48	3192.77	3190.46	3191.04	138.0
2012-04-05 00:00:00	YM	Futures	12970.8	12978.8	12966.8	12976.8	384.0
2012-04-05 01:00:00	YM	Futures	12975.8	12984.8	12974.8	12979.8	590.0

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

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