PREVIEW / futures_1hour / 2012-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-01.parquet
  size:    50 KB
  rows:    1,484

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-08-01 00:00:00	ES	Futures	1397.29	1397.54	1396.52	1397.03	2967.0
2012-08-01 01:00:00	ES	Futures	1397.03	1398.05	1396.78	1398.05	3693.0
2012-08-01 02:00:00	ES	Futures	1397.8	1398.56	1397.29	1397.8	6776.0
2012-08-01 03:00:00	ES	Futures	1398.05	1402.37	1397.8	1401.86	30911.0
2012-08-01 04:00:00	ES	Futures	1401.61	1403.14	1398.05	1401.36	32973.0
2012-08-01 05:00:00	ES	Futures	1401.1	1402.88	1400.85	1402.63	18213.0
2012-08-01 06:00:00	ES	Futures	1402.88	1404.15	1401.61	1401.86	16194.0
2012-08-01 07:00:00	ES	Futures	1401.86	1402.63	1400.59	1401.86	25324.0
2012-08-01 08:00:00	ES	Futures	1401.86	1403.64	1400.34	1403.14	43894.0
2012-08-01 09:00:00	ES	Futures	1403.14	1405.17	1400.34	1401.36	168965.0
2012-08-01 10:00:00	ES	Futures	1401.1	1403.39	1397.29	1402.37	275706.0
2012-08-01 11:00:00	ES	Futures	1402.37	1402.88	1399.58	1401.36	146694.0
2012-08-01 12:00:00	ES	Futures	1401.36	1402.88	1400.85	1402.37	65006.0
2012-08-01 13:00:00	ES	Futures	1402.37	1403.64	1399.07	1399.32	86469.0
2012-08-01 14:00:00	ES	Futures	1399.58	1400.34	1391.18	1397.03	464284.0
2012-08-01 15:00:00	ES	Futures	1397.29	1401.1	1393.47	1393.73	278112.0
2012-08-01 16:00:00	ES	Futures	1393.73	1395.25	1392.71	1393.22	86359.0
2012-08-01 17:00:00	ES	Futures	1393.47	1393.73	1391.95	1393.47	2915.0
2012-08-01 18:00:00	ES	Futures	1393.22	1396.02	1393.22	1395.51	3893.0
2012-08-01 19:00:00	ES	Futures	1395.51	1396.27	1394.74	1396.02	1960.0
2012-08-01 20:00:00	ES	Futures	1395.76	1396.02	1392.71	1393.98	6486.0
2012-08-01 21:00:00	ES	Futures	1393.98	1395.76	1393.73	1394.74	7203.0
2012-08-01 22:00:00	ES	Futures	1394.74	1397.29	1394.24	1396.78	6633.0
2012-08-01 23:00:00	ES	Futures	1396.78	1397.03	1396.27	1396.27	2143.0
2012-08-01 00:00:00	NQ	Futures	3059.16	3059.16	3057.13	3058.58	366.0
2012-08-01 01:00:00	NQ	Futures	3058.58	3060.32	3058.29	3060.03	336.0
2012-08-01 02:00:00	NQ	Futures	3060.03	3061.76	3059.45	3061.48	551.0
2012-08-01 03:00:00	NQ	Futures	3061.19	3071.91	3061.19	3071.33	3073.0
2012-08-01 04:00:00	NQ	Futures	3071.33	3073.36	3062.63	3069.59	3152.0
2012-08-01 05:00:00	NQ	Futures	3069.01	3071.62	3068.14	3071.33	1899.0
2012-08-01 06:00:00	NQ	Futures	3071.33	3074.52	3070.46	3070.46	1530.0
2012-08-01 07:00:00	NQ	Futures	3070.46	3070.75	3065.82	3070.17	3250.0
2012-08-01 08:00:00	NQ	Futures	3069.88	3077.13	3068.14	3074.52	7074.0
2012-08-01 09:00:00	NQ	Futures	3075.1	3080.03	3062.05	3064.08	26924.0
2012-08-01 10:00:00	NQ	Futures	3063.79	3070.17	3054.81	3062.34	37140.0
2012-08-01 11:00:00	NQ	Futures	3062.34	3064.37	3054.23	3056.26	17843.0
2012-08-01 12:00:00	NQ	Futures	3056.26	3063.21	3054.23	3061.19	19374.0
2012-08-01 13:00:00	NQ	Futures	3061.19	3064.66	3053.07	3053.94	31792.0
2012-08-01 14:00:00	NQ	Futures	3053.94	3058.87	3036.26	3053.36	48056.0
2012-08-01 15:00:00	NQ	Futures	3053.36	3062.92	3046.4	3048.43	36933.0
2012-08-01 16:00:00	NQ	Futures	3048.72	3050.17	3042.34	3044.37	7475.0
2012-08-01 17:00:00	NQ	Futures	3044.37	3044.37	3040.6	3043.79	134.0
2012-08-01 18:00:00	NQ	Futures	3043.21	3047.27	3042.92	3046.98	540.0
2012-08-01 19:00:00	NQ	Futures	3046.98	3049.01	3045.24	3048.14	356.0
2012-08-01 20:00:00	NQ	Futures	3047.85	3048.43	3041.18	3044.08	778.0
2012-08-01 21:00:00	NQ	Futures	3043.79	3048.14	3043.79	3046.11	957.0
2012-08-01 22:00:00	NQ	Futures	3045.82	3050.75	3044.95	3050.46	947.0
2012-08-01 23:00:00	NQ	Futures	3050.17	3050.46	3048.43	3049.01	391.0
2012-08-01 00:00:00	YM	Futures	12885.5	12885.5	12876.5	12880.5	189.0
2012-08-01 01:00:00	YM	Futures	12881.5	12892.4	12881.5	12889.4	311.0

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

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