PREVIEW / futures_1hour / 2016-09-20

all futures 1-hour files

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

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-09-20 00:00:00	ES	Futures	2324.92	2325.46	2324.1	2324.92	2029.0
2016-09-20 01:00:00	ES	Futures	2325.19	2326.0	2324.37	2325.73	3165.0
2016-09-20 02:00:00	ES	Futures	2325.73	2326.82	2325.19	2326.0	5094.0
2016-09-20 03:00:00	ES	Futures	2326.0	2328.18	2324.37	2327.36	25775.0
2016-09-20 04:00:00	ES	Futures	2327.64	2327.91	2324.1	2326.0	16404.0
2016-09-20 05:00:00	ES	Futures	2325.73	2329.54	2325.46	2329.54	15629.0
2016-09-20 06:00:00	ES	Futures	2329.54	2331.17	2327.91	2329.54	22132.0
2016-09-20 07:00:00	ES	Futures	2329.81	2330.9	2327.91	2328.45	19189.0
2016-09-20 08:00:00	ES	Futures	2328.72	2331.44	2328.18	2329.54	29697.0
2016-09-20 09:00:00	ES	Futures	2329.27	2332.26	2326.28	2330.08	211587.0
2016-09-20 10:00:00	ES	Futures	2330.08	2332.81	2323.01	2325.19	217924.0
2016-09-20 11:00:00	ES	Futures	2325.19	2329.0	2323.55	2323.83	146770.0
2016-09-20 12:00:00	ES	Futures	2324.1	2326.55	2319.75	2320.29	135399.0
2016-09-20 13:00:00	ES	Futures	2320.56	2325.73	2319.2	2324.64	103280.0
2016-09-20 14:00:00	ES	Futures	2324.64	2327.09	2323.01	2326.0	92714.0
2016-09-20 15:00:00	ES	Futures	2326.0	2327.64	2319.2	2320.02	223080.0
2016-09-20 16:00:00	ES	Futures	2319.75	2321.38	2317.02	2318.11	88383.0
2016-09-20 18:00:00	ES	Futures	2318.11	2320.56	2317.57	2319.75	4640.0
2016-09-20 19:00:00	ES	Futures	2320.02	2320.56	2319.47	2319.47	1558.0
2016-09-20 20:00:00	ES	Futures	2319.47	2321.38	2318.11	2320.83	5222.0
2016-09-20 21:00:00	ES	Futures	2320.83	2321.11	2319.2	2320.83	5266.0
2016-09-20 22:00:00	ES	Futures	2320.83	2320.83	2319.47	2319.75	3285.0
2016-09-20 23:00:00	ES	Futures	2320.02	2323.55	2318.11	2321.92	6841.0
2016-09-20 00:00:00	NQ	Futures	5730.72	5732.51	5728.93	5732.51	332.0
2016-09-20 01:00:00	NQ	Futures	5732.8	5735.19	5730.42	5735.19	708.0
2016-09-20 02:00:00	NQ	Futures	5734.89	5736.38	5731.31	5732.8	1255.0
2016-09-20 03:00:00	NQ	Futures	5732.8	5737.28	5727.14	5735.19	4760.0
2016-09-20 04:00:00	NQ	Futures	5735.19	5735.49	5727.14	5732.21	2062.0
2016-09-20 05:00:00	NQ	Futures	5731.91	5741.16	5731.01	5740.56	2111.0
2016-09-20 06:00:00	NQ	Futures	5740.26	5743.84	5737.28	5740.26	2606.0
2016-09-20 07:00:00	NQ	Futures	5740.26	5743.25	5737.88	5738.77	2119.0
2016-09-20 08:00:00	NQ	Futures	5738.47	5746.53	5736.38	5737.88	4475.0
2016-09-20 09:00:00	NQ	Futures	5737.58	5751.0	5732.21	5747.12	34361.0
2016-09-20 10:00:00	NQ	Futures	5747.12	5752.49	5724.15	5734.0	33304.0
2016-09-20 11:00:00	NQ	Futures	5733.7	5744.14	5727.14	5728.33	20493.0
2016-09-20 12:00:00	NQ	Futures	5728.33	5736.68	5721.47	5722.36	18465.0
2016-09-20 13:00:00	NQ	Futures	5722.06	5736.98	5719.68	5735.19	15518.0
2016-09-20 14:00:00	NQ	Futures	5734.89	5744.14	5732.8	5741.75	14146.0
2016-09-20 15:00:00	NQ	Futures	5741.46	5744.44	5728.93	5729.82	22681.0
2016-09-20 16:00:00	NQ	Futures	5729.82	5733.1	5722.66	5727.43	5704.0
2016-09-20 18:00:00	NQ	Futures	5728.03	5734.0	5726.54	5731.31	601.0
2016-09-20 19:00:00	NQ	Futures	5731.01	5732.21	5729.22	5729.52	253.0
2016-09-20 20:00:00	NQ	Futures	5729.82	5732.8	5725.64	5730.72	846.0
2016-09-20 21:00:00	NQ	Futures	5730.42	5732.21	5726.54	5730.12	946.0
2016-09-20 22:00:00	NQ	Futures	5730.42	5730.72	5726.84	5728.33	393.0
2016-09-20 23:00:00	NQ	Futures	5728.93	5735.19	5727.14	5733.1	1228.0
2016-09-20 00:00:00	YM	Futures	19535.9	19539.1	19530.5	19538.0	334.0
2016-09-20 01:00:00	YM	Futures	19538.0	19542.4	19530.5	19542.4	357.0
2016-09-20 02:00:00	YM	Futures	19541.3	19547.8	19534.8	19539.1	1015.0
2016-09-20 03:00:00	YM	Futures	19540.2	19558.6	19527.2	19552.1	3545.0

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

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