PREVIEW / futures_1hour / 2011-01-05

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-05.parquet
  size:    50 KB
  rows:    1,494

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
2011-01-05 00:00:00	ES	Futures	1248.76	1250.0	1248.76	1249.75	2173.0
2011-01-05 01:00:00	ES	Futures	1249.75	1249.75	1249.01	1249.51	2104.0
2011-01-05 02:00:00	ES	Futures	1249.26	1250.0	1248.52	1249.75	5810.0
2011-01-05 03:00:00	ES	Futures	1249.51	1249.75	1243.57	1246.04	39251.0
2011-01-05 04:00:00	ES	Futures	1245.8	1247.77	1245.05	1246.54	21816.0
2011-01-05 05:00:00	ES	Futures	1246.54	1246.54	1244.06	1244.31	27527.0
2011-01-05 06:00:00	ES	Futures	1244.31	1244.81	1242.83	1244.06	25215.0
2011-01-05 07:00:00	ES	Futures	1244.06	1245.3	1243.32	1244.81	23070.0
2011-01-05 08:00:00	ES	Futures	1244.81	1250.74	1244.31	1249.26	107446.0
2011-01-05 09:00:00	ES	Futures	1249.01	1251.49	1247.77	1250.74	205405.0
2011-01-05 10:00:00	ES	Futures	1250.74	1253.96	1250.0	1252.72	318701.0
2011-01-05 11:00:00	ES	Futures	1252.72	1258.41	1252.23	1257.42	296937.0
2011-01-05 12:00:00	ES	Futures	1257.42	1259.9	1256.93	1258.91	157462.0
2011-01-05 13:00:00	ES	Futures	1258.91	1259.65	1257.18	1259.4	117764.0
2011-01-05 14:00:00	ES	Futures	1259.4	1259.9	1257.42	1259.16	106063.0
2011-01-05 15:00:00	ES	Futures	1259.16	1260.64	1258.17	1259.65	199335.0
2011-01-05 16:00:00	ES	Futures	1259.65	1259.65	1257.67	1258.17	100472.0
2011-01-05 17:00:00	ES	Futures	1258.17	1258.41	1257.67	1258.17	1934.0
2011-01-05 18:00:00	ES	Futures	1257.92	1258.91	1257.92	1258.91	5756.0
2011-01-05 19:00:00	ES	Futures	1258.91	1258.91	1257.67	1257.67	6876.0
2011-01-05 20:00:00	ES	Futures	1257.92	1258.66	1257.67	1258.41	2878.0
2011-01-05 21:00:00	ES	Futures	1258.41	1258.66	1257.92	1258.17	2931.0
2011-01-05 22:00:00	ES	Futures	1258.41	1259.4	1258.41	1259.16	4619.0
2011-01-05 23:00:00	ES	Futures	1259.16	1259.16	1257.67	1257.92	2685.0
2011-01-05 00:00:00	NQ	Futures	2571.81	2573.82	2571.52	2573.82	83.0
2011-01-05 01:00:00	NQ	Futures	2573.53	2573.53	2572.38	2573.53	111.0
2011-01-05 02:00:00	NQ	Futures	2573.53	2574.97	2571.24	2574.11	657.0
2011-01-05 03:00:00	NQ	Futures	2573.82	2574.39	2560.62	2565.78	3832.0
2011-01-05 04:00:00	NQ	Futures	2565.5	2569.8	2564.63	2567.22	3126.0
2011-01-05 05:00:00	NQ	Futures	2567.22	2567.22	2562.34	2562.91	1763.0
2011-01-05 06:00:00	NQ	Futures	2562.91	2564.35	2559.76	2562.05	1801.0
2011-01-05 07:00:00	NQ	Futures	2562.34	2564.35	2561.48	2563.2	1667.0
2011-01-05 08:00:00	NQ	Futures	2563.49	2576.98	2563.49	2574.97	11852.0
2011-01-05 09:00:00	NQ	Futures	2574.97	2582.72	2574.11	2581.57	32844.0
2011-01-05 10:00:00	NQ	Futures	2581.86	2594.49	2581.0	2592.48	42274.0
2011-01-05 11:00:00	NQ	Futures	2592.48	2603.38	2591.9	2598.79	34173.0
2011-01-05 12:00:00	NQ	Futures	2599.08	2605.68	2597.93	2601.95	20713.0
2011-01-05 13:00:00	NQ	Futures	2602.24	2603.38	2599.37	2603.1	12404.0
2011-01-05 14:00:00	NQ	Futures	2603.1	2604.25	2599.37	2603.1	12506.0
2011-01-05 15:00:00	NQ	Futures	2603.1	2606.54	2602.81	2605.97	21407.0
2011-01-05 16:00:00	NQ	Futures	2605.68	2608.26	2604.82	2605.68	8714.0
2011-01-05 17:00:00	NQ	Futures	2605.97	2606.54	2605.68	2605.97	53.0
2011-01-05 18:00:00	NQ	Futures	2606.25	2607.98	2605.97	2607.69	329.0
2011-01-05 19:00:00	NQ	Futures	2607.4	2607.98	2605.68	2605.68	253.0
2011-01-05 20:00:00	NQ	Futures	2605.97	2607.4	2605.11	2606.83	180.0
2011-01-05 21:00:00	NQ	Futures	2606.83	2607.12	2605.68	2606.25	149.0
2011-01-05 22:00:00	NQ	Futures	2606.54	2608.55	2606.54	2607.69	186.0
2011-01-05 23:00:00	NQ	Futures	2607.4	2607.4	2605.68	2605.97	189.0
2011-01-05 00:00:00	YM	Futures	11100.7	11109.3	11100.7	11109.3	182.0
2011-01-05 01:00:00	YM	Futures	11107.4	11108.4	11101.7	11106.4	60.0

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

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