PREVIEW / futures_1hour / 2020-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-22.parquet
  size:    60 KB
  rows:    1,872

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-22 00:00:00	ES	Futures	3665.88	3668.68	3661.96	3668.12	5555.0
2020-09-22 01:00:00	ES	Futures	3668.12	3668.68	3652.15	3653.83	11378.0
2020-09-22 02:00:00	ES	Futures	3654.11	3663.08	3652.15	3658.31	19310.0
2020-09-22 03:00:00	ES	Futures	3658.31	3661.4	3648.51	3660.27	30951.0
2020-09-22 04:00:00	ES	Futures	3660.27	3670.64	3658.03	3663.36	24238.0
2020-09-22 05:00:00	ES	Futures	3663.36	3675.96	3661.68	3672.04	20757.0
2020-09-22 06:00:00	ES	Futures	3671.76	3678.2	3668.96	3673.72	17056.0
2020-09-22 07:00:00	ES	Futures	3673.72	3682.12	3660.56	3665.04	37348.0
2020-09-22 08:00:00	ES	Futures	3664.48	3676.8	3662.52	3672.32	43614.0
2020-09-22 09:00:00	ES	Futures	3672.6	3688.0	3663.92	3669.24	210900.0
2020-09-22 10:00:00	ES	Futures	3668.96	3686.04	3655.79	3656.35	272214.0
2020-09-22 11:00:00	ES	Futures	3656.63	3672.04	3651.03	3670.92	183307.0
2020-09-22 12:00:00	ES	Futures	3670.64	3678.48	3662.8	3667.28	99926.0
2020-09-22 13:00:00	ES	Futures	3667.0	3687.72	3665.6	3687.44	92669.0
2020-09-22 14:00:00	ES	Futures	3687.16	3696.13	3686.88	3688.56	133616.0
2020-09-22 15:00:00	ES	Futures	3688.56	3707.89	3685.48	3701.45	216924.0
2020-09-22 16:00:00	ES	Futures	3701.45	3701.73	3693.05	3698.09	51120.0
2020-09-22 18:00:00	ES	Futures	3701.45	3701.73	3690.81	3691.37	9671.0
2020-09-22 19:00:00	ES	Futures	3691.37	3700.61	3689.96	3700.05	10804.0
2020-09-22 20:00:00	ES	Futures	3700.33	3703.69	3690.53	3690.81	15631.0
2020-09-22 21:00:00	ES	Futures	3691.09	3699.21	3687.72	3698.37	13159.0
2020-09-22 22:00:00	ES	Futures	3698.37	3700.61	3690.53	3692.21	9601.0
2020-09-22 23:00:00	ES	Futures	3692.49	3699.21	3689.68	3695.85	7272.0
2020-09-22 00:00:00	NQ	Futures	12696.68	12710.57	12676.99	12706.81	3903.0
2020-09-22 01:00:00	NQ	Futures	12707.97	12708.25	12640.81	12649.2	5362.0
2020-09-22 02:00:00	NQ	Futures	12650.65	12682.78	12632.41	12662.52	7883.0
2020-09-22 03:00:00	NQ	Futures	12661.65	12695.81	12617.94	12686.83	10878.0
2020-09-22 04:00:00	NQ	Futures	12686.54	12757.46	12681.62	12738.65	12174.0
2020-09-22 05:00:00	NQ	Futures	12739.81	12814.49	12729.68	12793.36	9130.0
2020-09-22 06:00:00	NQ	Futures	12791.04	12833.02	12772.52	12794.52	7706.0
2020-09-22 07:00:00	NQ	Futures	12792.78	12814.2	12726.2	12737.49	12475.0
2020-09-22 08:00:00	NQ	Futures	12736.62	12806.1	12729.68	12789.89	18417.0
2020-09-22 09:00:00	NQ	Futures	12790.17	12823.17	12679.31	12743.57	74715.0
2020-09-22 10:00:00	NQ	Futures	12743.57	12797.41	12670.91	12674.39	88208.0
2020-09-22 11:00:00	NQ	Futures	12674.1	12760.07	12645.73	12756.02	68901.0
2020-09-22 12:00:00	NQ	Futures	12755.44	12807.25	12739.52	12759.78	47120.0
2020-09-22 13:00:00	NQ	Futures	12759.49	12857.33	12752.25	12857.04	42725.0
2020-09-22 14:00:00	NQ	Futures	12857.33	12900.17	12844.02	12860.52	52729.0
2020-09-22 15:00:00	NQ	Futures	12860.52	12957.78	12845.46	12927.38	60545.0
2020-09-22 16:00:00	NQ	Futures	12927.38	12936.65	12898.73	12914.36	10793.0
2020-09-22 18:00:00	NQ	Futures	12922.46	12931.15	12865.15	12868.62	4948.0
2020-09-22 19:00:00	NQ	Futures	12867.75	12878.75	12846.04	12876.73	5409.0
2020-09-22 20:00:00	NQ	Futures	12875.86	12883.38	12830.99	12831.28	6822.0
2020-09-22 21:00:00	NQ	Futures	12833.02	12874.12	12824.62	12869.78	6088.0
2020-09-22 22:00:00	NQ	Futures	12868.62	12876.73	12839.96	12848.94	4057.0
2020-09-22 23:00:00	NQ	Futures	12850.09	12875.28	12832.73	12860.23	3608.0
2020-09-22 00:00:00	YM	Futures	29879.4	29898.2	29852.8	29894.8	1323.0
2020-09-22 01:00:00	YM	Futures	29895.9	29898.2	29781.0	29792.0	3014.0
2020-09-22 02:00:00	YM	Futures	29794.2	29870.5	29776.5	29820.8	4855.0
2020-09-22 03:00:00	YM	Futures	29818.6	29849.5	29741.2	29837.4	8273.0

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

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