PREVIEW / futures_1hour / 2015-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-21.parquet
  size:    51 KB
  rows:    1,555

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-21 00:00:00	ES	Futures	2167.1	2174.06	2167.1	2172.19	16362.0
2015-10-21 01:00:00	ES	Futures	2172.19	2177.27	2171.92	2172.72	14225.0
2015-10-21 02:00:00	ES	Futures	2172.72	2174.6	2167.91	2168.71	12158.0
2015-10-21 03:00:00	ES	Futures	2168.71	2169.51	2163.09	2163.62	23361.0
2015-10-21 04:00:00	ES	Futures	2163.36	2167.64	2162.55	2166.84	14647.0
2015-10-21 05:00:00	ES	Futures	2166.84	2172.72	2166.84	2170.85	18659.0
2015-10-21 06:00:00	ES	Futures	2170.85	2174.6	2170.85	2171.92	17041.0
2015-10-21 07:00:00	ES	Futures	2171.92	2173.79	2170.85	2172.45	16597.0
2015-10-21 08:00:00	ES	Futures	2172.19	2173.26	2171.12	2172.19	20752.0
2015-10-21 09:00:00	ES	Futures	2172.19	2174.06	2168.44	2170.31	210584.0
2015-10-21 10:00:00	ES	Futures	2170.31	2170.31	2160.41	2166.57	299496.0
2015-10-21 11:00:00	ES	Futures	2166.84	2171.12	2160.95	2168.98	213479.0
2015-10-21 12:00:00	ES	Futures	2168.98	2170.85	2166.57	2166.57	90033.0
2015-10-21 13:00:00	ES	Futures	2166.57	2166.84	2154.26	2157.47	248757.0
2015-10-21 14:00:00	ES	Futures	2157.47	2166.57	2155.33	2162.82	175861.0
2015-10-21 15:00:00	ES	Futures	2163.09	2166.3	2150.78	2152.92	273675.0
2015-10-21 16:00:00	ES	Futures	2152.65	2154.53	2148.64	2152.12	85369.0
2015-10-21 18:00:00	ES	Futures	2151.85	2153.46	2151.32	2151.85	3330.0
2015-10-21 19:00:00	ES	Futures	2151.85	2152.39	2149.71	2151.58	3945.0
2015-10-21 20:00:00	ES	Futures	2151.58	2156.13	2151.32	2155.33	6949.0
2015-10-21 21:00:00	ES	Futures	2155.33	2156.13	2154.79	2155.86	4014.0
2015-10-21 22:00:00	ES	Futures	2155.6	2159.08	2155.6	2158.01	8799.0
2015-10-21 23:00:00	ES	Futures	2158.01	2158.54	2155.06	2155.33	4828.0
2015-10-21 00:00:00	NQ	Futures	5261.53	5276.65	5261.23	5272.2	2803.0
2015-10-21 01:00:00	NQ	Futures	5271.91	5281.69	5271.02	5272.2	1928.0
2015-10-21 02:00:00	NQ	Futures	5272.2	5277.54	5262.72	5264.2	2349.0
2015-10-21 03:00:00	NQ	Futures	5264.2	5267.46	5247.59	5248.48	3749.0
2015-10-21 04:00:00	NQ	Futures	5247.89	5256.19	5244.63	5254.71	2303.0
2015-10-21 05:00:00	NQ	Futures	5255.3	5271.02	5254.41	5265.68	2530.0
2015-10-21 06:00:00	NQ	Futures	5266.57	5275.46	5264.79	5268.65	2291.0
2015-10-21 07:00:00	NQ	Futures	5268.65	5273.98	5267.16	5271.02	3251.0
2015-10-21 08:00:00	NQ	Futures	5271.02	5279.91	5270.72	5276.65	5322.0
2015-10-21 09:00:00	NQ	Futures	5276.95	5284.95	5261.53	5275.17	36324.0
2015-10-21 10:00:00	NQ	Futures	5275.17	5275.17	5240.78	5263.61	47369.0
2015-10-21 11:00:00	NQ	Futures	5263.61	5278.13	5243.15	5270.72	33678.0
2015-10-21 12:00:00	NQ	Futures	5270.72	5277.24	5259.16	5259.16	15752.0
2015-10-21 13:00:00	NQ	Futures	5259.16	5259.16	5222.1	5233.07	40095.0
2015-10-21 14:00:00	NQ	Futures	5232.77	5260.05	5228.03	5248.48	31232.0
2015-10-21 15:00:00	NQ	Futures	5248.48	5258.86	5218.54	5222.39	40965.0
2015-10-21 16:00:00	NQ	Futures	5222.39	5226.54	5212.02	5225.06	10534.0
2015-10-21 18:00:00	NQ	Futures	5226.25	5229.81	5224.17	5225.65	845.0
2015-10-21 19:00:00	NQ	Futures	5225.06	5226.54	5220.61	5223.58	796.0
2015-10-21 20:00:00	NQ	Futures	5223.88	5236.62	5223.28	5233.07	1130.0
2015-10-21 21:00:00	NQ	Futures	5233.36	5236.03	5231.29	5233.96	461.0
2015-10-21 22:00:00	NQ	Futures	5234.25	5242.85	5234.25	5239.29	1195.0
2015-10-21 23:00:00	NQ	Futures	5239.59	5240.48	5231.88	5233.36	1107.0
2015-10-21 00:00:00	YM	Futures	18151.4	18201.2	18151.4	18189.5	2402.0
2015-10-21 01:00:00	YM	Futures	18188.4	18217.0	18185.3	18190.6	2020.0
2015-10-21 02:00:00	YM	Futures	18191.6	18204.3	18156.7	18163.0	2046.0
2015-10-21 03:00:00	YM	Futures	18163.0	18169.4	18118.5	18124.9	3265.0

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

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