PREVIEW / futures_1hour / 2015-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-29.parquet
  size:    52 KB
  rows:    1,606

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
2015-10-29 00:00:00	ES	Futures	2224.1	2225.17	2223.29	2224.9	2376.0
2015-10-29 01:00:00	ES	Futures	2224.63	2225.7	2223.83	2224.9	4522.0
2015-10-29 02:00:00	ES	Futures	2224.63	2225.43	2223.83	2225.17	2601.0
2015-10-29 03:00:00	ES	Futures	2224.9	2227.04	2224.36	2226.24	8474.0
2015-10-29 04:00:00	ES	Futures	2226.24	2226.51	2221.69	2222.49	24608.0
2015-10-29 05:00:00	ES	Futures	2222.22	2222.49	2219.01	2221.69	23543.0
2015-10-29 06:00:00	ES	Futures	2221.96	2224.36	2220.62	2222.76	15970.0
2015-10-29 07:00:00	ES	Futures	2222.76	2223.03	2220.08	2220.35	18906.0
2015-10-29 08:00:00	ES	Futures	2220.62	2223.83	2219.01	2223.56	34748.0
2015-10-29 09:00:00	ES	Futures	2223.56	2229.18	2222.22	2225.43	182879.0
2015-10-29 10:00:00	ES	Futures	2225.7	2231.05	2221.42	2223.29	270134.0
2015-10-29 11:00:00	ES	Futures	2223.29	2228.38	2221.42	2227.84	155899.0
2015-10-29 12:00:00	ES	Futures	2227.84	2229.98	2224.36	2227.31	126561.0
2015-10-29 13:00:00	ES	Futures	2227.58	2229.98	2223.56	2223.83	114337.0
2015-10-29 14:00:00	ES	Futures	2223.83	2228.38	2223.29	2226.77	118543.0
2015-10-29 15:00:00	ES	Futures	2227.04	2233.19	2225.17	2228.65	205931.0
2015-10-29 16:00:00	ES	Futures	2228.91	2231.59	2227.04	2231.32	53732.0
2015-10-29 17:00:00	ES	Futures	2231.32	2231.32	2231.32	2231.32	1.0
2015-10-29 18:00:00	ES	Futures	2231.32	2232.66	2228.91	2229.72	6730.0
2015-10-29 19:00:00	ES	Futures	2229.72	2231.86	2229.18	2231.32	3231.0
2015-10-29 20:00:00	ES	Futures	2231.32	2235.34	2231.05	2234.53	9303.0
2015-10-29 21:00:00	ES	Futures	2234.8	2238.55	2233.46	2237.21	11895.0
2015-10-29 22:00:00	ES	Futures	2237.48	2238.55	2236.14	2237.74	7694.0
2015-10-29 23:00:00	ES	Futures	2238.01	2238.81	2234.0	2237.21	15948.0
2015-10-29 00:00:00	NQ	Futures	5519.77	5522.15	5516.81	5521.55	790.0
2015-10-29 01:00:00	NQ	Futures	5521.26	5523.33	5519.18	5521.85	873.0
2015-10-29 02:00:00	NQ	Futures	5521.26	5521.85	5517.7	5520.96	660.0
2015-10-29 03:00:00	NQ	Futures	5520.66	5526.59	5518.59	5523.03	1508.0
2015-10-29 04:00:00	NQ	Futures	5523.33	5523.33	5512.06	5513.55	3610.0
2015-10-29 05:00:00	NQ	Futures	5512.95	5515.92	5506.13	5515.33	3930.0
2015-10-29 06:00:00	NQ	Futures	5515.03	5519.77	5512.06	5515.33	2163.0
2015-10-29 07:00:00	NQ	Futures	5515.03	5515.62	5507.62	5508.51	2717.0
2015-10-29 08:00:00	NQ	Futures	5508.8	5513.84	5506.13	5512.95	4729.0
2015-10-29 09:00:00	NQ	Futures	5513.25	5526.0	5508.51	5510.88	27972.0
2015-10-29 10:00:00	NQ	Futures	5510.58	5525.7	5507.32	5514.44	36812.0
2015-10-29 11:00:00	NQ	Futures	5514.44	5529.26	5510.88	5525.11	20716.0
2015-10-29 12:00:00	NQ	Futures	5524.81	5533.41	5517.4	5529.85	18518.0
2015-10-29 13:00:00	NQ	Futures	5529.85	5532.52	5518.29	5521.26	12958.0
2015-10-29 14:00:00	NQ	Futures	5521.26	5533.41	5520.07	5528.96	15736.0
2015-10-29 15:00:00	NQ	Futures	5528.67	5538.75	5524.22	5528.37	19246.0
2015-10-29 16:00:00	NQ	Futures	5528.67	5533.12	5525.11	5531.93	4834.0
2015-10-29 18:00:00	NQ	Futures	5533.71	5535.19	5526.89	5528.96	849.0
2015-10-29 19:00:00	NQ	Futures	5529.26	5536.38	5528.96	5534.89	598.0
2015-10-29 20:00:00	NQ	Futures	5535.19	5545.86	5534.3	5544.98	1419.0
2015-10-29 21:00:00	NQ	Futures	5545.27	5550.9	5541.71	5549.72	1597.0
2015-10-29 22:00:00	NQ	Futures	5549.13	5553.87	5545.86	5553.28	1218.0
2015-10-29 23:00:00	NQ	Futures	5553.28	5556.83	5544.68	5553.57	3317.0
2015-10-29 00:00:00	YM	Futures	18690.5	18695.8	18681.0	18692.6	331.0
2015-10-29 01:00:00	YM	Futures	18691.6	18700.1	18686.3	18693.7	585.0
2015-10-29 02:00:00	YM	Futures	18692.6	18699.0	18687.3	18695.8	595.0

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

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