PREVIEW / futures_1hour / 2016-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-09.parquet
  size:    51 KB
  rows:    1,578

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-06-09 00:00:00	ES	Futures	2284.3	2284.84	2282.68	2283.49	3993.0
2016-06-09 01:00:00	ES	Futures	2283.49	2285.11	2283.22	2284.3	2702.0
2016-06-09 02:00:00	ES	Futures	2284.3	2285.11	2283.76	2284.03	5421.0
2016-06-09 03:00:00	ES	Futures	2284.03	2284.03	2277.82	2278.63	40414.0
2016-06-09 04:00:00	ES	Futures	2278.36	2280.25	2277.82	2280.25	20351.0
2016-06-09 05:00:00	ES	Futures	2280.25	2281.06	2278.63	2279.71	15759.0
2016-06-09 06:00:00	ES	Futures	2279.71	2280.52	2278.09	2280.52	12227.0
2016-06-09 07:00:00	ES	Futures	2280.52	2280.79	2277.82	2279.17	16652.0
2016-06-09 08:00:00	ES	Futures	2279.44	2279.44	2276.74	2278.09	38224.0
2016-06-09 09:00:00	ES	Futures	2277.82	2281.33	2276.47	2280.25	192172.0
2016-06-09 10:00:00	ES	Futures	2279.98	2280.25	2275.39	2278.36	169278.0
2016-06-09 11:00:00	ES	Futures	2278.36	2280.79	2275.12	2276.47	129043.0
2016-06-09 12:00:00	ES	Futures	2276.2	2280.79	2274.58	2279.98	91509.0
2016-06-09 13:00:00	ES	Futures	2280.25	2283.49	2278.36	2280.25	92355.0
2016-06-09 14:00:00	ES	Futures	2280.52	2284.84	2279.17	2283.76	84934.0
2016-06-09 15:00:00	ES	Futures	2283.76	2285.92	2282.14	2283.49	131775.0
2016-06-09 16:00:00	ES	Futures	2283.76	2285.11	2282.41	2282.68	56118.0
2016-06-09 18:00:00	ES	Futures	2282.68	2282.95	2280.52	2281.33	3813.0
2016-06-09 19:00:00	ES	Futures	2281.33	2282.41	2281.06	2282.14	2686.0
2016-06-09 20:00:00	ES	Futures	2281.87	2282.68	2280.79	2282.68	4949.0
2016-06-09 21:00:00	ES	Futures	2282.41	2282.68	2281.33	2281.6	2277.0
2016-06-09 22:00:00	ES	Futures	2281.6	2281.87	2281.06	2281.06	1430.0
2016-06-09 23:00:00	ES	Futures	2281.06	2281.6	2279.71	2280.52	3091.0
2016-06-09 00:00:00	NQ	Futures	5373.98	5374.28	5369.52	5371.6	680.0
2016-06-09 01:00:00	NQ	Futures	5371.9	5375.77	5371.6	5373.39	333.0
2016-06-09 02:00:00	NQ	Futures	5373.68	5373.68	5370.41	5371.01	833.0
2016-06-09 03:00:00	NQ	Futures	5371.01	5371.01	5359.4	5361.49	5821.0
2016-06-09 04:00:00	NQ	Futures	5361.78	5365.06	5357.91	5365.06	3201.0
2016-06-09 05:00:00	NQ	Futures	5365.06	5368.33	5360.59	5363.57	1455.0
2016-06-09 06:00:00	NQ	Futures	5363.27	5363.57	5360.3	5363.57	1529.0
2016-06-09 07:00:00	NQ	Futures	5363.87	5364.76	5360.89	5363.87	1396.0
2016-06-09 08:00:00	NQ	Futures	5363.57	5364.46	5357.91	5359.11	5326.0
2016-06-09 09:00:00	NQ	Futures	5359.11	5377.55	5356.43	5374.58	30200.0
2016-06-09 10:00:00	NQ	Futures	5374.28	5376.66	5360.0	5370.71	31130.0
2016-06-09 11:00:00	NQ	Futures	5370.41	5375.47	5357.62	5361.19	22342.0
2016-06-09 12:00:00	NQ	Futures	5360.89	5366.54	5347.8	5365.65	26189.0
2016-06-09 13:00:00	NQ	Futures	5365.65	5376.06	5357.02	5365.06	21863.0
2016-06-09 14:00:00	NQ	Futures	5365.06	5377.55	5360.59	5372.79	21066.0
2016-06-09 15:00:00	NQ	Futures	5372.79	5376.96	5369.22	5371.3	19983.0
2016-06-09 16:00:00	NQ	Futures	5371.3	5373.98	5368.33	5370.71	4342.0
2016-06-09 18:00:00	NQ	Futures	5371.01	5372.49	5366.25	5368.03	215.0
2016-06-09 19:00:00	NQ	Futures	5368.03	5369.82	5366.84	5368.63	278.0
2016-06-09 20:00:00	NQ	Futures	5368.33	5370.71	5364.46	5370.71	321.0
2016-06-09 21:00:00	NQ	Futures	5370.41	5371.6	5366.84	5367.14	122.0
2016-06-09 22:00:00	NQ	Futures	5367.73	5368.63	5365.06	5365.65	114.0
2016-06-09 23:00:00	NQ	Futures	5365.65	5367.14	5361.78	5364.16	182.0
2016-06-09 00:00:00	YM	Futures	19244.5	19245.6	19229.6	19234.9	600.0
2016-06-09 01:00:00	YM	Futures	19236.0	19251.0	19236.0	19244.5	591.0
2016-06-09 02:00:00	YM	Futures	19243.5	19252.0	19239.2	19242.4	1203.0
2016-06-09 03:00:00	YM	Futures	19242.4	19243.5	19194.2	19200.7	4744.0

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

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