PREVIEW / futures_1hour / 2022-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-07.parquet
  size:    67 KB
  rows:    2,027

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
2022-06-07 00:00:00	ES	Futures	4650.12	4651.82	4643.6	4646.44	8398.0
2022-06-07 01:00:00	ES	Futures	4646.44	4647.85	4632.26	4634.81	11953.0
2022-06-07 02:00:00	ES	Futures	4635.1	4649.27	4635.1	4643.32	13427.0
2022-06-07 03:00:00	ES	Futures	4643.03	4658.34	4642.18	4652.95	23804.0
2022-06-07 04:00:00	ES	Futures	4652.95	4660.61	4650.97	4656.36	15106.0
2022-06-07 05:00:00	ES	Futures	4656.64	4658.34	4648.14	4648.99	14797.0
2022-06-07 06:00:00	ES	Futures	4649.27	4652.1	4634.81	4637.37	19999.0
2022-06-07 07:00:00	ES	Futures	4637.65	4643.6	4623.48	4634.81	41526.0
2022-06-07 08:00:00	ES	Futures	4634.81	4637.65	4624.33	4624.89	38630.0
2022-06-07 09:00:00	ES	Futures	4625.18	4656.36	4621.21	4647.0	208449.0
2022-06-07 10:00:00	ES	Futures	4647.0	4691.79	4638.22	4685.27	254913.0
2022-06-07 11:00:00	ES	Futures	4684.98	4688.95	4660.32	4670.53	169424.0
2022-06-07 12:00:00	ES	Futures	4670.53	4680.73	4657.77	4678.75	145605.0
2022-06-07 13:00:00	ES	Futures	4678.75	4691.5	4675.91	4685.83	149919.0
2022-06-07 14:00:00	ES	Futures	4686.12	4706.52	4683.85	4697.17	138452.0
2022-06-07 15:00:00	ES	Futures	4697.45	4720.98	4695.75	4715.03	228900.0
2022-06-07 16:00:00	ES	Futures	4715.03	4715.31	4704.54	4705.96	64880.0
2022-06-07 18:00:00	ES	Futures	4705.96	4711.91	4705.11	4708.23	6747.0
2022-06-07 19:00:00	ES	Futures	4707.94	4710.49	4700.29	4701.71	5992.0
2022-06-07 20:00:00	ES	Futures	4701.42	4711.34	4699.72	4709.08	9269.0
2022-06-07 21:00:00	ES	Futures	4709.08	4714.46	4705.96	4710.21	6641.0
2022-06-07 22:00:00	ES	Futures	4710.21	4713.61	4705.67	4705.96	3854.0
2022-06-07 23:00:00	ES	Futures	4706.24	4707.09	4695.19	4697.74	7855.0
2022-06-07 00:00:00	NQ	Futures	14533.84	14537.03	14505.13	14515.86	3738.0
2022-06-07 01:00:00	NQ	Futures	14515.28	14522.82	14464.54	14471.49	6222.0
2022-06-07 02:00:00	NQ	Futures	14471.49	14521.95	14471.49	14494.4	6859.0
2022-06-07 03:00:00	NQ	Futures	14493.82	14560.52	14490.92	14541.09	11050.0
2022-06-07 04:00:00	NQ	Futures	14541.09	14576.18	14533.55	14559.36	6554.0
2022-06-07 05:00:00	NQ	Futures	14559.07	14564.87	14526.01	14532.39	6996.0
2022-06-07 06:00:00	NQ	Futures	14531.81	14542.54	14475.55	14485.7	9907.0
2022-06-07 07:00:00	NQ	Futures	14485.7	14511.8	14428.58	14462.51	19340.0
2022-06-07 08:00:00	NQ	Futures	14463.38	14471.78	14415.53	14422.78	21074.0
2022-06-07 09:00:00	NQ	Futures	14422.2	14592.7	14397.26	14532.68	86222.0
2022-06-07 10:00:00	NQ	Futures	14532.68	14739.14	14489.18	14696.23	98085.0
2022-06-07 11:00:00	NQ	Futures	14696.23	14708.11	14570.67	14632.72	66304.0
2022-06-07 12:00:00	NQ	Futures	14632.14	14655.05	14572.99	14644.03	42751.0
2022-06-07 13:00:00	NQ	Futures	14644.32	14693.91	14628.37	14668.1	36340.0
2022-06-07 14:00:00	NQ	Futures	14669.84	14735.08	14658.53	14690.72	41021.0
2022-06-07 15:00:00	NQ	Futures	14691.88	14777.42	14685.79	14744.07	61425.0
2022-06-07 16:00:00	NQ	Futures	14743.2	14743.78	14706.08	14709.27	14953.0
2022-06-07 18:00:00	NQ	Futures	14708.11	14733.63	14707.53	14720.29	3533.0
2022-06-07 19:00:00	NQ	Futures	14719.71	14734.5	14691.88	14697.1	3674.0
2022-06-07 20:00:00	NQ	Futures	14697.39	14728.7	14686.95	14717.97	4711.0
2022-06-07 21:00:00	NQ	Futures	14718.84	14740.59	14706.66	14724.06	3944.0
2022-06-07 22:00:00	NQ	Futures	14724.93	14743.78	14712.17	14713.33	2829.0
2022-06-07 23:00:00	NQ	Futures	14712.75	14718.55	14668.68	14681.15	4820.0
2022-06-07 00:00:00	YM	Futures	36942.6	36953.9	36902.0	36923.5	1553.0
2022-06-07 01:00:00	YM	Futures	36925.7	36932.5	36819.7	36843.4	2002.0
2022-06-07 02:00:00	YM	Futures	36844.6	36944.9	36843.4	36906.6	1951.0
2022-06-07 03:00:00	YM	Futures	36905.4	36995.6	36905.4	36949.4	3767.0

> showing 50 of 2,027 rows — these rows as CSV

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