PREVIEW / futures_1hour / 2011-04-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-04.parquet
  size:    47 KB
  rows:    1,441

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-04 00:00:00	ES	Futures	1318.17	1318.42	1316.18	1316.43	5280.0
2011-04-04 01:00:00	ES	Futures	1316.43	1318.92	1316.18	1318.67	5648.0
2011-04-04 02:00:00	ES	Futures	1318.67	1319.91	1317.92	1318.92	8438.0
2011-04-04 03:00:00	ES	Futures	1318.92	1321.9	1318.17	1321.4	28987.0
2011-04-04 04:00:00	ES	Futures	1321.15	1322.4	1320.16	1320.91	13980.0
2011-04-04 05:00:00	ES	Futures	1321.15	1321.4	1320.16	1321.15	7887.0
2011-04-04 06:00:00	ES	Futures	1320.91	1322.64	1320.91	1321.9	10584.0
2011-04-04 07:00:00	ES	Futures	1322.15	1323.14	1321.4	1321.9	16807.0
2011-04-04 08:00:00	ES	Futures	1321.9	1323.14	1321.65	1321.9	21159.0
2011-04-04 09:00:00	ES	Futures	1322.15	1324.38	1319.91	1321.15	171466.0
2011-04-04 10:00:00	ES	Futures	1320.91	1322.15	1319.17	1319.66	196786.0
2011-04-04 11:00:00	ES	Futures	1319.91	1321.4	1318.67	1320.66	140498.0
2011-04-04 12:00:00	ES	Futures	1320.91	1321.4	1318.67	1319.41	94252.0
2011-04-04 13:00:00	ES	Futures	1319.66	1320.41	1316.43	1317.43	131386.0
2011-04-04 14:00:00	ES	Futures	1317.43	1319.17	1316.43	1318.17	97100.0
2011-04-04 15:00:00	ES	Futures	1318.42	1320.16	1316.93	1320.16	208177.0
2011-04-04 16:00:00	ES	Futures	1320.16	1322.15	1319.66	1321.65	89667.0
2011-04-04 17:00:00	ES	Futures	1321.65	1322.15	1321.15	1321.9	2602.0
2011-04-04 18:00:00	ES	Futures	1321.65	1321.9	1321.15	1321.65	2146.0
2011-04-04 19:00:00	ES	Futures	1321.65	1322.64	1320.91	1321.15	5841.0
2011-04-04 20:00:00	ES	Futures	1320.91	1321.4	1319.66	1320.16	8904.0
2011-04-04 21:00:00	ES	Futures	1319.91	1320.66	1318.67	1318.92	7192.0
2011-04-04 22:00:00	ES	Futures	1318.92	1319.66	1318.42	1318.92	3280.0
2011-04-04 23:00:00	ES	Futures	1318.67	1319.66	1318.42	1318.42	2395.0
2011-04-04 00:00:00	NQ	Futures	2688.98	2689.55	2684.96	2685.82	325.0
2011-04-04 01:00:00	NQ	Futures	2685.82	2691.56	2685.53	2690.7	318.0
2011-04-04 02:00:00	NQ	Futures	2690.7	2693.0	2688.69	2691.28	406.0
2011-04-04 03:00:00	NQ	Futures	2691.28	2697.89	2688.98	2697.31	2549.0
2011-04-04 04:00:00	NQ	Futures	2697.02	2698.75	2694.73	2696.45	1541.0
2011-04-04 05:00:00	NQ	Futures	2696.74	2697.6	2695.3	2697.02	778.0
2011-04-04 06:00:00	NQ	Futures	2697.31	2700.47	2696.45	2698.46	1112.0
2011-04-04 07:00:00	NQ	Futures	2698.75	2700.47	2696.74	2697.89	1925.0
2011-04-04 08:00:00	NQ	Futures	2697.6	2699.9	2697.02	2697.6	2486.0
2011-04-04 09:00:00	NQ	Futures	2697.6	2699.32	2683.52	2686.11	33509.0
2011-04-04 10:00:00	NQ	Futures	2685.82	2686.97	2677.77	2679.21	41078.0
2011-04-04 11:00:00	NQ	Futures	2678.92	2685.53	2677.2	2684.67	18149.0
2011-04-04 12:00:00	NQ	Futures	2684.38	2686.39	2676.62	2678.64	15079.0
2011-04-04 13:00:00	NQ	Futures	2678.64	2680.07	2668.58	2670.59	23614.0
2011-04-04 14:00:00	NQ	Futures	2670.88	2674.33	2668.87	2672.89	17241.0
2011-04-04 15:00:00	NQ	Futures	2673.18	2680.65	2668.58	2680.36	35147.0
2011-04-04 16:00:00	NQ	Futures	2680.36	2692.14	2680.36	2690.99	17564.0
2011-04-04 17:00:00	NQ	Futures	2690.99	2692.14	2689.84	2691.56	523.0
2011-04-04 18:00:00	NQ	Futures	2691.28	2691.56	2689.27	2690.99	182.0
2011-04-04 19:00:00	NQ	Futures	2690.7	2692.71	2690.13	2690.42	309.0
2011-04-04 20:00:00	NQ	Futures	2690.42	2691.85	2686.97	2687.54	937.0
2011-04-04 21:00:00	NQ	Futures	2687.54	2688.4	2684.96	2685.24	481.0
2011-04-04 22:00:00	NQ	Futures	2685.24	2686.68	2684.67	2684.96	309.0
2011-04-04 23:00:00	NQ	Futures	2685.24	2687.54	2684.67	2684.67	266.0
2011-04-04 00:00:00	YM	Futures	11843.4	11846.2	11833.7	11835.7	539.0
2011-04-04 01:00:00	YM	Futures	11835.7	11858.8	11835.7	11856.8	540.0

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

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