PREVIEW / futures_1hour / 2016-07-11

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-11.parquet
  size:    54 KB
  rows:    1,616

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
2016-07-11 00:00:00	ES	Futures	2308.88	2309.69	2308.07	2308.61	3191.0
2016-07-11 01:00:00	ES	Futures	2308.34	2309.97	2308.07	2309.42	6816.0
2016-07-11 02:00:00	ES	Futures	2309.15	2310.78	2307.8	2307.8	14081.0
2016-07-11 03:00:00	ES	Futures	2308.07	2311.32	2306.44	2306.71	33100.0
2016-07-11 04:00:00	ES	Futures	2306.71	2309.15	2304.81	2305.08	25671.0
2016-07-11 05:00:00	ES	Futures	2304.81	2309.42	2302.64	2308.34	24123.0
2016-07-11 06:00:00	ES	Futures	2308.07	2309.42	2303.46	2307.53	24257.0
2016-07-11 07:00:00	ES	Futures	2307.8	2309.97	2307.53	2308.61	24853.0
2016-07-11 08:00:00	ES	Futures	2308.61	2309.97	2307.25	2309.15	31502.0
2016-07-11 09:00:00	ES	Futures	2309.42	2313.22	2307.53	2310.78	260171.0
2016-07-11 10:00:00	ES	Futures	2310.78	2312.95	2305.36	2312.68	255578.0
2016-07-11 11:00:00	ES	Futures	2312.68	2315.66	2312.41	2314.58	178442.0
2016-07-11 12:00:00	ES	Futures	2314.58	2317.83	2313.49	2317.02	90359.0
2016-07-11 13:00:00	ES	Futures	2317.02	2317.29	2314.3	2314.3	93397.0
2016-07-11 14:00:00	ES	Futures	2314.3	2315.93	2313.76	2313.76	87820.0
2016-07-11 15:00:00	ES	Futures	2313.76	2316.75	2309.69	2310.51	177331.0
2016-07-11 16:00:00	ES	Futures	2310.51	2311.86	2309.15	2311.05	69130.0
2016-07-11 18:00:00	ES	Futures	2311.32	2311.86	2309.97	2310.78	3162.0
2016-07-11 19:00:00	ES	Futures	2310.78	2311.32	2309.69	2310.24	2445.0
2016-07-11 20:00:00	ES	Futures	2310.24	2311.32	2308.88	2310.78	7283.0
2016-07-11 21:00:00	ES	Futures	2310.78	2313.22	2309.42	2310.51	8241.0
2016-07-11 22:00:00	ES	Futures	2310.78	2313.49	2309.97	2311.86	6326.0
2016-07-11 23:00:00	ES	Futures	2312.14	2312.68	2311.05	2311.86	3431.0
2016-07-11 00:00:00	NQ	Futures	5408.44	5411.72	5407.55	5408.74	610.0
2016-07-11 01:00:00	NQ	Futures	5408.74	5413.21	5407.55	5411.72	856.0
2016-07-11 02:00:00	NQ	Futures	5412.02	5416.79	5409.04	5409.93	1749.0
2016-07-11 03:00:00	NQ	Futures	5409.64	5418.58	5405.17	5407.25	3428.0
2016-07-11 04:00:00	NQ	Futures	5406.95	5412.62	5403.67	5403.97	2457.0
2016-07-11 05:00:00	NQ	Futures	5403.67	5414.11	5398.01	5411.72	2716.0
2016-07-11 06:00:00	NQ	Futures	5412.02	5415.0	5402.48	5411.72	2709.0
2016-07-11 07:00:00	NQ	Futures	5412.02	5417.09	5411.72	5414.11	2580.0
2016-07-11 08:00:00	NQ	Futures	5413.81	5415.3	5409.93	5412.62	4283.0
2016-07-11 09:00:00	NQ	Futures	5412.62	5429.9	5406.95	5425.43	38596.0
2016-07-11 10:00:00	NQ	Futures	5424.84	5428.41	5410.53	5427.82	31622.0
2016-07-11 11:00:00	NQ	Futures	5427.82	5433.78	5427.22	5431.1	22999.0
2016-07-11 12:00:00	NQ	Futures	5431.1	5440.63	5429.31	5437.95	14825.0
2016-07-11 13:00:00	NQ	Futures	5437.95	5439.14	5430.2	5430.5	10810.0
2016-07-11 14:00:00	NQ	Futures	5430.5	5433.48	5427.52	5428.71	11122.0
2016-07-11 15:00:00	NQ	Futures	5428.71	5436.76	5419.47	5421.26	18667.0
2016-07-11 16:00:00	NQ	Futures	5420.96	5426.33	5418.88	5425.73	4400.0
2016-07-11 18:00:00	NQ	Futures	5427.82	5427.82	5422.75	5425.73	489.0
2016-07-11 19:00:00	NQ	Futures	5425.73	5426.33	5422.45	5422.75	176.0
2016-07-11 20:00:00	NQ	Futures	5423.35	5426.03	5420.66	5424.84	654.0
2016-07-11 21:00:00	NQ	Futures	5425.13	5431.99	5422.15	5425.43	1025.0
2016-07-11 22:00:00	NQ	Futures	5425.73	5431.69	5423.05	5428.12	612.0
2016-07-11 23:00:00	NQ	Futures	5427.82	5429.01	5426.03	5427.82	338.0
2016-07-11 00:00:00	YM	Futures	19492.2	19501.9	19487.9	19492.2	582.0
2016-07-11 01:00:00	YM	Futures	19491.1	19505.1	19487.9	19496.5	1078.0
2016-07-11 02:00:00	YM	Futures	19496.5	19512.7	19489.0	19491.1	1350.0
2016-07-11 03:00:00	YM	Futures	19491.1	19517.0	19478.2	19478.2	3582.0

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

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