PREVIEW / futures_1hour / 2020-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-25.parquet
  size:    59 KB
  rows:    1,835

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-08-25 00:00:00	ES	Futures	3846.02	3847.14	3843.79	3845.18	4060.0
2020-08-25 01:00:00	ES	Futures	3845.18	3846.02	3843.23	3843.51	5233.0
2020-08-25 02:00:00	ES	Futures	3843.79	3849.09	3843.79	3845.46	10768.0
2020-08-25 03:00:00	ES	Futures	3845.46	3852.16	3845.18	3848.53	26384.0
2020-08-25 04:00:00	ES	Futures	3848.25	3848.53	3840.16	3841.55	23813.0
2020-08-25 05:00:00	ES	Futures	3841.83	3843.23	3838.48	3842.39	11912.0
2020-08-25 06:00:00	ES	Futures	3842.39	3845.18	3840.72	3844.35	12349.0
2020-08-25 07:00:00	ES	Futures	3844.35	3846.3	3841.27	3844.9	17371.0
2020-08-25 08:00:00	ES	Futures	3845.18	3848.53	3840.44	3842.39	24278.0
2020-08-25 09:00:00	ES	Futures	3842.39	3844.07	3828.99	3834.29	183956.0
2020-08-25 10:00:00	ES	Futures	3834.29	3834.57	3822.01	3827.59	231862.0
2020-08-25 11:00:00	ES	Futures	3827.59	3835.97	3822.84	3827.03	133607.0
2020-08-25 12:00:00	ES	Futures	3827.03	3832.06	3822.84	3830.94	76020.0
2020-08-25 13:00:00	ES	Futures	3830.94	3834.85	3828.15	3832.34	53487.0
2020-08-25 14:00:00	ES	Futures	3832.34	3839.32	3830.38	3838.48	84151.0
2020-08-25 15:00:00	ES	Futures	3838.76	3844.07	3836.25	3842.67	123241.0
2020-08-25 16:00:00	ES	Futures	3842.67	3848.25	3842.67	3847.42	38026.0
2020-08-25 18:00:00	ES	Futures	3847.7	3848.53	3846.02	3846.86	3789.0
2020-08-25 19:00:00	ES	Futures	3846.86	3850.21	3846.3	3847.98	4016.0
2020-08-25 20:00:00	ES	Futures	3847.98	3851.33	3845.18	3846.02	7892.0
2020-08-25 21:00:00	ES	Futures	3845.74	3846.3	3841.55	3844.07	9131.0
2020-08-25 22:00:00	ES	Futures	3843.79	3846.02	3843.23	3844.62	4365.0
2020-08-25 23:00:00	ES	Futures	3844.35	3845.74	3842.39	3845.46	3812.0
2020-08-25 00:00:00	NQ	Futures	13506.08	13508.11	13497.99	13507.24	2089.0
2020-08-25 01:00:00	NQ	Futures	13507.24	13508.11	13495.38	13498.56	2283.0
2020-08-25 02:00:00	NQ	Futures	13499.43	13515.63	13499.43	13508.11	4577.0
2020-08-25 03:00:00	NQ	Futures	13508.4	13519.39	13503.19	13511.29	8981.0
2020-08-25 04:00:00	NQ	Futures	13511.0	13511.29	13477.45	13488.73	8388.0
2020-08-25 05:00:00	NQ	Futures	13488.73	13493.36	13477.17	13478.9	3690.0
2020-08-25 06:00:00	NQ	Futures	13479.19	13489.31	13467.33	13475.43	5130.0
2020-08-25 07:00:00	NQ	Futures	13475.72	13482.95	13433.5	13440.44	11444.0
2020-08-25 08:00:00	NQ	Futures	13440.44	13456.34	13426.85	13445.93	12698.0
2020-08-25 09:00:00	NQ	Futures	13445.93	13455.19	13388.68	13441.6	86193.0
2020-08-25 10:00:00	NQ	Futures	13441.89	13474.85	13403.43	13468.49	87805.0
2020-08-25 11:00:00	NQ	Futures	13468.49	13523.72	13456.63	13483.82	68543.0
2020-08-25 12:00:00	NQ	Futures	13484.11	13500.01	13446.22	13490.18	36386.0
2020-08-25 13:00:00	NQ	Futures	13489.89	13511.87	13476.01	13493.36	30047.0
2020-08-25 14:00:00	NQ	Futures	13493.36	13533.56	13484.4	13530.66	42334.0
2020-08-25 15:00:00	NQ	Futures	13530.66	13556.69	13521.99	13551.2	44226.0
2020-08-25 16:00:00	NQ	Futures	13552.06	13582.43	13548.3	13575.78	10058.0
2020-08-25 18:00:00	NQ	Futures	13579.25	13579.53	13568.26	13572.02	1844.0
2020-08-25 19:00:00	NQ	Futures	13572.02	13596.02	13570.57	13587.92	2953.0
2020-08-25 20:00:00	NQ	Futures	13587.92	13600.64	13579.53	13580.69	4032.0
2020-08-25 21:00:00	NQ	Futures	13580.11	13591.68	13567.68	13584.45	4393.0
2020-08-25 22:00:00	NQ	Futures	13584.45	13588.5	13576.35	13580.69	2825.0
2020-08-25 23:00:00	NQ	Futures	13580.98	13583.58	13570.28	13581.85	2328.0
2020-08-25 00:00:00	YM	Futures	31268.0	31277.9	31249.3	31259.2	1282.0
2020-08-25 01:00:00	YM	Futures	31259.2	31270.2	31247.0	31251.5	977.0
2020-08-25 02:00:00	YM	Futures	31252.6	31313.1	31252.6	31277.9	3196.0
2020-08-25 03:00:00	YM	Futures	31280.1	31360.5	31275.7	31317.5	5872.0

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

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