PREVIEW / futures_1hour / 2011-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-07.parquet
  size:    49 KB
  rows:    1,473

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-04-07 00:00:00	ES	Futures	1320.41	1320.66	1317.92	1318.42	5163.0
2011-04-07 01:00:00	ES	Futures	1318.42	1319.17	1317.92	1318.92	2748.0
2011-04-07 02:00:00	ES	Futures	1318.92	1320.91	1318.92	1319.91	6995.0
2011-04-07 03:00:00	ES	Futures	1319.91	1321.4	1319.17	1320.16	22179.0
2011-04-07 04:00:00	ES	Futures	1320.41	1321.4	1319.91	1320.91	12000.0
2011-04-07 05:00:00	ES	Futures	1321.15	1321.15	1319.91	1320.41	5030.0
2011-04-07 06:00:00	ES	Futures	1320.41	1320.66	1319.17	1320.16	9254.0
2011-04-07 07:00:00	ES	Futures	1320.16	1323.14	1319.91	1323.14	26186.0
2011-04-07 08:00:00	ES	Futures	1323.14	1324.13	1320.91	1321.15	67138.0
2011-04-07 09:00:00	ES	Futures	1321.4	1326.37	1319.91	1326.12	238344.0
2011-04-07 10:00:00	ES	Futures	1326.12	1326.87	1313.95	1320.66	556478.0
2011-04-07 11:00:00	ES	Futures	1320.66	1321.9	1314.69	1319.91	447513.0
2011-04-07 12:00:00	ES	Futures	1319.91	1323.64	1319.17	1322.64	164229.0
2011-04-07 13:00:00	ES	Futures	1322.64	1322.64	1316.68	1318.17	157739.0
2011-04-07 14:00:00	ES	Futures	1318.17	1320.16	1316.93	1319.66	130424.0
2011-04-07 15:00:00	ES	Futures	1319.66	1321.65	1318.17	1320.66	217516.0
2011-04-07 16:00:00	ES	Futures	1320.91	1321.15	1319.66	1320.41	82706.0
2011-04-07 17:00:00	ES	Futures	1320.41	1321.15	1319.91	1320.66	1230.0
2011-04-07 18:00:00	ES	Futures	1320.91	1321.65	1319.41	1319.91	3070.0
2011-04-07 19:00:00	ES	Futures	1320.16	1321.15	1319.91	1320.66	1309.0
2011-04-07 20:00:00	ES	Futures	1320.41	1321.9	1320.16	1321.65	5980.0
2011-04-07 21:00:00	ES	Futures	1321.65	1322.4	1320.66	1321.9	7693.0
2011-04-07 22:00:00	ES	Futures	1321.9	1322.64	1321.4	1322.4	2536.0
2011-04-07 23:00:00	ES	Futures	1322.4	1323.14	1321.9	1322.64	5109.0
2011-04-07 00:00:00	NQ	Futures	2673.75	2674.04	2669.15	2669.44	414.0
2011-04-07 01:00:00	NQ	Futures	2669.44	2670.3	2668.58	2670.02	362.0
2011-04-07 02:00:00	NQ	Futures	2670.02	2673.18	2669.44	2671.45	884.0
2011-04-07 03:00:00	NQ	Futures	2671.45	2674.61	2669.73	2670.88	1326.0
2011-04-07 04:00:00	NQ	Futures	2671.45	2674.9	2670.88	2672.6	976.0
2011-04-07 05:00:00	NQ	Futures	2672.6	2672.89	2668.58	2669.73	1185.0
2011-04-07 06:00:00	NQ	Futures	2670.02	2671.74	2668.58	2671.17	860.0
2011-04-07 07:00:00	NQ	Futures	2671.17	2677.2	2670.3	2676.62	3261.0
2011-04-07 08:00:00	NQ	Futures	2676.62	2679.21	2673.18	2673.75	7823.0
2011-04-07 09:00:00	NQ	Futures	2673.46	2694.15	2671.45	2691.28	41101.0
2011-04-07 10:00:00	NQ	Futures	2691.28	2692.71	2656.8	2673.75	67451.0
2011-04-07 11:00:00	NQ	Futures	2673.46	2677.2	2662.26	2672.6	51739.0
2011-04-07 12:00:00	NQ	Futures	2672.89	2688.4	2670.88	2686.11	31866.0
2011-04-07 13:00:00	NQ	Futures	2686.11	2686.39	2668.58	2673.18	32747.0
2011-04-07 14:00:00	NQ	Futures	2673.46	2676.34	2669.44	2675.19	18324.0
2011-04-07 15:00:00	NQ	Futures	2675.19	2677.49	2670.59	2676.05	31404.0
2011-04-07 16:00:00	NQ	Futures	2676.34	2680.07	2675.76	2678.06	6408.0
2011-04-07 17:00:00	NQ	Futures	2678.06	2680.07	2677.49	2679.5	114.0
2011-04-07 18:00:00	NQ	Futures	2679.21	2680.65	2676.62	2677.2	185.0
2011-04-07 19:00:00	NQ	Futures	2677.49	2678.92	2677.2	2678.06	83.0
2011-04-07 20:00:00	NQ	Futures	2678.64	2680.65	2677.77	2680.36	330.0
2011-04-07 21:00:00	NQ	Futures	2679.79	2681.22	2677.77	2680.65	568.0
2011-04-07 22:00:00	NQ	Futures	2680.36	2682.66	2679.79	2681.51	203.0
2011-04-07 23:00:00	NQ	Futures	2681.51	2682.37	2680.07	2681.8	377.0
2011-04-07 00:00:00	YM	Futures	11899.2	11900.2	11880.9	11885.7	231.0
2011-04-07 01:00:00	YM	Futures	11885.7	11893.4	11882.8	11892.5	300.0

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

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