PREVIEW / futures_1hour / 2011-12-15

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-15.parquet
  size:    48 KB
  rows:    1,467

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-12-15 00:00:00	ES	Futures	1215.09	1215.34	1207.53	1210.55	10174.0
2011-12-15 01:00:00	ES	Futures	1210.55	1211.31	1209.79	1211.05	6002.0
2011-12-15 02:00:00	ES	Futures	1211.05	1218.11	1210.8	1217.86	17980.0
2011-12-15 03:00:00	ES	Futures	1217.86	1224.16	1215.34	1222.14	56902.0
2011-12-15 04:00:00	ES	Futures	1222.14	1223.15	1215.59	1217.1	36676.0
2011-12-15 05:00:00	ES	Futures	1217.1	1222.65	1216.6	1221.39	28080.0
2011-12-15 06:00:00	ES	Futures	1221.13	1223.4	1219.62	1220.13	34326.0
2011-12-15 07:00:00	ES	Futures	1219.87	1224.91	1219.62	1223.91	43926.0
2011-12-15 08:00:00	ES	Futures	1223.91	1230.21	1223.4	1229.2	101380.0
2011-12-15 09:00:00	ES	Futures	1229.2	1230.21	1225.42	1226.93	219673.0
2011-12-15 10:00:00	ES	Futures	1226.93	1229.7	1217.35	1219.37	455792.0
2011-12-15 11:00:00	ES	Futures	1219.37	1223.91	1218.87	1220.63	235507.0
2011-12-15 12:00:00	ES	Futures	1220.38	1225.17	1220.38	1222.14	170200.0
2011-12-15 13:00:00	ES	Futures	1222.14	1224.16	1219.37	1221.64	143643.0
2011-12-15 14:00:00	ES	Futures	1221.64	1223.15	1218.11	1219.37	109410.0
2011-12-15 15:00:00	ES	Futures	1219.12	1223.15	1217.61	1219.12	279904.0
2011-12-15 16:00:00	ES	Futures	1219.12	1222.39	1218.87	1220.88	101038.0
2011-12-15 17:00:00	ES	Futures	1220.88	1221.89	1220.63	1221.64	2293.0
2011-12-15 18:00:00	ES	Futures	1222.14	1224.16	1221.64	1223.65	4868.0
2011-12-15 19:00:00	ES	Futures	1223.65	1224.91	1223.15	1223.91	6131.0
2011-12-15 20:00:00	ES	Futures	1223.91	1225.67	1223.65	1224.41	5604.0
2011-12-15 21:00:00	ES	Futures	1224.16	1225.67	1223.91	1225.42	3170.0
2011-12-15 22:00:00	ES	Futures	1225.42	1229.45	1225.17	1227.69	13757.0
2011-12-15 23:00:00	ES	Futures	1227.69	1228.69	1227.18	1228.44	4162.0
2011-12-15 00:00:00	NQ	Futures	2571.46	2572.33	2558.75	2564.82	955.0
2011-12-15 01:00:00	NQ	Futures	2565.11	2565.97	2563.09	2564.82	308.0
2011-12-15 02:00:00	NQ	Futures	2565.68	2578.39	2564.82	2576.95	1231.0
2011-12-15 03:00:00	NQ	Futures	2576.95	2588.21	2571.17	2584.46	3180.0
2011-12-15 04:00:00	NQ	Futures	2584.46	2587.63	2570.88	2574.35	2132.0
2011-12-15 05:00:00	NQ	Futures	2574.35	2586.77	2573.48	2583.59	1673.0
2011-12-15 06:00:00	NQ	Futures	2583.88	2587.34	2578.68	2580.7	1734.0
2011-12-15 07:00:00	NQ	Futures	2580.12	2593.41	2579.26	2592.25	4816.0
2011-12-15 08:00:00	NQ	Futures	2592.54	2601.5	2590.81	2598.9	8024.0
2011-12-15 09:00:00	NQ	Futures	2599.19	2600.92	2585.03	2586.19	26187.0
2011-12-15 10:00:00	NQ	Futures	2586.19	2591.39	2566.26	2568.86	48395.0
2011-12-15 11:00:00	NQ	Futures	2568.86	2575.21	2563.09	2565.68	25019.0
2011-12-15 12:00:00	NQ	Futures	2565.68	2578.39	2565.68	2573.48	18892.0
2011-12-15 13:00:00	NQ	Futures	2573.48	2578.68	2568.86	2573.19	16016.0
2011-12-15 14:00:00	NQ	Futures	2573.48	2577.53	2567.13	2568.28	12534.0
2011-12-15 15:00:00	NQ	Futures	2568.28	2576.66	2565.4	2567.13	30546.0
2011-12-15 16:00:00	NQ	Futures	2567.13	2570.88	2565.97	2567.71	8312.0
2011-12-15 17:00:00	NQ	Futures	2567.71	2568.28	2567.42	2567.99	159.0
2011-12-15 18:00:00	NQ	Futures	2568.28	2572.62	2568.28	2571.46	337.0
2011-12-15 19:00:00	NQ	Futures	2571.46	2574.64	2571.17	2573.77	419.0
2011-12-15 20:00:00	NQ	Futures	2573.77	2576.66	2573.19	2574.64	365.0
2011-12-15 21:00:00	NQ	Futures	2574.06	2575.5	2573.77	2575.5	222.0
2011-12-15 22:00:00	NQ	Futures	2575.79	2583.59	2574.64	2580.99	993.0
2011-12-15 23:00:00	NQ	Futures	2580.7	2582.43	2580.12	2582.15	221.0
2011-12-15 00:00:00	YM	Futures	11653.8	11657.7	11590.3	11618.1	751.0
2011-12-15 01:00:00	YM	Futures	11618.1	11626.0	11612.1	11620.1	441.0

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

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