PREVIEW / futures_1hour / 2011-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-30.parquet
  size:    47 KB
  rows:    1,409

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-08-30 00:00:00	ES	Futures	1204.38	1204.63	1203.38	1204.13	2746.0
2011-08-30 01:00:00	ES	Futures	1204.13	1206.13	1203.88	1204.38	5713.0
2011-08-30 02:00:00	ES	Futures	1204.63	1204.88	1200.64	1202.13	18480.0
2011-08-30 03:00:00	ES	Futures	1202.13	1203.63	1199.64	1199.89	42908.0
2011-08-30 04:00:00	ES	Futures	1199.89	1201.89	1199.14	1199.89	26412.0
2011-08-30 05:00:00	ES	Futures	1200.14	1200.89	1195.65	1198.64	34888.0
2011-08-30 06:00:00	ES	Futures	1198.64	1200.39	1196.65	1200.14	22321.0
2011-08-30 07:00:00	ES	Futures	1199.89	1200.89	1197.4	1198.14	24689.0
2011-08-30 08:00:00	ES	Futures	1198.14	1198.14	1193.41	1194.9	57093.0
2011-08-30 09:00:00	ES	Futures	1194.9	1203.38	1194.65	1197.4	249452.0
2011-08-30 10:00:00	ES	Futures	1197.4	1200.14	1190.66	1197.15	498816.0
2011-08-30 11:00:00	ES	Futures	1197.4	1210.37	1196.15	1207.87	384392.0
2011-08-30 12:00:00	ES	Futures	1207.87	1208.37	1199.14	1200.89	187747.0
2011-08-30 13:00:00	ES	Futures	1200.64	1204.63	1198.89	1202.63	195244.0
2011-08-30 14:00:00	ES	Futures	1202.63	1210.61	1199.89	1210.12	286512.0
2011-08-30 15:00:00	ES	Futures	1209.87	1215.85	1207.37	1207.87	362049.0
2011-08-30 16:00:00	ES	Futures	1207.87	1207.87	1200.14	1201.39	116645.0
2011-08-30 17:00:00	ES	Futures	1201.14	1201.39	1199.39	1199.64	2742.0
2011-08-30 18:00:00	ES	Futures	1200.14	1202.13	1198.89	1199.64	4065.0
2011-08-30 19:00:00	ES	Futures	1199.39	1200.39	1198.39	1200.14	3715.0
2011-08-30 20:00:00	ES	Futures	1200.14	1201.64	1200.14	1201.14	5684.0
2011-08-30 21:00:00	ES	Futures	1201.14	1203.13	1199.64	1200.39	6859.0
2011-08-30 22:00:00	ES	Futures	1200.14	1202.38	1199.89	1202.13	2665.0
2011-08-30 23:00:00	ES	Futures	1202.13	1204.63	1201.64	1203.63	5087.0
2011-08-30 00:00:00	NQ	Futures	2554.78	2555.36	2553.34	2554.49	219.0
2011-08-30 01:00:00	NQ	Futures	2554.49	2558.23	2554.2	2555.07	332.0
2011-08-30 02:00:00	NQ	Futures	2555.07	2556.22	2547.59	2550.18	1439.0
2011-08-30 03:00:00	NQ	Futures	2550.18	2553.63	2546.15	2547.3	4290.0
2011-08-30 04:00:00	NQ	Futures	2547.01	2551.33	2545.86	2547.3	2352.0
2011-08-30 05:00:00	NQ	Futures	2547.3	2549.89	2539.24	2546.15	2479.0
2011-08-30 06:00:00	NQ	Futures	2545.86	2551.04	2543.27	2549.89	2225.0
2011-08-30 07:00:00	NQ	Futures	2549.89	2552.19	2545.28	2546.44	2157.0
2011-08-30 08:00:00	NQ	Futures	2546.44	2546.72	2536.36	2537.8	6322.0
2011-08-30 09:00:00	NQ	Futures	2537.8	2560.25	2537.51	2551.33	31832.0
2011-08-30 10:00:00	NQ	Futures	2549.02	2556.51	2533.77	2551.9	49491.0
2011-08-30 11:00:00	NQ	Futures	2551.9	2578.95	2549.6	2577.23	33607.0
2011-08-30 12:00:00	NQ	Futures	2577.51	2578.09	2556.22	2559.67	20505.0
2011-08-30 13:00:00	NQ	Futures	2559.38	2568.88	2555.36	2563.41	18664.0
2011-08-30 14:00:00	NQ	Futures	2563.13	2581.54	2559.67	2580.39	27443.0
2011-08-30 15:00:00	NQ	Futures	2580.39	2589.31	2572.91	2574.06	37640.0
2011-08-30 16:00:00	NQ	Futures	2573.77	2574.35	2559.1	2561.11	12214.0
2011-08-30 17:00:00	NQ	Futures	2560.54	2560.82	2557.95	2558.52	103.0
2011-08-30 18:00:00	NQ	Futures	2559.38	2562.55	2556.79	2558.52	321.0
2011-08-30 19:00:00	NQ	Futures	2558.52	2559.1	2557.08	2559.1	338.0
2011-08-30 20:00:00	NQ	Futures	2559.38	2562.26	2559.1	2561.11	354.0
2011-08-30 21:00:00	NQ	Futures	2561.69	2564.85	2557.37	2558.81	737.0
2011-08-30 22:00:00	NQ	Futures	2558.52	2562.84	2557.66	2562.84	477.0
2011-08-30 23:00:00	NQ	Futures	2562.84	2566.87	2561.69	2565.43	544.0
2011-08-30 00:00:00	YM	Futures	11145.3	11150.2	11137.6	11142.4	107.0
2011-08-30 01:00:00	YM	Futures	11142.4	11157.9	11140.5	11149.2	355.0

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

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