PREVIEW / futures_1hour / 2011-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-29.parquet
  size:    49 KB
  rows:    1,477

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-11-29 00:00:00	ES	Futures	1194.61	1202.64	1194.61	1202.64	17152.0
2011-11-29 01:00:00	ES	Futures	1202.64	1202.89	1200.63	1201.38	7487.0
2011-11-29 02:00:00	ES	Futures	1201.38	1201.38	1197.12	1197.37	13730.0
2011-11-29 03:00:00	ES	Futures	1197.37	1197.37	1190.1	1192.1	43485.0
2011-11-29 04:00:00	ES	Futures	1192.35	1200.63	1191.85	1200.13	33071.0
2011-11-29 05:00:00	ES	Futures	1200.13	1209.66	1199.63	1207.15	81557.0
2011-11-29 06:00:00	ES	Futures	1207.4	1208.15	1204.39	1204.89	49458.0
2011-11-29 07:00:00	ES	Futures	1205.14	1205.39	1200.13	1200.63	71221.0
2011-11-29 08:00:00	ES	Futures	1200.88	1202.38	1196.37	1199.12	80985.0
2011-11-29 09:00:00	ES	Futures	1199.12	1200.88	1194.11	1199.63	292026.0
2011-11-29 10:00:00	ES	Futures	1199.63	1206.65	1197.87	1202.64	481784.0
2011-11-29 11:00:00	ES	Futures	1202.64	1206.15	1199.63	1202.38	298983.0
2011-11-29 12:00:00	ES	Futures	1202.13	1205.39	1200.13	1202.13	172432.0
2011-11-29 13:00:00	ES	Futures	1201.88	1202.89	1196.12	1197.12	185309.0
2011-11-29 14:00:00	ES	Futures	1197.12	1201.38	1195.61	1199.88	163968.0
2011-11-29 15:00:00	ES	Futures	1199.63	1204.39	1197.37	1198.12	274514.0
2011-11-29 16:00:00	ES	Futures	1198.37	1201.13	1192.35	1194.11	105176.0
2011-11-29 17:00:00	ES	Futures	1193.86	1194.86	1192.61	1194.61	4624.0
2011-11-29 18:00:00	ES	Futures	1195.36	1196.62	1192.61	1193.61	11497.0
2011-11-29 19:00:00	ES	Futures	1193.61	1196.62	1192.61	1195.87	8434.0
2011-11-29 20:00:00	ES	Futures	1195.61	1196.62	1193.86	1194.36	7571.0
2011-11-29 21:00:00	ES	Futures	1194.11	1196.12	1193.11	1193.61	5820.0
2011-11-29 22:00:00	ES	Futures	1193.86	1193.86	1190.35	1192.1	11182.0
2011-11-29 23:00:00	ES	Futures	1192.1	1193.11	1191.35	1192.35	4369.0
2011-11-29 00:00:00	NQ	Futures	2561.75	2576.74	2561.75	2575.87	1563.0
2011-11-29 01:00:00	NQ	Futures	2575.87	2576.45	2572.7	2572.99	621.0
2011-11-29 02:00:00	NQ	Futures	2572.99	2573.85	2566.07	2566.36	1176.0
2011-11-29 03:00:00	NQ	Futures	2565.78	2565.78	2551.94	2555.4	3365.0
2011-11-29 04:00:00	NQ	Futures	2555.69	2571.55	2554.83	2570.39	2509.0
2011-11-29 05:00:00	NQ	Futures	2570.11	2589.14	2569.24	2584.52	5800.0
2011-11-29 06:00:00	NQ	Futures	2584.81	2585.68	2579.62	2579.62	2363.0
2011-11-29 07:00:00	NQ	Futures	2579.91	2580.2	2565.21	2565.78	6960.0
2011-11-29 08:00:00	NQ	Futures	2565.78	2570.97	2560.3	2565.49	5703.0
2011-11-29 09:00:00	NQ	Futures	2565.21	2575.3	2555.98	2575.3	35786.0
2011-11-29 10:00:00	NQ	Futures	2575.58	2584.23	2565.49	2570.11	50942.0
2011-11-29 11:00:00	NQ	Futures	2569.82	2573.57	2556.56	2560.59	34652.0
2011-11-29 12:00:00	NQ	Futures	2560.59	2567.22	2551.37	2555.69	21444.0
2011-11-29 13:00:00	NQ	Futures	2555.69	2559.44	2544.45	2545.89	24276.0
2011-11-29 14:00:00	NQ	Futures	2545.6	2563.48	2543.29	2557.42	30364.0
2011-11-29 15:00:00	NQ	Futures	2557.42	2566.93	2549.06	2549.06	33004.0
2011-11-29 16:00:00	NQ	Futures	2549.35	2554.25	2538.97	2542.43	9002.0
2011-11-29 17:00:00	NQ	Futures	2542.14	2544.16	2539.26	2543.58	291.0
2011-11-29 18:00:00	NQ	Futures	2544.16	2547.62	2540.41	2542.72	623.0
2011-11-29 19:00:00	NQ	Futures	2543.0	2547.33	2540.99	2545.89	567.0
2011-11-29 20:00:00	NQ	Futures	2545.6	2548.77	2543.0	2544.16	582.0
2011-11-29 21:00:00	NQ	Futures	2543.87	2547.33	2541.85	2543.0	533.0
2011-11-29 22:00:00	NQ	Futures	2542.72	2542.72	2536.08	2538.1	901.0
2011-11-29 23:00:00	NQ	Futures	2537.81	2540.41	2537.24	2540.41	249.0
2011-11-29 00:00:00	YM	Futures	11323.4	11383.5	11323.4	11382.5	1223.0
2011-11-29 01:00:00	YM	Futures	11383.5	11384.5	11366.7	11367.7	861.0

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

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