PREVIEW / futures_1hour / 2020-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-23.parquet
  size:    51 KB
  rows:    1,521

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-23 00:00:00	ES	Futures	3868.11	3868.95	3865.02	3867.54	3540.0
2020-10-23 01:00:00	ES	Futures	3867.54	3868.95	3859.98	3860.54	6159.0
2020-10-23 02:00:00	ES	Futures	3860.82	3860.82	3850.74	3854.38	15475.0
2020-10-23 03:00:00	ES	Futures	3854.66	3872.31	3853.54	3871.19	29015.0
2020-10-23 04:00:00	ES	Futures	3870.91	3876.51	3868.39	3868.95	21708.0
2020-10-23 05:00:00	ES	Futures	3868.67	3877.07	3867.26	3870.63	16630.0
2020-10-23 06:00:00	ES	Futures	3870.63	3878.19	3867.82	3873.71	16693.0
2020-10-23 07:00:00	ES	Futures	3873.99	3878.75	3870.91	3875.67	16174.0
2020-10-23 08:00:00	ES	Futures	3875.95	3879.31	3873.99	3877.35	23026.0
2020-10-23 09:00:00	ES	Futures	3877.35	3878.47	3864.18	3869.79	154146.0
2020-10-23 10:00:00	ES	Futures	3869.51	3869.79	3859.14	3862.78	161111.0
2020-10-23 11:00:00	ES	Futures	3862.78	3868.67	3850.18	3856.34	174244.0
2020-10-23 12:00:00	ES	Futures	3856.34	3859.7	3844.58	3847.94	148282.0
2020-10-23 13:00:00	ES	Futures	3847.94	3862.22	3847.38	3860.26	73463.0
2020-10-23 14:00:00	ES	Futures	3859.98	3867.54	3858.3	3863.06	87167.0
2020-10-23 15:00:00	ES	Futures	3863.06	3874.83	3862.78	3874.55	144615.0
2020-10-23 16:00:00	ES	Futures	3874.27	3874.55	3866.7	3868.39	42128.0
2020-10-23 00:00:00	NQ	Futures	13513.85	13520.21	13493.58	13510.08	2032.0
2020-10-23 01:00:00	NQ	Futures	13508.93	13514.14	13476.79	13481.14	3617.0
2020-10-23 02:00:00	NQ	Futures	13480.56	13485.48	13433.66	13460.29	6306.0
2020-10-23 03:00:00	NQ	Futures	13459.72	13518.19	13453.35	13510.95	8149.0
2020-10-23 04:00:00	NQ	Futures	13510.66	13526.29	13486.06	13488.95	5731.0
2020-10-23 05:00:00	NQ	Futures	13489.53	13512.11	13480.27	13494.16	3724.0
2020-10-23 06:00:00	NQ	Futures	13494.74	13515.87	13469.85	13502.85	5318.0
2020-10-23 07:00:00	NQ	Futures	13502.27	13526.0	13494.45	13513.27	5697.0
2020-10-23 08:00:00	NQ	Futures	13513.27	13537.58	13506.32	13527.74	10139.0
2020-10-23 09:00:00	NQ	Futures	13527.45	13529.48	13420.06	13448.72	72451.0
2020-10-23 10:00:00	NQ	Futures	13448.14	13463.77	13394.01	13434.82	83204.0
2020-10-23 11:00:00	NQ	Futures	13434.24	13475.93	13374.61	13412.53	75174.0
2020-10-23 12:00:00	NQ	Futures	13412.82	13450.45	13385.61	13424.4	69163.0
2020-10-23 13:00:00	NQ	Futures	13424.4	13471.29	13420.93	13459.14	40150.0
2020-10-23 14:00:00	NQ	Futures	13459.14	13487.22	13451.32	13456.53	35328.0
2020-10-23 15:00:00	NQ	Futures	13456.24	13525.43	13454.51	13523.98	41010.0
2020-10-23 16:00:00	NQ	Futures	13523.98	13523.98	13500.82	13511.53	9694.0
2020-10-23 00:00:00	YM	Futures	31278.0	31289.0	31258.1	31279.1	682.0
2020-10-23 01:00:00	YM	Futures	31279.1	31289.0	31226.0	31231.5	1277.0
2020-10-23 02:00:00	YM	Futures	31232.6	31233.7	31163.0	31195.1	2959.0
2020-10-23 03:00:00	YM	Futures	31195.1	31329.9	31185.1	31313.4	5472.0
2020-10-23 04:00:00	YM	Futures	31314.5	31374.2	31304.5	31315.6	3650.0
2020-10-23 05:00:00	YM	Futures	31314.5	31380.8	31306.7	31331.0	2074.0
2020-10-23 06:00:00	YM	Futures	31332.1	31390.7	31314.5	31363.1	2551.0
2020-10-23 07:00:00	YM	Futures	31362.0	31376.4	31324.4	31348.7	3017.0
2020-10-23 08:00:00	YM	Futures	31348.7	31369.7	31334.4	31353.2	2656.0
2020-10-23 09:00:00	YM	Futures	31352.0	31363.1	31259.2	31284.6	14726.0
2020-10-23 10:00:00	YM	Futures	31283.5	31284.6	31180.7	31202.8	17327.0
2020-10-23 11:00:00	YM	Futures	31202.8	31252.5	31103.3	31138.7	18595.0
2020-10-23 12:00:00	YM	Futures	31138.7	31163.0	31007.1	31027.0	15540.0
2020-10-23 13:00:00	YM	Futures	31025.9	31144.2	31021.5	31138.7	8017.0
2020-10-23 14:00:00	YM	Futures	31137.6	31191.7	31123.2	31165.2	8336.0
2020-10-23 15:00:00	YM	Futures	31163.0	31221.6	31161.9	31218.3	13046.0

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

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