PREVIEW / futures_1hour / 2012-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-08.parquet
  size:    42 KB
  rows:    1,206

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-06-08 00:00:00	ES	Futures	1324.88	1326.65	1324.37	1326.4	2789.0
2012-06-08 01:00:00	ES	Futures	1326.65	1326.65	1323.36	1324.37	3713.0
2012-06-08 02:00:00	ES	Futures	1324.63	1326.9	1323.11	1325.64	8025.0
2012-06-08 03:00:00	ES	Futures	1325.64	1327.41	1322.1	1324.12	22517.0
2012-06-08 04:00:00	ES	Futures	1324.12	1324.37	1321.08	1323.36	22956.0
2012-06-08 05:00:00	ES	Futures	1323.36	1330.44	1322.6	1328.67	23763.0
2012-06-08 06:00:00	ES	Futures	1328.67	1330.19	1323.11	1324.63	23228.0
2012-06-08 07:00:00	ES	Futures	1324.63	1328.67	1323.87	1327.66	18260.0
2012-06-08 08:00:00	ES	Futures	1327.66	1330.19	1324.88	1327.16	52984.0
2012-06-08 09:00:00	ES	Futures	1327.16	1330.44	1322.6	1325.89	116435.0
2012-06-08 10:00:00	ES	Futures	1325.89	1333.23	1324.88	1332.72	134449.0
2012-06-08 11:00:00	ES	Futures	1332.72	1333.23	1329.94	1330.19	67085.0
2012-06-08 12:00:00	ES	Futures	1330.19	1336.01	1330.19	1335.76	56726.0
2012-06-08 13:00:00	ES	Futures	1335.76	1338.79	1335.5	1336.77	54817.0
2012-06-08 14:00:00	ES	Futures	1337.02	1339.81	1336.26	1337.53	36483.0
2012-06-08 15:00:00	ES	Futures	1337.53	1341.32	1337.28	1340.82	77079.0
2012-06-08 16:00:00	ES	Futures	1341.07	1345.37	1340.06	1345.12	33687.0
2012-06-08 00:00:00	NQ	Futures	2922.66	2927.58	2921.21	2927.58	364.0
2012-06-08 01:00:00	NQ	Futures	2927.0	2927.29	2920.64	2922.66	371.0
2012-06-08 02:00:00	NQ	Futures	2923.24	2927.58	2920.93	2924.97	714.0
2012-06-08 03:00:00	NQ	Futures	2924.69	2927.87	2916.88	2919.48	2268.0
2012-06-08 04:00:00	NQ	Futures	2919.48	2919.48	2912.54	2916.59	2129.0
2012-06-08 05:00:00	NQ	Futures	2916.01	2929.89	2915.14	2925.84	1988.0
2012-06-08 06:00:00	NQ	Futures	2926.13	2929.02	2916.3	2918.9	1640.0
2012-06-08 07:00:00	NQ	Futures	2918.9	2927.87	2916.88	2925.26	1631.0
2012-06-08 08:00:00	NQ	Futures	2925.55	2931.34	2920.35	2924.97	3562.0
2012-06-08 09:00:00	NQ	Futures	2924.97	2932.49	2916.59	2929.31	14713.0
2012-06-08 10:00:00	NQ	Futures	2929.31	2948.98	2926.42	2947.82	16647.0
2012-06-08 11:00:00	NQ	Futures	2948.11	2948.69	2939.43	2940.01	6261.0
2012-06-08 12:00:00	NQ	Futures	2939.72	2948.69	2937.99	2946.09	6692.0
2012-06-08 13:00:00	NQ	Futures	2946.09	2955.05	2945.51	2950.71	5948.0
2012-06-08 14:00:00	NQ	Futures	2950.42	2955.92	2948.69	2952.74	3884.0
2012-06-08 15:00:00	NQ	Futures	2952.74	2963.44	2951.87	2959.68	10614.0
2012-06-08 16:00:00	NQ	Futures	2959.1	2966.33	2957.36	2966.04	2294.0
2012-06-08 00:00:00	YM	Futures	12373.0	12388.0	12369.1	12387.0	343.0
2012-06-08 01:00:00	YM	Futures	12386.0	12386.0	12363.1	12374.0	330.0
2012-06-08 02:00:00	YM	Futures	12372.0	12385.0	12361.1	12380.0	585.0
2012-06-08 03:00:00	YM	Futures	12379.0	12389.0	12351.1	12361.1	1188.0
2012-06-08 04:00:00	YM	Futures	12363.1	12363.1	12338.2	12357.1	1067.0
2012-06-08 05:00:00	YM	Futures	12357.1	12418.9	12351.1	12403.9	1638.0
2012-06-08 06:00:00	YM	Futures	12402.9	12412.9	12361.1	12373.0	790.0
2012-06-08 07:00:00	YM	Futures	12372.0	12402.9	12368.1	12393.0	604.0
2012-06-08 08:00:00	YM	Futures	12393.0	12404.9	12362.1	12374.0	3520.0
2012-06-08 09:00:00	YM	Futures	12374.0	12399.9	12344.2	12375.0	7804.0
2012-06-08 10:00:00	YM	Futures	12376.0	12434.8	12365.1	12430.8	8491.0
2012-06-08 11:00:00	YM	Futures	12431.8	12434.8	12407.9	12414.9	3969.0
2012-06-08 12:00:00	YM	Futures	12414.9	12462.7	12409.9	12459.7	3090.0
2012-06-08 13:00:00	YM	Futures	12459.7	12485.6	12458.7	12470.7	3405.0
2012-06-08 14:00:00	YM	Futures	12468.7	12490.6	12461.7	12471.7	2229.0
2012-06-08 15:00:00	YM	Futures	12472.7	12500.6	12464.7	12499.6	5382.0

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

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