PREVIEW / futures_1hour / 2011-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-06.parquet
  size:    48 KB
  rows:    1,465

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-06 00:00:00	ES	Futures	1320.66	1322.15	1320.66	1321.15	6416.0
2011-04-06 01:00:00	ES	Futures	1321.4	1321.65	1318.92	1320.41	10077.0
2011-04-06 02:00:00	ES	Futures	1320.41	1322.64	1319.91	1322.64	9295.0
2011-04-06 03:00:00	ES	Futures	1322.64	1323.64	1319.91	1321.15	27611.0
2011-04-06 04:00:00	ES	Futures	1321.15	1322.15	1320.41	1321.4	13282.0
2011-04-06 05:00:00	ES	Futures	1321.4	1324.13	1321.15	1323.89	13663.0
2011-04-06 06:00:00	ES	Futures	1324.13	1327.61	1324.13	1327.12	40637.0
2011-04-06 07:00:00	ES	Futures	1327.36	1327.86	1325.87	1326.87	22729.0
2011-04-06 08:00:00	ES	Futures	1326.87	1328.11	1325.38	1325.63	39735.0
2011-04-06 09:00:00	ES	Futures	1325.87	1327.36	1324.38	1325.13	192643.0
2011-04-06 10:00:00	ES	Futures	1325.13	1326.12	1322.4	1325.13	256245.0
2011-04-06 11:00:00	ES	Futures	1324.88	1325.13	1319.17	1319.41	334319.0
2011-04-06 12:00:00	ES	Futures	1319.17	1321.15	1318.42	1320.41	172947.0
2011-04-06 13:00:00	ES	Futures	1320.16	1322.15	1319.91	1322.15	74119.0
2011-04-06 14:00:00	ES	Futures	1322.15	1324.13	1321.15	1323.39	111527.0
2011-04-06 15:00:00	ES	Futures	1323.14	1324.63	1322.64	1323.64	195033.0
2011-04-06 16:00:00	ES	Futures	1323.64	1323.89	1319.41	1319.91	112985.0
2011-04-06 17:00:00	ES	Futures	1319.91	1321.15	1319.91	1320.91	2900.0
2011-04-06 18:00:00	ES	Futures	1321.15	1321.4	1320.91	1320.91	3510.0
2011-04-06 19:00:00	ES	Futures	1320.91	1321.15	1320.41	1320.66	1339.0
2011-04-06 20:00:00	ES	Futures	1320.66	1320.91	1318.92	1319.91	5409.0
2011-04-06 21:00:00	ES	Futures	1319.66	1320.66	1319.41	1319.91	2584.0
2011-04-06 22:00:00	ES	Futures	1320.16	1320.41	1318.92	1320.41	2518.0
2011-04-06 23:00:00	ES	Futures	1320.41	1320.91	1319.66	1320.16	2070.0
2011-04-06 00:00:00	NQ	Futures	2676.91	2682.95	2676.62	2677.77	726.0
2011-04-06 01:00:00	NQ	Futures	2677.77	2677.77	2673.18	2676.05	365.0
2011-04-06 02:00:00	NQ	Futures	2675.76	2681.22	2673.75	2680.93	1288.0
2011-04-06 03:00:00	NQ	Futures	2680.93	2683.52	2676.05	2677.77	2327.0
2011-04-06 04:00:00	NQ	Futures	2678.06	2680.07	2676.34	2677.2	952.0
2011-04-06 05:00:00	NQ	Futures	2677.77	2684.96	2677.77	2684.67	1809.0
2011-04-06 06:00:00	NQ	Futures	2684.67	2697.02	2683.81	2692.71	5653.0
2011-04-06 07:00:00	NQ	Futures	2693.0	2695.87	2690.99	2692.43	4060.0
2011-04-06 08:00:00	NQ	Futures	2692.43	2694.73	2688.12	2689.55	4065.0
2011-04-06 09:00:00	NQ	Futures	2689.27	2700.76	2688.12	2694.15	43687.0
2011-04-06 10:00:00	NQ	Futures	2694.15	2697.6	2682.08	2687.26	43963.0
2011-04-06 11:00:00	NQ	Futures	2687.26	2687.54	2665.42	2665.71	50683.0
2011-04-06 12:00:00	NQ	Futures	2665.42	2671.74	2662.55	2668.01	29960.0
2011-04-06 13:00:00	NQ	Futures	2667.72	2675.19	2667.14	2675.19	12081.0
2011-04-06 14:00:00	NQ	Futures	2675.19	2680.65	2673.75	2677.49	21197.0
2011-04-06 15:00:00	NQ	Futures	2677.49	2679.79	2674.61	2676.91	26664.0
2011-04-06 16:00:00	NQ	Futures	2677.2	2677.2	2670.88	2671.74	8620.0
2011-04-06 17:00:00	NQ	Futures	2671.45	2674.33	2671.45	2674.33	118.0
2011-04-06 18:00:00	NQ	Futures	2674.61	2675.76	2674.61	2674.9	199.0
2011-04-06 19:00:00	NQ	Futures	2674.61	2675.19	2674.04	2674.33	138.0
2011-04-06 20:00:00	NQ	Futures	2674.33	2674.33	2670.02	2670.88	526.0
2011-04-06 21:00:00	NQ	Futures	2670.88	2672.6	2670.3	2672.03	150.0
2011-04-06 22:00:00	NQ	Futures	2672.03	2672.6	2670.02	2672.6	176.0
2011-04-06 23:00:00	NQ	Futures	2672.6	2674.04	2672.03	2673.75	249.0
2011-04-06 00:00:00	YM	Futures	11891.5	11900.2	11890.6	11895.4	178.0
2011-04-06 01:00:00	YM	Futures	11895.4	11895.4	11877.1	11886.7	331.0

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

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