PREVIEW / futures_1hour / 2016-10-14

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-14.parquet
  size:    45 KB
  rows:    1,325

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-10-14 00:00:00	ES	Futures	2315.12	2316.21	2314.3	2316.21	2748.0
2016-10-14 01:00:00	ES	Futures	2315.94	2316.75	2313.76	2315.12	3251.0
2016-10-14 02:00:00	ES	Futures	2314.85	2315.66	2312.94	2312.94	8485.0
2016-10-14 03:00:00	ES	Futures	2312.94	2316.75	2312.4	2315.39	27127.0
2016-10-14 04:00:00	ES	Futures	2315.66	2318.93	2314.3	2318.11	14972.0
2016-10-14 05:00:00	ES	Futures	2318.39	2323.28	2317.57	2321.92	25408.0
2016-10-14 06:00:00	ES	Futures	2321.92	2327.64	2321.65	2324.92	31876.0
2016-10-14 07:00:00	ES	Futures	2325.19	2325.46	2323.01	2323.01	15843.0
2016-10-14 08:00:00	ES	Futures	2322.74	2326.0	2320.29	2324.64	49916.0
2016-10-14 09:00:00	ES	Futures	2324.64	2330.9	2324.37	2329.27	218613.0
2016-10-14 10:00:00	ES	Futures	2329.27	2332.53	2326.82	2327.09	231997.0
2016-10-14 11:00:00	ES	Futures	2327.09	2327.09	2317.02	2317.3	299054.0
2016-10-14 12:00:00	ES	Futures	2317.57	2320.29	2314.3	2318.93	166260.0
2016-10-14 13:00:00	ES	Futures	2318.93	2325.73	2316.75	2319.75	173232.0
2016-10-14 14:00:00	ES	Futures	2319.47	2321.92	2315.39	2315.94	186474.0
2016-10-14 15:00:00	ES	Futures	2316.21	2321.38	2314.3	2314.85	231107.0
2016-10-14 16:00:00	ES	Futures	2315.12	2316.75	2312.67	2314.03	107768.0
2016-10-14 00:00:00	NQ	Futures	5724.75	5727.43	5722.96	5727.14	379.0
2016-10-14 01:00:00	NQ	Futures	5727.14	5727.73	5721.17	5724.45	464.0
2016-10-14 02:00:00	NQ	Futures	5724.75	5726.54	5719.68	5719.98	1357.0
2016-10-14 03:00:00	NQ	Futures	5719.68	5728.63	5717.89	5724.15	3356.0
2016-10-14 04:00:00	NQ	Futures	5724.75	5733.4	5721.17	5731.91	2004.0
2016-10-14 05:00:00	NQ	Futures	5731.91	5743.54	5731.01	5740.26	3199.0
2016-10-14 06:00:00	NQ	Futures	5739.96	5754.88	5739.96	5748.91	4228.0
2016-10-14 07:00:00	NQ	Futures	5748.91	5749.51	5743.25	5743.25	1557.0
2016-10-14 08:00:00	NQ	Futures	5742.95	5749.81	5738.17	5746.53	6429.0
2016-10-14 09:00:00	NQ	Futures	5746.53	5776.96	5745.93	5770.39	38531.0
2016-10-14 10:00:00	NQ	Futures	5770.1	5776.66	5762.94	5767.71	29699.0
2016-10-14 11:00:00	NQ	Futures	5767.71	5769.2	5736.09	5736.98	33481.0
2016-10-14 12:00:00	NQ	Futures	5736.98	5744.44	5728.93	5741.46	20690.0
2016-10-14 13:00:00	NQ	Futures	5741.16	5755.18	5734.59	5739.07	21530.0
2016-10-14 14:00:00	NQ	Futures	5739.07	5744.14	5728.33	5730.42	22327.0
2016-10-14 15:00:00	NQ	Futures	5730.12	5745.33	5730.12	5732.21	29655.0
2016-10-14 16:00:00	NQ	Futures	5732.21	5735.79	5724.15	5730.42	9201.0
2016-10-14 00:00:00	YM	Futures	19478.6	19486.2	19472.1	19486.2	517.0
2016-10-14 01:00:00	YM	Futures	19486.2	19489.4	19466.7	19475.3	778.0
2016-10-14 02:00:00	YM	Futures	19476.4	19482.9	19461.3	19462.4	1676.0
2016-10-14 03:00:00	YM	Futures	19462.4	19497.0	19457.0	19482.9	4340.0
2016-10-14 04:00:00	YM	Futures	19484.0	19515.3	19474.3	19508.8	2808.0
2016-10-14 05:00:00	YM	Futures	19507.8	19549.9	19503.4	19538.0	3779.0
2016-10-14 06:00:00	YM	Futures	19538.0	19592.1	19538.0	19574.8	5364.0
2016-10-14 07:00:00	YM	Futures	19575.9	19578.0	19559.6	19559.6	2137.0
2016-10-14 08:00:00	YM	Futures	19559.6	19582.3	19535.9	19573.7	5776.0
2016-10-14 09:00:00	YM	Futures	19573.7	19645.0	19567.2	19612.6	26038.0
2016-10-14 10:00:00	YM	Futures	19612.6	19641.8	19594.2	19611.5	18657.0
2016-10-14 11:00:00	YM	Futures	19611.5	19611.5	19531.5	19541.3	24951.0
2016-10-14 12:00:00	YM	Futures	19542.4	19551.0	19511.0	19544.5	17980.0
2016-10-14 13:00:00	YM	Futures	19544.5	19592.1	19527.2	19543.4	14823.0
2016-10-14 14:00:00	YM	Futures	19542.4	19571.5	19520.7	19528.3	13279.0
2016-10-14 15:00:00	YM	Futures	19529.4	19564.0	19507.8	19513.2	14632.0

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

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