PREVIEW / futures_1hour / 2020-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-25.parquet
  size:    52 KB
  rows:    1,523

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-09-25 00:00:00	ES	Futures	3643.47	3649.63	3641.79	3648.23	4626.0
2020-09-25 01:00:00	ES	Futures	3648.23	3650.19	3638.71	3639.55	6875.0
2020-09-25 02:00:00	ES	Futures	3639.83	3641.23	3632.27	3640.39	11619.0
2020-09-25 03:00:00	ES	Futures	3640.39	3640.67	3624.7	3626.94	23522.0
2020-09-25 04:00:00	ES	Futures	3627.22	3631.43	3621.62	3630.3	23136.0
2020-09-25 05:00:00	ES	Futures	3630.02	3633.39	3613.5	3620.22	34611.0
2020-09-25 06:00:00	ES	Futures	3619.94	3622.18	3596.97	3598.93	42489.0
2020-09-25 07:00:00	ES	Futures	3599.21	3616.58	3592.49	3614.9	48012.0
2020-09-25 08:00:00	ES	Futures	3614.62	3620.78	3610.14	3619.38	46390.0
2020-09-25 09:00:00	ES	Futures	3619.38	3626.66	3609.3	3624.7	206705.0
2020-09-25 10:00:00	ES	Futures	3624.7	3644.59	3603.14	3638.99	288660.0
2020-09-25 11:00:00	ES	Futures	3639.27	3650.75	3632.27	3633.67	154689.0
2020-09-25 12:00:00	ES	Futures	3633.67	3650.47	3633.39	3649.07	90650.0
2020-09-25 13:00:00	ES	Futures	3649.35	3665.04	3645.99	3663.36	134946.0
2020-09-25 14:00:00	ES	Futures	3663.08	3676.8	3662.24	3676.24	136889.0
2020-09-25 15:00:00	ES	Futures	3676.24	3693.05	3675.12	3683.24	281560.0
2020-09-25 16:00:00	ES	Futures	3682.96	3686.04	3678.76	3681.0	57518.0
2020-09-25 00:00:00	NQ	Futures	12659.62	12683.94	12653.55	12678.73	2960.0
2020-09-25 01:00:00	NQ	Futures	12677.57	12687.7	12633.28	12639.94	5215.0
2020-09-25 02:00:00	NQ	Futures	12640.23	12648.33	12596.23	12639.07	7753.0
2020-09-25 03:00:00	NQ	Futures	12638.78	12646.02	12580.02	12595.07	10345.0
2020-09-25 04:00:00	NQ	Futures	12594.78	12624.31	12570.18	12617.07	7846.0
2020-09-25 05:00:00	NQ	Futures	12617.94	12629.52	12556.28	12583.49	8326.0
2020-09-25 06:00:00	NQ	Futures	12583.2	12604.05	12523.28	12535.44	12374.0
2020-09-25 07:00:00	NQ	Futures	12536.6	12625.18	12520.97	12608.39	15195.0
2020-09-25 08:00:00	NQ	Futures	12609.84	12645.73	12593.05	12635.89	22477.0
2020-09-25 09:00:00	NQ	Futures	12635.02	12659.91	12540.36	12625.47	83905.0
2020-09-25 10:00:00	NQ	Futures	12625.18	12722.44	12543.55	12697.54	97188.0
2020-09-25 11:00:00	NQ	Futures	12698.41	12774.54	12674.1	12697.54	63130.0
2020-09-25 12:00:00	NQ	Futures	12698.12	12776.28	12696.68	12754.86	45723.0
2020-09-25 13:00:00	NQ	Futures	12755.15	12814.2	12741.54	12810.15	44682.0
2020-09-25 14:00:00	NQ	Futures	12809.86	12867.75	12804.65	12860.8	45139.0
2020-09-25 15:00:00	NQ	Futures	12860.8	12929.12	12855.3	12890.91	74363.0
2020-09-25 16:00:00	NQ	Futures	12890.91	12905.38	12881.36	12892.94	11348.0
2020-09-25 00:00:00	YM	Futures	29663.8	29716.8	29652.7	29709.1	1101.0
2020-09-25 01:00:00	YM	Futures	29706.9	29721.3	29638.3	29647.2	2307.0
2020-09-25 02:00:00	YM	Futures	29647.2	29664.9	29590.8	29659.3	3234.0
2020-09-25 03:00:00	YM	Futures	29654.9	29660.5	29526.7	29546.6	6431.0
2020-09-25 04:00:00	YM	Futures	29547.7	29582.0	29501.2	29569.8	4157.0
2020-09-25 05:00:00	YM	Futures	29567.6	29593.0	29421.6	29473.6	5362.0
2020-09-25 06:00:00	YM	Futures	29471.4	29484.7	29259.1	29279.0	7017.0
2020-09-25 07:00:00	YM	Futures	29280.1	29409.5	29214.9	29394.0	8484.0
2020-09-25 08:00:00	YM	Futures	29392.9	29441.5	29352.0	29428.3	7787.0
2020-09-25 09:00:00	YM	Futures	29428.3	29511.2	29349.8	29483.6	25954.0
2020-09-25 10:00:00	YM	Futures	29483.6	29639.4	29301.1	29580.8	32320.0
2020-09-25 11:00:00	YM	Futures	29583.1	29654.9	29511.2	29513.4	18470.0
2020-09-25 12:00:00	YM	Futures	29514.5	29641.7	29512.3	29627.3	13952.0
2020-09-25 13:00:00	YM	Futures	29627.3	29745.6	29604.1	29731.2	16048.0
2020-09-25 14:00:00	YM	Futures	29730.1	29848.4	29724.6	29845.1	16365.0
2020-09-25 15:00:00	YM	Futures	29845.1	29987.7	29837.4	29903.7	27257.0

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

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