PREVIEW / futures_1hour / 2020-01-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	3528.3	3533.7	3526.7	3532.4	14077.0
2020-01-28 01:00:00	ES	Futures	3532.4	3537.5	3530.5	3536.7	14449.0
2020-01-28 02:00:00	ES	Futures	3537.0	3537.8	3533.2	3534.8	16571.0
2020-01-28 03:00:00	ES	Futures	3535.1	3535.9	3522.3	3524.2	44798.0
2020-01-28 04:00:00	ES	Futures	3524.2	3524.5	3517.2	3521.0	56963.0
2020-01-28 05:00:00	ES	Futures	3521.2	3524.0	3518.0	3521.0	26348.0
2020-01-28 06:00:00	ES	Futures	3521.0	3529.4	3513.9	3528.8	44756.0
2020-01-28 07:00:00	ES	Futures	3529.1	3536.7	3525.9	3532.9	59362.0
2020-01-28 08:00:00	ES	Futures	3532.9	3536.2	3530.7	3532.4	46642.0
2020-01-28 09:00:00	ES	Futures	3532.4	3535.1	3524.8	3530.7	252006.0
2020-01-28 10:00:00	ES	Futures	3530.7	3551.9	3530.7	3550.2	327410.0
2020-01-28 11:00:00	ES	Futures	3550.2	3554.6	3545.4	3554.0	171928.0
2020-01-28 12:00:00	ES	Futures	3554.3	3556.7	3551.6	3553.0	100909.0
2020-01-28 13:00:00	ES	Futures	3552.7	3553.5	3547.5	3552.7	92181.0
2020-01-28 14:00:00	ES	Futures	3552.7	3560.8	3552.7	3556.2	117610.0
2020-01-28 15:00:00	ES	Futures	3556.2	3559.2	3550.0	3551.1	260814.0
2020-01-28 16:00:00	ES	Futures	3550.8	3560.0	3550.0	3558.6	88753.0
2020-01-28 18:00:00	ES	Futures	3557.3	3558.6	3548.6	3550.2	24911.0
2020-01-28 19:00:00	ES	Futures	3550.5	3550.8	3547.8	3549.7	13927.0
2020-01-28 20:00:00	ES	Futures	3549.7	3565.1	3548.6	3561.6	36302.0
2020-01-28 21:00:00	ES	Futures	3561.9	3564.3	3560.8	3563.5	11679.0
2020-01-28 22:00:00	ES	Futures	3563.5	3567.0	3562.7	3566.0	9924.0
2020-01-28 23:00:00	ES	Futures	3566.2	3566.2	3563.0	3563.8	5458.0
2020-01-28 00:00:00	NQ	Futures	10419.49	10442.05	10416.89	10439.44	6632.0
2020-01-28 01:00:00	NQ	Futures	10439.16	10456.51	10432.5	10455.06	7132.0
2020-01-28 02:00:00	NQ	Futures	10455.06	10456.51	10442.91	10448.12	7824.0
2020-01-28 03:00:00	NQ	Futures	10448.12	10451.3	10406.77	10413.13	19529.0
2020-01-28 04:00:00	NQ	Futures	10412.84	10413.13	10380.45	10402.14	23633.0
2020-01-28 05:00:00	NQ	Futures	10402.14	10415.44	10394.04	10402.43	11883.0
2020-01-28 06:00:00	NQ	Futures	10402.14	10433.08	10384.79	10430.77	16849.0
2020-01-28 07:00:00	NQ	Futures	10430.48	10455.93	10420.36	10444.65	22151.0
2020-01-28 08:00:00	NQ	Futures	10444.36	10454.77	10433.95	10442.63	18472.0
2020-01-28 09:00:00	NQ	Futures	10442.63	10456.22	10411.39	10431.35	80569.0
2020-01-28 10:00:00	NQ	Futures	10431.35	10501.04	10429.03	10494.39	99824.0
2020-01-28 11:00:00	NQ	Futures	10494.39	10522.73	10479.93	10521.28	66169.0
2020-01-28 12:00:00	NQ	Futures	10521.28	10534.0	10514.05	10519.55	40982.0
2020-01-28 13:00:00	NQ	Futures	10519.55	10530.82	10505.38	10527.35	32687.0
2020-01-28 14:00:00	NQ	Futures	10527.64	10546.15	10527.35	10538.92	42081.0
2020-01-28 15:00:00	NQ	Futures	10538.92	10548.46	10521.86	10523.88	65380.0
2020-01-28 16:00:00	NQ	Futures	10523.88	10567.84	10521.28	10554.25	22325.0
2020-01-28 18:00:00	NQ	Futures	10548.46	10555.98	10516.36	10525.33	11471.0
2020-01-28 19:00:00	NQ	Futures	10525.91	10527.93	10517.81	10523.59	6329.0
2020-01-28 20:00:00	NQ	Futures	10523.59	10580.56	10520.12	10569.28	15108.0
2020-01-28 21:00:00	NQ	Futures	10569.28	10575.36	10564.66	10571.02	6030.0
2020-01-28 22:00:00	NQ	Futures	10571.31	10585.19	10568.42	10580.27	5075.0
2020-01-28 23:00:00	NQ	Futures	10580.27	10580.27	10568.42	10573.04	2611.0
2020-01-28 00:00:00	YM	Futures	31151.1	31200.1	31139.1	31187.0	3257.0
2020-01-28 01:00:00	YM	Futures	31187.0	31231.7	31170.7	31224.0	3354.0
2020-01-28 02:00:00	YM	Futures	31224.0	31228.4	31192.5	31205.5	3895.0
2020-01-28 03:00:00	YM	Futures	31205.5	31217.5	31096.7	31116.3	11237.0

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

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