PREVIEW / futures_1hour / 2019-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-08.parquet
  size:    51 KB
  rows:    1,506

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
2019-11-08 00:00:00	ES	Futures	3344.59	3346.22	3342.96	3345.95	7159.0
2019-11-08 01:00:00	ES	Futures	3345.95	3346.77	3344.05	3346.22	4975.0
2019-11-08 02:00:00	ES	Futures	3346.49	3350.3	3345.95	3349.21	12448.0
2019-11-08 03:00:00	ES	Futures	3349.21	3351.93	3348.12	3348.94	15377.0
2019-11-08 04:00:00	ES	Futures	3348.67	3350.02	3347.31	3349.21	9444.0
2019-11-08 05:00:00	ES	Futures	3349.21	3351.38	3348.94	3350.84	8335.0
2019-11-08 06:00:00	ES	Futures	3350.84	3352.47	3350.57	3351.38	10200.0
2019-11-08 07:00:00	ES	Futures	3351.11	3355.46	3347.58	3349.48	27000.0
2019-11-08 08:00:00	ES	Futures	3349.48	3351.93	3347.85	3350.02	22276.0
2019-11-08 09:00:00	ES	Futures	3349.75	3352.2	3340.25	3341.6	152038.0
2019-11-08 10:00:00	ES	Futures	3341.6	3350.84	3338.34	3349.75	215712.0
2019-11-08 11:00:00	ES	Futures	3350.02	3351.93	3345.95	3351.38	105046.0
2019-11-08 12:00:00	ES	Futures	3351.38	3353.56	3350.84	3351.93	57994.0
2019-11-08 13:00:00	ES	Futures	3351.93	3352.74	3349.75	3350.02	46288.0
2019-11-08 14:00:00	ES	Futures	3349.75	3351.38	3349.21	3351.38	49147.0
2019-11-08 15:00:00	ES	Futures	3351.11	3359.53	3351.11	3359.53	155723.0
2019-11-08 16:00:00	ES	Futures	3359.26	3360.08	3357.36	3359.53	61918.0
2019-11-08 00:00:00	NQ	Futures	9530.76	9535.12	9523.79	9534.25	2801.0
2019-11-08 01:00:00	NQ	Futures	9534.25	9536.28	9525.82	9534.25	2207.0
2019-11-08 02:00:00	NQ	Futures	9534.25	9551.1	9533.67	9548.19	5084.0
2019-11-08 03:00:00	NQ	Futures	9547.9	9557.49	9542.96	9544.12	5938.0
2019-11-08 04:00:00	NQ	Futures	9544.42	9548.48	9536.57	9546.74	4724.0
2019-11-08 05:00:00	NQ	Futures	9546.45	9555.74	9545.0	9552.55	3538.0
2019-11-08 06:00:00	NQ	Futures	9552.26	9558.65	9550.81	9553.13	3150.0
2019-11-08 07:00:00	NQ	Futures	9553.13	9570.27	9540.64	9547.32	8437.0
2019-11-08 08:00:00	NQ	Futures	9546.74	9553.13	9540.35	9546.16	7921.0
2019-11-08 09:00:00	NQ	Futures	9546.45	9567.36	9533.09	9535.12	53844.0
2019-11-08 10:00:00	NQ	Futures	9535.7	9572.88	9516.53	9569.11	64162.0
2019-11-08 11:00:00	NQ	Futures	9569.11	9580.15	9555.74	9572.01	36885.0
2019-11-08 12:00:00	NQ	Futures	9572.01	9583.05	9569.98	9574.05	22822.0
2019-11-08 13:00:00	NQ	Futures	9574.05	9575.5	9562.43	9562.72	16795.0
2019-11-08 14:00:00	NQ	Futures	9562.72	9571.14	9560.97	9568.24	14213.0
2019-11-08 15:00:00	NQ	Futures	9568.24	9599.9	9567.07	9599.61	34585.0
2019-11-08 16:00:00	NQ	Futures	9599.9	9602.8	9592.06	9598.45	9313.0
2019-11-08 00:00:00	YM	Futures	30053.8	30069.0	30037.4	30067.9	1479.0
2019-11-08 01:00:00	YM	Futures	30066.8	30072.3	30046.1	30067.9	1043.0
2019-11-08 02:00:00	YM	Futures	30066.8	30098.4	30064.6	30085.3	2823.0
2019-11-08 03:00:00	YM	Futures	30086.4	30104.9	30073.4	30083.1	3221.0
2019-11-08 04:00:00	YM	Futures	30084.2	30096.2	30074.4	30088.6	2217.0
2019-11-08 05:00:00	YM	Futures	30088.6	30111.4	30086.4	30107.1	1939.0
2019-11-08 06:00:00	YM	Futures	30106.0	30118.0	30099.5	30106.0	1715.0
2019-11-08 07:00:00	YM	Futures	30106.0	30148.4	30088.6	30107.1	6047.0
2019-11-08 08:00:00	YM	Futures	30104.9	30127.8	30095.1	30111.4	5844.0
2019-11-08 09:00:00	YM	Futures	30111.4	30115.8	30001.5	30007.0	20302.0
2019-11-08 10:00:00	YM	Futures	30007.0	30049.4	29974.3	30028.7	21426.0
2019-11-08 11:00:00	YM	Futures	30029.8	30041.8	29977.6	30029.8	11467.0
2019-11-08 12:00:00	YM	Futures	30028.7	30049.4	30021.1	30046.1	8066.0
2019-11-08 13:00:00	YM	Futures	30046.1	30053.8	30024.4	30026.6	5324.0
2019-11-08 14:00:00	YM	Futures	30027.6	30035.3	30005.9	30028.7	5411.0
2019-11-08 15:00:00	YM	Futures	30027.6	30085.3	30023.3	30083.1	13290.0

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

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