PREVIEW / futures_1hour / 2020-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-20.parquet
  size:    62 KB
  rows:    1,866

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
2020-10-20 00:00:00	ES	Futures	3851.58	3851.58	3844.02	3845.7	7278.0
2020-10-20 01:00:00	ES	Futures	3845.7	3852.98	3840.94	3849.9	10581.0
2020-10-20 02:00:00	ES	Futures	3850.18	3851.86	3844.58	3850.18	11627.0
2020-10-20 03:00:00	ES	Futures	3849.9	3857.18	3846.54	3856.34	22434.0
2020-10-20 04:00:00	ES	Futures	3856.34	3859.7	3853.26	3854.38	15943.0
2020-10-20 05:00:00	ES	Futures	3854.66	3859.42	3853.82	3858.58	11677.0
2020-10-20 06:00:00	ES	Futures	3858.58	3867.26	3856.9	3863.62	17990.0
2020-10-20 07:00:00	ES	Futures	3863.9	3864.74	3857.18	3859.42	17333.0
2020-10-20 08:00:00	ES	Futures	3859.42	3859.7	3839.26	3848.5	53753.0
2020-10-20 09:00:00	ES	Futures	3848.5	3864.46	3843.46	3863.9	186213.0
2020-10-20 10:00:00	ES	Futures	3863.62	3869.51	3849.62	3849.9	192211.0
2020-10-20 11:00:00	ES	Futures	3850.18	3856.9	3839.26	3856.34	183589.0
2020-10-20 12:00:00	ES	Futures	3856.34	3874.55	3854.94	3867.26	179906.0
2020-10-20 13:00:00	ES	Futures	3866.98	3887.43	3865.86	3874.27	172133.0
2020-10-20 14:00:00	ES	Futures	3874.55	3880.99	3865.58	3866.7	129289.0
2020-10-20 15:00:00	ES	Futures	3866.98	3872.59	3839.82	3847.66	325599.0
2020-10-20 16:00:00	ES	Futures	3847.38	3851.02	3830.29	3840.66	82900.0
2020-10-20 18:00:00	ES	Futures	3850.74	3857.74	3843.74	3855.78	16876.0
2020-10-20 19:00:00	ES	Futures	3855.5	3864.74	3853.54	3859.14	17335.0
2020-10-20 20:00:00	ES	Futures	3859.42	3865.86	3857.18	3861.1	12692.0
2020-10-20 21:00:00	ES	Futures	3861.38	3864.18	3857.46	3860.26	10969.0
2020-10-20 22:00:00	ES	Futures	3860.26	3869.23	3860.26	3865.3	13407.0
2020-10-20 23:00:00	ES	Futures	3865.02	3874.27	3863.9	3870.35	12743.0
2020-10-20 00:00:00	NQ	Futures	13564.5	13566.82	13539.03	13548.87	4855.0
2020-10-20 01:00:00	NQ	Futures	13548.0	13582.74	13526.29	13571.74	8032.0
2020-10-20 02:00:00	NQ	Futures	13571.16	13574.92	13543.37	13565.66	4224.0
2020-10-20 03:00:00	NQ	Futures	13565.66	13596.06	13559.58	13583.9	6583.0
2020-10-20 04:00:00	NQ	Futures	13582.74	13597.21	13565.08	13570.29	6406.0
2020-10-20 05:00:00	NQ	Futures	13570.87	13585.63	13560.16	13575.79	3949.0
2020-10-20 06:00:00	NQ	Futures	13575.5	13608.5	13569.42	13598.08	4081.0
2020-10-20 07:00:00	NQ	Futures	13598.37	13599.82	13563.63	13573.48	5448.0
2020-10-20 08:00:00	NQ	Futures	13573.19	13573.77	13484.61	13518.77	29016.0
2020-10-20 09:00:00	NQ	Futures	13519.06	13555.24	13468.11	13550.61	78157.0
2020-10-20 10:00:00	NQ	Futures	13551.19	13589.69	13473.03	13473.9	83941.0
2020-10-20 11:00:00	NQ	Futures	13473.9	13528.61	13429.61	13527.16	75099.0
2020-10-20 12:00:00	NQ	Futures	13526.29	13593.74	13516.74	13561.9	57632.0
2020-10-20 13:00:00	NQ	Futures	13562.19	13653.66	13555.53	13605.03	50123.0
2020-10-20 14:00:00	NQ	Futures	13605.32	13641.5	13571.45	13581.0	55633.0
2020-10-20 15:00:00	NQ	Futures	13581.0	13612.84	13474.19	13504.29	92632.0
2020-10-20 16:00:00	NQ	Futures	13504.29	13521.37	13456.53	13492.72	18096.0
2020-10-20 18:00:00	NQ	Futures	13518.48	13548.0	13505.74	13541.06	5215.0
2020-10-20 19:00:00	NQ	Futures	13539.9	13567.98	13536.42	13551.77	6843.0
2020-10-20 20:00:00	NQ	Futures	13552.92	13585.35	13542.5	13571.16	6264.0
2020-10-20 21:00:00	NQ	Futures	13572.32	13589.11	13554.66	13576.08	4368.0
2020-10-20 22:00:00	NQ	Futures	13576.37	13593.16	13564.21	13572.61	7215.0
2020-10-20 23:00:00	NQ	Futures	13572.61	13599.24	13567.11	13581.87	5373.0
2020-10-20 00:00:00	YM	Futures	31181.8	31181.8	31119.9	31128.7	1202.0
2020-10-20 01:00:00	YM	Futures	31128.7	31176.3	31090.0	31154.1	2133.0
2020-10-20 02:00:00	YM	Futures	31153.0	31160.8	31114.3	31145.3	2156.0
2020-10-20 03:00:00	YM	Futures	31147.5	31213.8	31124.3	31208.3	4367.0

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

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