PREVIEW / futures_1hour / 2021-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-24.parquet
  size:    61 KB
  rows:    1,934

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
2021-05-24 00:00:00	ES	Futures	4678.98	4679.54	4674.49	4677.02	3834.0
2021-05-24 01:00:00	ES	Futures	4676.73	4680.67	4675.89	4677.3	4987.0
2021-05-24 02:00:00	ES	Futures	4677.3	4681.51	4676.45	4680.11	4176.0
2021-05-24 03:00:00	ES	Futures	4680.11	4691.06	4679.54	4689.66	16873.0
2021-05-24 04:00:00	ES	Futures	4689.66	4689.66	4681.51	4683.48	9208.0
2021-05-24 05:00:00	ES	Futures	4683.48	4690.5	4682.63	4690.5	8695.0
2021-05-24 06:00:00	ES	Futures	4690.5	4690.78	4687.13	4688.82	5140.0
2021-05-24 07:00:00	ES	Futures	4688.54	4689.1	4684.6	4687.69	8606.0
2021-05-24 08:00:00	ES	Futures	4687.69	4693.31	4687.13	4691.91	17121.0
2021-05-24 09:00:00	ES	Futures	4691.91	4703.43	4690.5	4703.15	147014.0
2021-05-24 10:00:00	ES	Futures	4703.15	4718.32	4703.15	4716.07	179805.0
2021-05-24 11:00:00	ES	Futures	4716.07	4720.28	4713.54	4714.95	82129.0
2021-05-24 12:00:00	ES	Futures	4715.23	4717.47	4711.29	4715.79	61400.0
2021-05-24 13:00:00	ES	Futures	4716.07	4721.97	4714.1	4721.13	68958.0
2021-05-24 14:00:00	ES	Futures	4720.85	4727.31	4720.85	4724.5	76951.0
2021-05-24 15:00:00	ES	Futures	4724.5	4727.03	4711.57	4714.1	198704.0
2021-05-24 16:00:00	ES	Futures	4714.38	4719.72	4713.26	4719.44	53018.0
2021-05-24 18:00:00	ES	Futures	4719.44	4723.38	4716.91	4723.09	6351.0
2021-05-24 19:00:00	ES	Futures	4723.09	4724.78	4720.28	4721.41	5123.0
2021-05-24 20:00:00	ES	Futures	4721.69	4722.81	4714.95	4721.41	11913.0
2021-05-24 21:00:00	ES	Futures	4721.69	4725.34	4717.76	4720.57	12834.0
2021-05-24 22:00:00	ES	Futures	4720.28	4722.81	4719.16	4722.53	5298.0
2021-05-24 23:00:00	ES	Futures	4722.53	4724.5	4721.69	4723.09	3858.0
2021-05-24 00:00:00	NQ	Futures	15540.4	15541.26	15512.03	15529.68	2719.0
2021-05-24 01:00:00	NQ	Futures	15529.11	15546.77	15525.63	15534.03	3060.0
2021-05-24 02:00:00	NQ	Futures	15533.74	15558.63	15529.68	15549.66	3036.0
2021-05-24 03:00:00	NQ	Futures	15549.66	15614.22	15546.77	15608.72	9677.0
2021-05-24 04:00:00	NQ	Futures	15609.3	15613.06	15584.98	15590.48	4301.0
2021-05-24 05:00:00	NQ	Futures	15590.48	15630.43	15589.61	15627.53	4093.0
2021-05-24 06:00:00	NQ	Futures	15627.24	15631.3	15613.93	15623.19	2980.0
2021-05-24 07:00:00	NQ	Futures	15623.48	15629.85	15605.82	15628.4	4681.0
2021-05-24 08:00:00	NQ	Futures	15627.24	15654.75	15625.8	15644.33	9424.0
2021-05-24 09:00:00	NQ	Futures	15644.33	15729.15	15625.22	15723.94	60358.0
2021-05-24 10:00:00	NQ	Futures	15724.52	15806.15	15724.23	15791.39	62066.0
2021-05-24 11:00:00	NQ	Futures	15791.68	15817.44	15783.86	15807.31	31556.0
2021-05-24 12:00:00	NQ	Futures	15807.31	15822.65	15782.12	15793.7	26008.0
2021-05-24 13:00:00	NQ	Futures	15793.7	15824.68	15788.49	15814.84	20832.0
2021-05-24 14:00:00	NQ	Futures	15815.42	15848.13	15813.68	15840.02	23520.0
2021-05-24 15:00:00	NQ	Futures	15839.73	15845.81	15784.73	15791.97	52258.0
2021-05-24 16:00:00	NQ	Futures	15792.55	15813.68	15786.18	15805.86	10101.0
2021-05-24 18:00:00	NQ	Futures	15813.97	15824.39	15790.52	15823.81	2613.0
2021-05-24 19:00:00	NQ	Futures	15824.1	15829.31	15807.6	15814.26	2432.0
2021-05-24 20:00:00	NQ	Futures	15813.97	15831.92	15785.6	15819.76	7208.0
2021-05-24 21:00:00	NQ	Futures	15820.63	15834.23	15798.92	15812.81	4692.0
2021-05-24 22:00:00	NQ	Futures	15813.39	15829.6	15807.89	15824.97	2620.0
2021-05-24 23:00:00	NQ	Futures	15825.84	15839.44	15823.52	15829.02	3209.0
2021-05-24 00:00:00	YM	Futures	38192.8	38196.2	38150.5	38169.4	1059.0
2021-05-24 01:00:00	YM	Futures	38165.0	38193.9	38159.4	38169.4	852.0
2021-05-24 02:00:00	YM	Futures	38169.4	38192.8	38162.8	38183.9	1032.0
2021-05-24 03:00:00	YM	Futures	38185.0	38247.4	38173.9	38217.3	3744.0

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

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