PREVIEW / futures_1hour / 2020-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-30.parquet
  size:    62 KB
  rows:    1,917

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-01-30 00:00:00	ES	Futures	3526.7	3530.5	3522.9	3527.5	20941.0
2020-01-30 01:00:00	ES	Futures	3527.8	3529.4	3524.0	3524.5	13403.0
2020-01-30 02:00:00	ES	Futures	3524.2	3526.4	3511.8	3517.2	57813.0
2020-01-30 03:00:00	ES	Futures	3517.5	3523.4	3513.4	3522.9	53676.0
2020-01-30 04:00:00	ES	Futures	3522.6	3532.4	3520.7	3526.7	48099.0
2020-01-30 05:00:00	ES	Futures	3526.7	3527.5	3522.3	3523.7	28110.0
2020-01-30 06:00:00	ES	Futures	3523.7	3524.5	3515.0	3521.8	36421.0
2020-01-30 07:00:00	ES	Futures	3522.1	3523.7	3516.9	3518.3	36574.0
2020-01-30 08:00:00	ES	Futures	3518.3	3530.2	3515.8	3524.5	70823.0
2020-01-30 09:00:00	ES	Futures	3524.5	3538.9	3521.2	3531.3	264001.0
2020-01-30 10:00:00	ES	Futures	3531.3	3538.6	3513.1	3515.0	282792.0
2020-01-30 11:00:00	ES	Futures	3515.0	3536.7	3514.2	3530.7	250685.0
2020-01-30 12:00:00	ES	Futures	3530.7	3532.9	3516.4	3521.0	200778.0
2020-01-30 13:00:00	ES	Futures	3521.0	3525.9	3518.5	3524.0	95858.0
2020-01-30 14:00:00	ES	Futures	3524.0	3541.6	3522.9	3538.6	293626.0
2020-01-30 15:00:00	ES	Futures	3538.6	3561.1	3537.0	3558.4	361347.0
2020-01-30 16:00:00	ES	Futures	3558.4	3571.9	3557.3	3570.8	121948.0
2020-01-30 18:00:00	ES	Futures	3568.4	3568.9	3564.9	3565.4	18582.0
2020-01-30 19:00:00	ES	Futures	3565.7	3568.9	3560.5	3568.7	24765.0
2020-01-30 20:00:00	ES	Futures	3568.7	3574.4	3563.8	3564.1	32284.0
2020-01-30 21:00:00	ES	Futures	3564.1	3573.3	3563.8	3569.8	19385.0
2020-01-30 22:00:00	ES	Futures	3570.0	3571.1	3567.3	3569.2	7769.0
2020-01-30 23:00:00	ES	Futures	3568.9	3571.7	3567.9	3571.7	5567.0
2020-01-30 00:00:00	NQ	Futures	10477.9	10489.47	10459.98	10479.06	11028.0
2020-01-30 01:00:00	NQ	Futures	10479.06	10483.98	10461.42	10465.47	7070.0
2020-01-30 02:00:00	NQ	Futures	10465.18	10472.7	10414.29	10430.48	26165.0
2020-01-30 03:00:00	NQ	Futures	10430.77	10455.93	10418.05	10454.48	22320.0
2020-01-30 04:00:00	NQ	Futures	10454.19	10490.63	10448.12	10470.39	18849.0
2020-01-30 05:00:00	NQ	Futures	10470.67	10471.83	10453.32	10458.24	10680.0
2020-01-30 06:00:00	NQ	Futures	10458.24	10461.71	10431.35	10454.77	15326.0
2020-01-30 07:00:00	NQ	Futures	10454.77	10467.49	10446.67	10453.04	15656.0
2020-01-30 08:00:00	NQ	Futures	10453.32	10495.54	10445.81	10479.06	27985.0
2020-01-30 09:00:00	NQ	Futures	10479.06	10542.97	10461.71	10508.27	102055.0
2020-01-30 10:00:00	NQ	Futures	10508.27	10536.61	10439.73	10442.34	112030.0
2020-01-30 11:00:00	NQ	Futures	10442.05	10517.23	10438.58	10496.7	84833.0
2020-01-30 12:00:00	NQ	Futures	10496.7	10504.51	10447.25	10462.0	68129.0
2020-01-30 13:00:00	NQ	Futures	10462.0	10481.66	10451.01	10476.46	42168.0
2020-01-30 14:00:00	NQ	Futures	10476.46	10545.86	10472.12	10525.04	88812.0
2020-01-30 15:00:00	NQ	Futures	10525.04	10581.72	10517.81	10577.09	99877.0
2020-01-30 16:00:00	NQ	Futures	10577.09	10687.84	10575.07	10684.95	29471.0
2020-01-30 18:00:00	NQ	Futures	10672.23	10674.54	10656.9	10662.98	7853.0
2020-01-30 19:00:00	NQ	Futures	10662.4	10676.86	10645.62	10675.99	10486.0
2020-01-30 20:00:00	NQ	Futures	10675.99	10697.97	10654.3	10655.17	12871.0
2020-01-30 21:00:00	NQ	Futures	10655.17	10692.47	10655.17	10679.75	8572.0
2020-01-30 22:00:00	NQ	Futures	10680.33	10685.53	10668.18	10678.59	3971.0
2020-01-30 23:00:00	NQ	Futures	10678.3	10689.0	10673.96	10688.71	2659.0
2020-01-30 00:00:00	YM	Futures	31080.3	31114.1	31047.7	31091.2	4133.0
2020-01-30 01:00:00	YM	Futures	31092.3	31111.9	31065.1	31069.4	2446.0
2020-01-30 02:00:00	YM	Futures	31068.4	31084.7	30955.1	31006.3	11580.0
2020-01-30 03:00:00	YM	Futures	31007.4	31055.3	30971.5	31052.0	10986.0

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

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