PREVIEW / futures_1hour / 2012-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-05.parquet
  size:    46 KB
  rows:    1,393

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-07-05 00:00:00	ES	Futures	1385.84	1387.88	1385.59	1387.12	2220.0
2012-07-05 01:00:00	ES	Futures	1387.12	1388.13	1386.35	1387.12	5696.0
2012-07-05 02:00:00	ES	Futures	1387.12	1390.17	1387.12	1389.15	7625.0
2012-07-05 03:00:00	ES	Futures	1389.15	1389.4	1387.37	1388.9	20118.0
2012-07-05 04:00:00	ES	Futures	1388.9	1392.96	1388.64	1391.69	25640.0
2012-07-05 05:00:00	ES	Futures	1391.44	1392.46	1390.93	1391.69	12671.0
2012-07-05 06:00:00	ES	Futures	1391.44	1397.8	1390.42	1397.8	22135.0
2012-07-05 07:00:00	ES	Futures	1397.8	1398.56	1388.64	1390.68	121097.0
2012-07-05 08:00:00	ES	Futures	1390.68	1396.52	1385.08	1387.88	158097.0
2012-07-05 09:00:00	ES	Futures	1387.88	1390.17	1382.79	1383.56	296142.0
2012-07-05 10:00:00	ES	Futures	1383.56	1387.37	1380.25	1386.35	319228.0
2012-07-05 11:00:00	ES	Futures	1386.61	1389.15	1386.35	1387.12	212580.0
2012-07-05 12:00:00	ES	Futures	1387.37	1388.9	1385.59	1387.37	102047.0
2012-07-05 13:00:00	ES	Futures	1387.37	1391.18	1387.12	1390.93	109060.0
2012-07-05 14:00:00	ES	Futures	1390.93	1391.69	1388.13	1388.13	69097.0
2012-07-05 15:00:00	ES	Futures	1388.39	1389.4	1384.83	1385.84	192487.0
2012-07-05 16:00:00	ES	Futures	1385.84	1386.61	1383.05	1386.35	77747.0
2012-07-05 17:00:00	ES	Futures	1386.1	1386.1	1385.34	1385.59	1139.0
2012-07-05 18:00:00	ES	Futures	1385.34	1385.84	1384.32	1385.34	2419.0
2012-07-05 19:00:00	ES	Futures	1385.59	1386.35	1385.34	1386.35	1347.0
2012-07-05 20:00:00	ES	Futures	1386.1	1387.37	1384.57	1385.08	5857.0
2012-07-05 21:00:00	ES	Futures	1384.83	1385.34	1382.54	1382.79	8532.0
2012-07-05 22:00:00	ES	Futures	1382.79	1384.57	1382.28	1383.56	3517.0
2012-07-05 23:00:00	ES	Futures	1383.56	1383.56	1381.78	1382.54	2470.0
2012-07-05 00:00:00	NQ	Futures	3052.2	3056.55	3051.91	3056.55	359.0
2012-07-05 01:00:00	NQ	Futures	3055.97	3056.55	3054.52	3056.55	567.0
2012-07-05 02:00:00	NQ	Futures	3056.55	3060.61	3056.26	3059.74	780.0
2012-07-05 03:00:00	NQ	Futures	3059.45	3060.9	3056.26	3060.03	2564.0
2012-07-05 04:00:00	NQ	Futures	3060.32	3066.69	3060.03	3064.95	2817.0
2012-07-05 05:00:00	NQ	Futures	3064.95	3066.11	3063.21	3064.66	1534.0
2012-07-05 06:00:00	NQ	Futures	3064.66	3075.39	3062.34	3074.81	1918.0
2012-07-05 07:00:00	NQ	Futures	3074.81	3077.42	3054.81	3058.87	12203.0
2012-07-05 08:00:00	NQ	Futures	3058.58	3068.72	3051.62	3057.13	13351.0
2012-07-05 09:00:00	NQ	Futures	3057.42	3064.08	3049.3	3051.62	36977.0
2012-07-05 10:00:00	NQ	Futures	3051.62	3067.56	3043.21	3066.4	38944.0
2012-07-05 11:00:00	NQ	Futures	3066.4	3073.94	3064.66	3067.56	24918.0
2012-07-05 12:00:00	NQ	Futures	3067.27	3071.62	3065.82	3069.3	10481.0
2012-07-05 13:00:00	NQ	Futures	3069.01	3078.0	3067.85	3077.71	13903.0
2012-07-05 14:00:00	NQ	Futures	3077.42	3079.45	3069.59	3069.59	11315.0
2012-07-05 15:00:00	NQ	Futures	3069.88	3073.94	3063.5	3064.66	22528.0
2012-07-05 16:00:00	NQ	Futures	3064.66	3066.69	3060.32	3064.95	6519.0
2012-07-05 17:00:00	NQ	Futures	3064.95	3065.24	3062.34	3062.92	137.0
2012-07-05 18:00:00	NQ	Futures	3062.92	3062.92	3060.61	3062.34	184.0
2012-07-05 19:00:00	NQ	Futures	3062.63	3064.37	3062.63	3064.37	89.0
2012-07-05 20:00:00	NQ	Futures	3064.08	3065.53	3060.9	3061.48	779.0
2012-07-05 21:00:00	NQ	Futures	3061.48	3062.34	3057.13	3057.71	901.0
2012-07-05 22:00:00	NQ	Futures	3057.71	3061.19	3056.84	3059.74	512.0
2012-07-05 23:00:00	NQ	Futures	3059.16	3059.16	3056.26	3057.42	281.0
2012-07-05 00:00:00	YM	Futures	12751.2	12764.2	12749.2	12762.2	379.0
2012-07-05 01:00:00	YM	Futures	12761.2	12764.2	12756.2	12763.2	434.0

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

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