PREVIEW / futures_1hour / 2020-02-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-03.parquet
  size:    62 KB
  rows:    1,936

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-02-03 00:00:00	ES	Futures	3517.5	3522.9	3516.9	3520.2	18734.0
2020-02-03 01:00:00	ES	Futures	3520.2	3520.7	3512.6	3514.5	14732.0
2020-02-03 02:00:00	ES	Futures	3514.5	3520.4	3512.6	3516.1	23725.0
2020-02-03 03:00:00	ES	Futures	3516.1	3519.4	3504.7	3513.1	59923.0
2020-02-03 04:00:00	ES	Futures	3513.1	3513.7	3505.3	3505.8	36002.0
2020-02-03 05:00:00	ES	Futures	3505.8	3510.9	3504.2	3508.8	28652.0
2020-02-03 06:00:00	ES	Futures	3508.8	3513.9	3508.8	3511.2	27179.0
2020-02-03 07:00:00	ES	Futures	3511.2	3512.6	3507.4	3510.9	21814.0
2020-02-03 08:00:00	ES	Futures	3510.7	3520.4	3510.1	3513.9	51360.0
2020-02-03 09:00:00	ES	Futures	3513.9	3531.3	3509.6	3531.0	219856.0
2020-02-03 10:00:00	ES	Futures	3531.0	3541.6	3528.0	3531.0	310393.0
2020-02-03 11:00:00	ES	Futures	3531.0	3534.5	3514.7	3520.7	215665.0
2020-02-03 12:00:00	ES	Futures	3520.7	3528.0	3516.6	3526.9	115901.0
2020-02-03 13:00:00	ES	Futures	3526.9	3527.8	3518.3	3524.2	115404.0
2020-02-03 14:00:00	ES	Futures	3524.2	3525.9	3517.2	3523.4	103815.0
2020-02-03 15:00:00	ES	Futures	3523.4	3528.6	3516.6	3519.6	207290.0
2020-02-03 16:00:00	ES	Futures	3519.4	3519.6	3514.5	3517.5	84172.0
2020-02-03 18:00:00	ES	Futures	3516.6	3516.6	3507.7	3513.7	16161.0
2020-02-03 19:00:00	ES	Futures	3513.9	3520.2	3512.8	3519.4	14728.0
2020-02-03 20:00:00	ES	Futures	3519.1	3532.6	3518.8	3531.3	40559.0
2020-02-03 21:00:00	ES	Futures	3531.3	3531.5	3526.1	3529.6	18663.0
2020-02-03 22:00:00	ES	Futures	3529.4	3541.0	3526.9	3537.0	24750.0
2020-02-03 23:00:00	ES	Futures	3537.0	3541.3	3535.3	3537.5	14237.0
2020-02-03 00:00:00	NQ	Futures	10492.65	10512.03	10491.21	10504.22	9311.0
2020-02-03 01:00:00	NQ	Futures	10503.93	10504.8	10471.54	10477.04	7213.0
2020-02-03 02:00:00	NQ	Futures	10476.75	10502.48	10470.96	10489.18	8210.0
2020-02-03 03:00:00	NQ	Futures	10489.18	10500.17	10451.01	10477.9	19595.0
2020-02-03 04:00:00	NQ	Futures	10478.19	10483.11	10448.41	10449.28	12743.0
2020-02-03 05:00:00	NQ	Futures	10448.7	10462.29	10439.73	10453.9	11920.0
2020-02-03 06:00:00	NQ	Futures	10454.19	10475.88	10454.19	10463.45	8949.0
2020-02-03 07:00:00	NQ	Futures	10463.16	10468.36	10447.54	10459.69	10826.0
2020-02-03 08:00:00	NQ	Futures	10459.98	10494.1	10458.53	10477.04	17744.0
2020-02-03 09:00:00	NQ	Futures	10476.75	10557.72	10451.59	10556.27	92563.0
2020-02-03 10:00:00	NQ	Futures	10556.56	10590.39	10547.6	10560.9	99433.0
2020-02-03 11:00:00	NQ	Futures	10561.19	10579.98	10530.53	10547.02	78550.0
2020-02-03 12:00:00	NQ	Futures	10546.73	10579.69	10537.76	10575.64	49874.0
2020-02-03 13:00:00	NQ	Futures	10575.64	10577.67	10533.43	10558.01	46703.0
2020-02-03 14:00:00	NQ	Futures	10557.72	10567.26	10539.21	10555.69	39503.0
2020-02-03 15:00:00	NQ	Futures	10555.69	10583.16	10547.02	10562.34	56022.0
2020-02-03 16:00:00	NQ	Futures	10562.34	10571.31	10512.89	10532.27	20905.0
2020-02-03 18:00:00	NQ	Futures	10524.75	10525.04	10494.68	10513.76	6642.0
2020-02-03 19:00:00	NQ	Futures	10514.63	10538.34	10510.87	10533.71	6262.0
2020-02-03 20:00:00	NQ	Futures	10534.0	10592.71	10532.27	10585.77	19900.0
2020-02-03 21:00:00	NQ	Futures	10585.77	10588.95	10566.68	10580.56	9048.0
2020-02-03 22:00:00	NQ	Futures	10580.56	10625.96	10570.44	10610.63	9839.0
2020-02-03 23:00:00	NQ	Futures	10610.06	10623.94	10605.14	10611.5	4833.0
2020-02-03 00:00:00	YM	Futures	30892.0	30938.8	30886.5	30902.9	4425.0
2020-02-03 01:00:00	YM	Futures	30905.0	30907.2	30838.6	30852.8	3691.0
2020-02-03 02:00:00	YM	Futures	30853.9	30905.0	30835.4	30865.8	4790.0
2020-02-03 03:00:00	YM	Futures	30864.8	30893.1	30771.1	30844.1	9789.0

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

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