PREVIEW / futures_1hour / 2020-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-29.parquet
  size:    60 KB
  rows:    1,888

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-29 00:00:00	ES	Futures	3564.1	3565.1	3562.4	3562.7	5508.0
2020-01-29 01:00:00	ES	Futures	3562.7	3563.8	3560.3	3560.5	6570.0
2020-01-29 02:00:00	ES	Futures	3560.5	3561.1	3558.1	3560.3	11987.0
2020-01-29 03:00:00	ES	Futures	3560.3	3566.2	3556.7	3563.0	32043.0
2020-01-29 04:00:00	ES	Futures	3563.0	3564.6	3556.7	3558.6	24122.0
2020-01-29 05:00:00	ES	Futures	3558.6	3564.3	3558.1	3563.8	13993.0
2020-01-29 06:00:00	ES	Futures	3563.5	3567.6	3561.9	3566.0	21491.0
2020-01-29 07:00:00	ES	Futures	3566.2	3568.1	3563.8	3565.1	35144.0
2020-01-29 08:00:00	ES	Futures	3564.9	3566.8	3561.1	3561.9	36604.0
2020-01-29 09:00:00	ES	Futures	3561.9	3567.6	3553.0	3554.3	192214.0
2020-01-29 10:00:00	ES	Futures	3554.3	3561.1	3544.8	3560.5	308389.0
2020-01-29 11:00:00	ES	Futures	3560.3	3563.0	3557.8	3561.1	139263.0
2020-01-29 12:00:00	ES	Futures	3561.4	3563.3	3559.7	3560.3	78000.0
2020-01-29 13:00:00	ES	Futures	3560.5	3565.7	3558.6	3562.4	72838.0
2020-01-29 14:00:00	ES	Futures	3562.4	3569.2	3559.5	3559.5	149117.0
2020-01-29 15:00:00	ES	Futures	3559.7	3561.1	3546.4	3547.3	296636.0
2020-01-29 16:00:00	ES	Futures	3547.3	3550.0	3539.4	3545.4	95773.0
2020-01-29 18:00:00	ES	Futures	3546.2	3552.7	3544.8	3548.1	17874.0
2020-01-29 19:00:00	ES	Futures	3548.1	3549.7	3538.6	3541.0	22627.0
2020-01-29 20:00:00	ES	Futures	3541.3	3544.0	3537.5	3539.4	21139.0
2020-01-29 21:00:00	ES	Futures	3539.4	3540.2	3526.4	3529.6	39408.0
2020-01-29 22:00:00	ES	Futures	3529.6	3534.8	3524.5	3527.2	21524.0
2020-01-29 23:00:00	ES	Futures	3526.9	3527.8	3524.5	3526.9	12190.0
2020-01-29 00:00:00	NQ	Futures	10573.04	10577.96	10567.55	10568.7	3840.0
2020-01-29 01:00:00	NQ	Futures	10568.7	10571.6	10559.16	10559.16	3621.0
2020-01-29 02:00:00	NQ	Futures	10559.74	10561.76	10550.49	10557.14	4882.0
2020-01-29 03:00:00	NQ	Futures	10557.14	10574.78	10544.7	10565.23	13944.0
2020-01-29 04:00:00	NQ	Futures	10565.52	10573.04	10550.78	10558.01	10015.0
2020-01-29 05:00:00	NQ	Futures	10557.72	10577.67	10557.14	10576.22	6505.0
2020-01-29 06:00:00	NQ	Futures	10576.22	10591.84	10572.75	10584.61	8770.0
2020-01-29 07:00:00	NQ	Futures	10585.19	10591.84	10574.78	10579.11	12943.0
2020-01-29 08:00:00	NQ	Futures	10578.83	10587.5	10567.26	10568.42	12970.0
2020-01-29 09:00:00	NQ	Futures	10568.7	10593.86	10526.77	10532.27	79590.0
2020-01-29 10:00:00	NQ	Futures	10532.27	10543.84	10493.81	10542.97	101674.0
2020-01-29 11:00:00	NQ	Futures	10542.39	10559.16	10535.45	10555.4	50625.0
2020-01-29 12:00:00	NQ	Futures	10555.69	10570.15	10553.38	10560.61	33567.0
2020-01-29 13:00:00	NQ	Futures	10560.61	10577.38	10550.78	10568.7	27960.0
2020-01-29 14:00:00	NQ	Futures	10569.86	10593.0	10553.67	10576.22	47633.0
2020-01-29 15:00:00	NQ	Futures	10576.51	10580.56	10533.14	10537.18	77714.0
2020-01-29 16:00:00	NQ	Futures	10536.9	10565.81	10503.06	10531.4	26185.0
2020-01-29 18:00:00	NQ	Futures	10538.92	10568.13	10533.71	10550.78	8865.0
2020-01-29 19:00:00	NQ	Futures	10551.35	10557.43	10520.41	10529.09	9567.0
2020-01-29 20:00:00	NQ	Futures	10529.09	10540.65	10516.65	10524.17	9555.0
2020-01-29 21:00:00	NQ	Futures	10523.88	10526.49	10474.15	10487.16	15830.0
2020-01-29 22:00:00	NQ	Futures	10487.16	10503.93	10470.39	10478.48	10627.0
2020-01-29 23:00:00	NQ	Futures	10478.19	10481.66	10467.2	10477.9	7092.0
2020-01-29 00:00:00	YM	Futures	31346.0	31354.7	31329.7	31331.8	1337.0
2020-01-29 01:00:00	YM	Futures	31331.8	31338.4	31311.1	31313.3	1341.0
2020-01-29 02:00:00	YM	Futures	31314.4	31317.7	31290.5	31309.0	2348.0
2020-01-29 03:00:00	YM	Futures	31309.0	31354.7	31273.0	31326.4	6477.0

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

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