PREVIEW / futures_1hour / 2012-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-26.parquet
  size:    50 KB
  rows:    1,516

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-26 00:00:00	ES	Futures	1405.08	1405.33	1403.81	1403.81	3381.0
2012-04-26 01:00:00	ES	Futures	1403.81	1404.32	1402.8	1404.06	6215.0
2012-04-26 02:00:00	ES	Futures	1404.06	1406.09	1403.81	1405.58	7923.0
2012-04-26 03:00:00	ES	Futures	1405.33	1408.87	1403.56	1407.86	46853.0
2012-04-26 04:00:00	ES	Futures	1407.86	1408.62	1405.08	1405.08	26967.0
2012-04-26 05:00:00	ES	Futures	1405.33	1406.34	1401.79	1402.55	30186.0
2012-04-26 06:00:00	ES	Futures	1402.55	1403.05	1400.02	1402.29	27465.0
2012-04-26 07:00:00	ES	Futures	1402.29	1403.56	1401.03	1403.05	29295.0
2012-04-26 08:00:00	ES	Futures	1403.05	1404.06	1397.49	1400.02	120759.0
2012-04-26 09:00:00	ES	Futures	1399.76	1403.3	1398.75	1402.29	215640.0
2012-04-26 10:00:00	ES	Futures	1402.55	1405.83	1402.04	1402.8	311260.0
2012-04-26 11:00:00	ES	Futures	1402.8	1406.34	1402.55	1405.08	175399.0
2012-04-26 12:00:00	ES	Futures	1405.33	1406.09	1404.06	1405.83	91824.0
2012-04-26 13:00:00	ES	Futures	1405.83	1411.4	1405.08	1411.15	143275.0
2012-04-26 14:00:00	ES	Futures	1411.15	1413.93	1410.89	1413.17	114809.0
2012-04-26 15:00:00	ES	Futures	1413.17	1414.94	1411.65	1412.92	211793.0
2012-04-26 16:00:00	ES	Futures	1412.92	1415.7	1411.4	1411.91	82190.0
2012-04-26 17:00:00	ES	Futures	1411.91	1411.91	1407.1	1407.86	20004.0
2012-04-26 18:00:00	ES	Futures	1407.6	1408.11	1405.83	1407.1	22481.0
2012-04-26 19:00:00	ES	Futures	1406.85	1408.11	1406.34	1407.1	5204.0
2012-04-26 20:00:00	ES	Futures	1407.1	1409.88	1406.59	1409.63	9580.0
2012-04-26 21:00:00	ES	Futures	1409.63	1410.39	1408.36	1409.12	6980.0
2012-04-26 22:00:00	ES	Futures	1409.12	1409.38	1407.6	1408.11	3554.0
2012-04-26 23:00:00	ES	Futures	1408.36	1410.13	1407.6	1409.38	5645.0
2012-04-26 00:00:00	NQ	Futures	3131.46	3131.75	3127.7	3127.99	360.0
2012-04-26 01:00:00	NQ	Futures	3127.99	3128.86	3126.55	3128.86	606.0
2012-04-26 02:00:00	NQ	Futures	3128.86	3133.2	3127.7	3131.17	1107.0
2012-04-26 03:00:00	NQ	Futures	3131.17	3139.27	3126.55	3136.96	4376.0
2012-04-26 04:00:00	NQ	Futures	3136.96	3138.4	3130.31	3130.6	2235.0
2012-04-26 05:00:00	NQ	Futures	3130.6	3132.91	3123.66	3124.81	2851.0
2012-04-26 06:00:00	NQ	Futures	3124.52	3124.81	3119.9	3123.66	2511.0
2012-04-26 07:00:00	NQ	Futures	3123.66	3127.41	3121.34	3127.13	3484.0
2012-04-26 08:00:00	NQ	Futures	3127.13	3130.31	3117.58	3123.37	12240.0
2012-04-26 09:00:00	NQ	Futures	3123.08	3139.85	3121.05	3131.46	41673.0
2012-04-26 10:00:00	NQ	Futures	3131.46	3138.98	3125.1	3127.7	32646.0
2012-04-26 11:00:00	NQ	Futures	3127.7	3134.36	3124.52	3130.02	18203.0
2012-04-26 12:00:00	NQ	Futures	3130.31	3131.17	3126.84	3128.86	11172.0
2012-04-26 13:00:00	NQ	Futures	3129.15	3146.79	3129.15	3145.35	17999.0
2012-04-26 14:00:00	NQ	Futures	3145.35	3153.73	3144.19	3152.29	16620.0
2012-04-26 15:00:00	NQ	Futures	3152.29	3154.6	3144.48	3147.37	29330.0
2012-04-26 16:00:00	NQ	Futures	3147.37	3157.78	3142.16	3150.84	10533.0
2012-04-26 17:00:00	NQ	Futures	3150.55	3150.84	3142.45	3143.9	2391.0
2012-04-26 18:00:00	NQ	Futures	3142.74	3144.19	3140.14	3142.45	1179.0
2012-04-26 19:00:00	NQ	Futures	3142.16	3143.9	3140.43	3141.59	385.0
2012-04-26 20:00:00	NQ	Futures	3141.59	3147.95	3141.3	3147.37	523.0
2012-04-26 21:00:00	NQ	Futures	3147.37	3149.1	3144.48	3146.21	481.0
2012-04-26 22:00:00	NQ	Futures	3146.21	3147.08	3143.03	3144.48	383.0
2012-04-26 23:00:00	NQ	Futures	3144.77	3148.53	3143.61	3147.95	366.0
2012-04-26 00:00:00	YM	Futures	12998.7	12998.7	12989.8	12991.7	344.0
2012-04-26 01:00:00	YM	Futures	12991.7	12994.7	12983.8	12994.7	854.0

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

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