PREVIEW / futures_1hour / 2012-02-24

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-24.parquet
  size:    40 KB
  rows:    1,194

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-02-24 00:00:00	ES	Futures	1376.36	1377.62	1376.11	1376.11	3641.0
2012-02-24 01:00:00	ES	Futures	1376.36	1377.11	1375.6	1376.86	3890.0
2012-02-24 02:00:00	ES	Futures	1376.86	1377.87	1376.36	1377.37	7725.0
2012-02-24 03:00:00	ES	Futures	1377.37	1378.12	1374.59	1377.37	32756.0
2012-02-24 04:00:00	ES	Futures	1377.37	1378.88	1376.36	1378.37	28076.0
2012-02-24 05:00:00	ES	Futures	1378.37	1379.38	1376.86	1377.37	23264.0
2012-02-24 06:00:00	ES	Futures	1377.11	1378.63	1376.86	1377.87	16851.0
2012-02-24 07:00:00	ES	Futures	1377.87	1378.63	1375.85	1376.36	16813.0
2012-02-24 08:00:00	ES	Futures	1376.36	1377.11	1375.1	1376.11	34737.0
2012-02-24 09:00:00	ES	Futures	1376.11	1376.36	1373.33	1376.11	156882.0
2012-02-24 10:00:00	ES	Futures	1375.85	1377.11	1373.84	1374.59	169238.0
2012-02-24 11:00:00	ES	Futures	1374.59	1377.87	1374.34	1377.62	132586.0
2012-02-24 12:00:00	ES	Futures	1377.87	1377.87	1376.86	1377.62	65530.0
2012-02-24 13:00:00	ES	Futures	1377.37	1378.37	1374.59	1376.11	92287.0
2012-02-24 14:00:00	ES	Futures	1375.85	1376.61	1372.33	1373.84	116670.0
2012-02-24 15:00:00	ES	Futures	1373.84	1375.1	1372.83	1375.1	149957.0
2012-02-24 16:00:00	ES	Futures	1374.85	1375.35	1373.59	1373.59	72729.0
2012-02-24 00:00:00	NQ	Futures	3010.15	3011.88	3009.57	3009.57	286.0
2012-02-24 01:00:00	NQ	Futures	3009.86	3010.43	3007.83	3009.86	217.0
2012-02-24 02:00:00	NQ	Futures	3010.15	3012.17	3009.28	3010.43	651.0
2012-02-24 03:00:00	NQ	Futures	3010.72	3012.17	3004.95	3009.28	4087.0
2012-02-24 04:00:00	NQ	Futures	3009.57	3013.32	3007.55	3012.17	1584.0
2012-02-24 05:00:00	NQ	Futures	3012.17	3013.61	3007.83	3010.15	1806.0
2012-02-24 06:00:00	NQ	Futures	3009.57	3013.03	3009.28	3010.43	1416.0
2012-02-24 07:00:00	NQ	Futures	3010.72	3012.46	3006.39	3006.97	1278.0
2012-02-24 08:00:00	NQ	Futures	3007.26	3008.7	3005.81	3006.97	2483.0
2012-02-24 09:00:00	NQ	Futures	3006.97	3009.28	3002.35	3006.97	24160.0
2012-02-24 10:00:00	NQ	Futures	3006.97	3009.86	3001.19	3002.93	23394.0
2012-02-24 11:00:00	NQ	Futures	3002.93	3011.3	3002.06	3010.72	17839.0
2012-02-24 12:00:00	NQ	Futures	3010.72	3013.9	3009.86	3012.46	12283.0
2012-02-24 13:00:00	NQ	Futures	3012.46	3014.48	3008.99	3010.43	12949.0
2012-02-24 14:00:00	NQ	Futures	3010.43	3013.03	3002.64	3006.1	13759.0
2012-02-24 15:00:00	NQ	Futures	3006.1	3009.28	3004.37	3008.99	18230.0
2012-02-24 16:00:00	NQ	Futures	3008.99	3009.57	3005.24	3005.24	7641.0
2012-02-24 00:00:00	YM	Futures	12877.8	12885.8	12873.9	12873.9	203.0
2012-02-24 01:00:00	YM	Futures	12874.8	12879.8	12869.9	12877.8	189.0
2012-02-24 02:00:00	YM	Futures	12878.8	12887.7	12876.8	12881.8	656.0
2012-02-24 03:00:00	YM	Futures	12883.8	12890.7	12864.9	12884.8	1767.0
2012-02-24 04:00:00	YM	Futures	12884.8	12895.7	12877.8	12892.7	1146.0
2012-02-24 05:00:00	YM	Futures	12893.7	12899.6	12880.8	12884.8	965.0
2012-02-24 06:00:00	YM	Futures	12883.8	12896.7	12882.8	12886.7	948.0
2012-02-24 07:00:00	YM	Futures	12888.7	12892.7	12872.9	12874.8	1253.0
2012-02-24 08:00:00	YM	Futures	12875.8	12880.8	12865.9	12872.9	1944.0
2012-02-24 09:00:00	YM	Futures	12871.9	12878.8	12845.1	12864.9	13906.0
2012-02-24 10:00:00	YM	Futures	12863.9	12880.8	12835.2	12842.1	16994.0
2012-02-24 11:00:00	YM	Futures	12842.1	12876.8	12842.1	12876.8	8819.0
2012-02-24 12:00:00	YM	Futures	12876.8	12876.8	12865.9	12866.9	4618.0
2012-02-24 13:00:00	YM	Futures	12867.9	12874.8	12844.1	12855.0	5560.0
2012-02-24 14:00:00	YM	Futures	12855.0	12858.0	12813.4	12835.2	8654.0
2012-02-24 15:00:00	YM	Futures	12836.2	12851.1	12829.3	12850.1	9813.0

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

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