PREVIEW / futures_1hour / 2016-08-03

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-03.parquet
  size:    52 KB
  rows:    1,596

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-08-03 00:00:00	ES	Futures	2332.47	2333.83	2330.3	2333.02	8986.0
2016-08-03 01:00:00	ES	Futures	2333.29	2333.29	2331.39	2331.93	3535.0
2016-08-03 02:00:00	ES	Futures	2331.93	2333.83	2330.3	2333.56	11120.0
2016-08-03 03:00:00	ES	Futures	2333.29	2334.1	2327.05	2330.03	42254.0
2016-08-03 04:00:00	ES	Futures	2330.3	2331.39	2328.14	2330.03	20848.0
2016-08-03 05:00:00	ES	Futures	2330.03	2331.93	2328.68	2331.39	17813.0
2016-08-03 06:00:00	ES	Futures	2331.12	2331.93	2330.03	2330.85	14686.0
2016-08-03 07:00:00	ES	Futures	2330.58	2331.66	2329.49	2331.39	22159.0
2016-08-03 08:00:00	ES	Futures	2331.39	2333.29	2330.58	2331.39	30547.0
2016-08-03 09:00:00	ES	Futures	2331.39	2335.73	2328.95	2333.83	198467.0
2016-08-03 10:00:00	ES	Futures	2333.83	2338.17	2332.75	2334.64	279134.0
2016-08-03 11:00:00	ES	Futures	2334.92	2337.63	2333.29	2337.08	155067.0
2016-08-03 12:00:00	ES	Futures	2336.81	2338.98	2335.73	2337.9	85661.0
2016-08-03 13:00:00	ES	Futures	2338.17	2338.98	2335.73	2337.08	69489.0
2016-08-03 14:00:00	ES	Futures	2337.08	2337.9	2333.83	2335.46	113156.0
2016-08-03 15:00:00	ES	Futures	2335.73	2341.15	2334.92	2340.61	172845.0
2016-08-03 16:00:00	ES	Futures	2340.88	2340.88	2337.63	2339.53	80799.0
2016-08-03 18:00:00	ES	Futures	2339.53	2340.61	2338.71	2339.53	4018.0
2016-08-03 19:00:00	ES	Futures	2339.53	2341.15	2339.53	2340.88	3704.0
2016-08-03 20:00:00	ES	Futures	2340.88	2343.86	2340.61	2342.24	9243.0
2016-08-03 21:00:00	ES	Futures	2342.24	2342.78	2338.71	2338.98	9722.0
2016-08-03 22:00:00	ES	Futures	2338.98	2340.34	2338.71	2339.8	4601.0
2016-08-03 23:00:00	ES	Futures	2339.8	2341.15	2338.98	2339.53	4025.0
2016-08-03 00:00:00	NQ	Futures	5612.31	5616.19	5607.24	5613.8	1791.0
2016-08-03 01:00:00	NQ	Futures	5613.8	5614.7	5610.52	5612.31	605.0
2016-08-03 02:00:00	NQ	Futures	5612.31	5618.57	5608.44	5617.38	1445.0
2016-08-03 03:00:00	NQ	Futures	5617.38	5619.46	5600.98	5608.73	4390.0
2016-08-03 04:00:00	NQ	Futures	5609.03	5610.82	5602.77	5606.65	2046.0
2016-08-03 05:00:00	NQ	Futures	5606.65	5613.8	5602.77	5610.82	2170.0
2016-08-03 06:00:00	NQ	Futures	5611.12	5612.91	5606.95	5608.44	1828.0
2016-08-03 07:00:00	NQ	Futures	5608.44	5610.52	5605.75	5610.22	1626.0
2016-08-03 08:00:00	NQ	Futures	5609.93	5615.29	5608.73	5610.22	2988.0
2016-08-03 09:00:00	NQ	Futures	5609.93	5629.0	5609.33	5624.83	32525.0
2016-08-03 10:00:00	NQ	Futures	5624.53	5633.47	5616.48	5618.27	35672.0
2016-08-03 11:00:00	NQ	Futures	5618.57	5625.43	5614.99	5623.64	17508.0
2016-08-03 12:00:00	NQ	Futures	5623.93	5625.13	5615.29	5621.55	11964.0
2016-08-03 13:00:00	NQ	Futures	5621.55	5627.21	5619.76	5624.23	7728.0
2016-08-03 14:00:00	NQ	Futures	5623.93	5627.81	5619.17	5625.43	11670.0
2016-08-03 15:00:00	NQ	Futures	5625.72	5637.65	5625.13	5637.35	21157.0
2016-08-03 16:00:00	NQ	Futures	5637.35	5638.24	5630.79	5634.66	6569.0
2016-08-03 18:00:00	NQ	Futures	5634.96	5636.16	5630.49	5632.88	515.0
2016-08-03 19:00:00	NQ	Futures	5632.88	5637.35	5632.88	5637.05	454.0
2016-08-03 20:00:00	NQ	Futures	5636.75	5643.31	5636.16	5639.14	1234.0
2016-08-03 21:00:00	NQ	Futures	5638.84	5639.73	5628.7	5630.19	1314.0
2016-08-03 22:00:00	NQ	Futures	5629.9	5633.17	5628.7	5630.79	620.0
2016-08-03 23:00:00	NQ	Futures	5630.79	5634.96	5629.6	5632.28	526.0
2016-08-03 00:00:00	YM	Futures	19617.1	19625.7	19596.6	19618.1	1535.0
2016-08-03 01:00:00	YM	Futures	19619.2	19620.3	19606.3	19611.7	693.0
2016-08-03 02:00:00	YM	Futures	19611.7	19627.8	19598.8	19622.4	1126.0
2016-08-03 03:00:00	YM	Futures	19623.5	19630.0	19574.0	19597.7	5319.0

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

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