PREVIEW / futures_1hour / 2016-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-19.parquet
  size:    53 KB
  rows:    1,604

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-04-19 00:00:00	ES	Futures	2255.41	2256.22	2252.71	2253.52	5136.0
2016-04-19 01:00:00	ES	Futures	2253.52	2255.95	2252.71	2255.68	4761.0
2016-04-19 02:00:00	ES	Futures	2255.68	2258.92	2255.68	2258.11	16687.0
2016-04-19 03:00:00	ES	Futures	2257.84	2264.05	2256.76	2263.51	45805.0
2016-04-19 04:00:00	ES	Futures	2263.51	2264.05	2261.89	2263.51	27851.0
2016-04-19 05:00:00	ES	Futures	2263.51	2266.21	2262.7	2265.4	26407.0
2016-04-19 06:00:00	ES	Futures	2265.13	2265.94	2262.7	2263.51	19047.0
2016-04-19 07:00:00	ES	Futures	2263.51	2265.13	2261.89	2264.05	31149.0
2016-04-19 08:00:00	ES	Futures	2264.05	2264.32	2261.08	2261.62	34703.0
2016-04-19 09:00:00	ES	Futures	2261.62	2263.51	2257.57	2262.97	233017.0
2016-04-19 10:00:00	ES	Futures	2262.97	2265.4	2260.27	2263.78	245332.0
2016-04-19 11:00:00	ES	Futures	2263.78	2265.4	2255.68	2255.68	175624.0
2016-04-19 12:00:00	ES	Futures	2255.95	2256.76	2251.63	2255.95	162993.0
2016-04-19 13:00:00	ES	Futures	2255.95	2260.27	2255.14	2259.73	113250.0
2016-04-19 14:00:00	ES	Futures	2259.73	2261.35	2257.84	2258.38	116752.0
2016-04-19 15:00:00	ES	Futures	2258.38	2262.16	2257.3	2262.16	193677.0
2016-04-19 16:00:00	ES	Futures	2262.16	2262.97	2260.27	2261.62	71110.0
2016-04-19 18:00:00	ES	Futures	2261.62	2261.89	2258.11	2258.92	4978.0
2016-04-19 19:00:00	ES	Futures	2258.65	2259.46	2257.3	2258.38	2872.0
2016-04-19 20:00:00	ES	Futures	2258.11	2259.19	2256.49	2257.57	7177.0
2016-04-19 21:00:00	ES	Futures	2257.57	2258.11	2255.68	2255.68	8527.0
2016-04-19 22:00:00	ES	Futures	2255.95	2257.03	2255.41	2255.68	4526.0
2016-04-19 23:00:00	ES	Futures	2255.68	2257.03	2253.25	2254.33	9910.0
2016-04-19 00:00:00	NQ	Futures	5418.91	5420.99	5412.36	5415.64	576.0
2016-04-19 01:00:00	NQ	Futures	5415.93	5422.18	5413.55	5421.59	898.0
2016-04-19 02:00:00	NQ	Futures	5422.48	5431.7	5422.48	5429.32	2267.0
2016-04-19 03:00:00	NQ	Futures	5429.62	5447.47	5424.26	5446.58	5740.0
2016-04-19 04:00:00	NQ	Futures	5447.17	5448.36	5442.71	5446.88	3554.0
2016-04-19 05:00:00	NQ	Futures	5446.88	5456.1	5445.39	5452.83	3276.0
2016-04-19 06:00:00	NQ	Futures	5452.83	5454.61	5447.17	5448.96	2712.0
2016-04-19 07:00:00	NQ	Futures	5449.26	5452.83	5443.9	5449.85	4161.0
2016-04-19 08:00:00	NQ	Futures	5449.85	5450.15	5438.84	5440.33	4094.0
2016-04-19 09:00:00	NQ	Futures	5440.33	5443.01	5395.4	5402.25	40977.0
2016-04-19 10:00:00	NQ	Futures	5402.54	5418.61	5397.49	5411.47	41636.0
2016-04-19 11:00:00	NQ	Futures	5410.88	5413.26	5376.06	5377.85	28967.0
2016-04-19 12:00:00	NQ	Futures	5378.15	5382.61	5363.57	5382.31	27830.0
2016-04-19 13:00:00	NQ	Futures	5382.31	5398.38	5379.63	5396.3	16892.0
2016-04-19 14:00:00	NQ	Futures	5396.3	5402.25	5385.88	5387.67	17794.0
2016-04-19 15:00:00	NQ	Futures	5387.67	5399.57	5381.72	5393.92	32611.0
2016-04-19 16:00:00	NQ	Futures	5393.92	5402.25	5385.59	5390.35	8695.0
2016-04-19 18:00:00	NQ	Futures	5389.16	5390.35	5382.91	5385.59	928.0
2016-04-19 19:00:00	NQ	Futures	5385.59	5387.07	5381.72	5382.91	655.0
2016-04-19 20:00:00	NQ	Futures	5383.2	5386.18	5376.96	5381.12	810.0
2016-04-19 21:00:00	NQ	Futures	5380.82	5381.72	5375.47	5376.36	558.0
2016-04-19 22:00:00	NQ	Futures	5376.06	5378.15	5374.58	5375.77	474.0
2016-04-19 23:00:00	NQ	Futures	5375.47	5379.04	5370.41	5372.79	1351.0
2016-04-19 00:00:00	YM	Futures	19177.1	19183.5	19139.6	19152.5	4133.0
2016-04-19 01:00:00	YM	Futures	19153.6	19173.9	19149.3	19170.7	695.0
2016-04-19 02:00:00	YM	Futures	19172.8	19202.8	19172.8	19195.3	3245.0
2016-04-19 03:00:00	YM	Futures	19196.4	19245.6	19184.6	19239.2	5685.0

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

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