PREVIEW / futures_1hour / 2012-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-14.parquet
  size:    48 KB
  rows:    1,468

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-03-14 00:00:00	ES	Futures	1407.6	1407.6	1406.09	1406.34	2644.0
2012-03-14 01:00:00	ES	Futures	1406.34	1406.59	1404.06	1404.06	5125.0
2012-03-14 02:00:00	ES	Futures	1404.32	1405.08	1403.3	1405.08	7464.0
2012-03-14 03:00:00	ES	Futures	1404.82	1406.59	1404.82	1406.34	8680.0
2012-03-14 04:00:00	ES	Futures	1406.59	1406.59	1404.82	1406.59	42281.0
2012-03-14 05:00:00	ES	Futures	1406.59	1408.36	1406.09	1408.11	34315.0
2012-03-14 06:00:00	ES	Futures	1407.86	1410.39	1407.6	1410.13	36491.0
2012-03-14 07:00:00	ES	Futures	1410.13	1410.13	1406.09	1406.34	45936.0
2012-03-14 08:00:00	ES	Futures	1406.34	1407.6	1405.83	1407.6	48861.0
2012-03-14 09:00:00	ES	Futures	1407.6	1409.63	1406.09	1409.12	204767.0
2012-03-14 10:00:00	ES	Futures	1409.12	1410.89	1405.83	1406.34	294530.0
2012-03-14 11:00:00	ES	Futures	1406.09	1406.85	1404.06	1405.58	212199.0
2012-03-14 12:00:00	ES	Futures	1405.33	1407.35	1404.32	1406.85	133712.0
2012-03-14 13:00:00	ES	Futures	1407.1	1409.38	1402.8	1403.3	188047.0
2012-03-14 14:00:00	ES	Futures	1403.05	1404.57	1401.53	1403.81	178692.0
2012-03-14 15:00:00	ES	Futures	1403.81	1405.83	1400.77	1405.33	187843.0
2012-03-14 16:00:00	ES	Futures	1405.33	1405.83	1403.05	1403.05	53837.0
2012-03-14 17:00:00	ES	Futures	1403.3	1403.3	1401.28	1401.53	3695.0
2012-03-14 18:00:00	ES	Futures	1401.79	1403.3	1401.28	1403.3	3779.0
2012-03-14 19:00:00	ES	Futures	1403.3	1404.06	1403.05	1403.81	4088.0
2012-03-14 20:00:00	ES	Futures	1403.81	1406.09	1403.56	1405.58	8056.0
2012-03-14 21:00:00	ES	Futures	1405.33	1407.6	1405.08	1406.09	7487.0
2012-03-14 22:00:00	ES	Futures	1406.09	1407.35	1405.08	1407.1	5995.0
2012-03-14 23:00:00	ES	Futures	1406.85	1407.6	1406.59	1407.6	2192.0
2012-03-14 00:00:00	NQ	Futures	3114.98	3114.98	3112.67	3112.95	185.0
2012-03-14 01:00:00	NQ	Futures	3112.67	3113.24	3108.62	3109.2	315.0
2012-03-14 02:00:00	NQ	Futures	3108.62	3111.22	3107.75	3110.06	844.0
2012-03-14 03:00:00	NQ	Futures	3110.06	3115.27	3110.06	3114.98	1374.0
2012-03-14 04:00:00	NQ	Futures	3114.98	3116.14	3111.8	3115.27	3011.0
2012-03-14 05:00:00	NQ	Futures	3115.85	3118.74	3114.69	3116.43	3064.0
2012-03-14 06:00:00	NQ	Futures	3116.14	3122.21	3115.56	3121.63	3866.0
2012-03-14 07:00:00	NQ	Futures	3121.34	3121.63	3112.95	3112.95	5511.0
2012-03-14 08:00:00	NQ	Futures	3112.67	3117.0	3112.67	3116.43	6474.0
2012-03-14 09:00:00	NQ	Futures	3117.0	3129.15	3116.14	3126.26	45127.0
2012-03-14 10:00:00	NQ	Futures	3126.26	3134.64	3123.37	3128.86	40560.0
2012-03-14 11:00:00	NQ	Futures	3128.86	3129.73	3120.47	3124.52	29265.0
2012-03-14 12:00:00	NQ	Futures	3124.81	3130.6	3120.47	3129.15	18428.0
2012-03-14 13:00:00	NQ	Futures	3129.44	3139.27	3119.03	3121.05	37506.0
2012-03-14 14:00:00	NQ	Futures	3120.76	3123.66	3108.62	3120.47	37764.0
2012-03-14 15:00:00	NQ	Futures	3120.47	3128.86	3114.11	3128.57	33712.0
2012-03-14 16:00:00	NQ	Futures	3128.57	3128.86	3123.08	3123.37	5245.0
2012-03-14 17:00:00	NQ	Futures	3123.66	3123.66	3120.76	3120.76	179.0
2012-03-14 18:00:00	NQ	Futures	3121.92	3122.5	3119.9	3122.5	306.0
2012-03-14 19:00:00	NQ	Futures	3122.79	3124.23	3122.79	3123.66	278.0
2012-03-14 20:00:00	NQ	Futures	3123.94	3128.57	3123.94	3127.7	350.0
2012-03-14 21:00:00	NQ	Futures	3127.41	3132.91	3126.26	3130.02	562.0
2012-03-14 22:00:00	NQ	Futures	3129.44	3133.2	3127.41	3133.2	491.0
2012-03-14 23:00:00	NQ	Futures	3132.91	3134.64	3132.62	3134.36	434.0
2012-03-14 00:00:00	YM	Futures	13071.5	13071.5	13060.5	13060.5	289.0
2012-03-14 01:00:00	YM	Futures	13061.5	13064.5	13041.6	13041.6	631.0

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

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