PREVIEW / futures_1hour / 2023-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-02.parquet
  size:    68 KB
  rows:    2,061

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
2023-10-02 00:00:00	ES	Futures	4724.03	4725.93	4719.96	4721.04	6236.0
2023-10-02 01:00:00	ES	Futures	4720.77	4721.86	4712.9	4713.71	7535.0
2023-10-02 02:00:00	ES	Futures	4713.71	4725.12	4711.27	4724.84	12138.0
2023-10-02 03:00:00	ES	Futures	4724.57	4731.09	4721.86	4724.84	24543.0
2023-10-02 04:00:00	ES	Futures	4724.84	4729.19	4721.04	4721.31	17843.0
2023-10-02 05:00:00	ES	Futures	4721.31	4721.31	4699.59	4702.03	27504.0
2023-10-02 06:00:00	ES	Futures	4701.76	4702.3	4696.6	4698.77	31788.0
2023-10-02 07:00:00	ES	Futures	4698.77	4701.76	4691.17	4692.53	30573.0
2023-10-02 08:00:00	ES	Futures	4692.53	4693.61	4685.2	4687.37	49511.0
2023-10-02 09:00:00	ES	Futures	4687.37	4702.03	4680.85	4691.17	228197.0
2023-10-02 10:00:00	ES	Futures	4691.17	4705.83	4681.67	4686.83	318825.0
2023-10-02 11:00:00	ES	Futures	4686.83	4711.81	4677.32	4680.85	275995.0
2023-10-02 12:00:00	ES	Futures	4680.85	4683.57	4665.92	4669.72	169158.0
2023-10-02 13:00:00	ES	Futures	4669.45	4682.75	4667.0	4677.05	136037.0
2023-10-02 14:00:00	ES	Futures	4677.32	4691.44	4666.73	4673.25	176965.0
2023-10-02 15:00:00	ES	Futures	4672.98	4698.23	4666.46	4697.69	248664.0
2023-10-02 16:00:00	ES	Futures	4697.69	4702.58	4697.42	4699.05	53966.0
2023-10-02 18:00:00	ES	Futures	4699.05	4702.3	4696.87	4697.96	7665.0
2023-10-02 19:00:00	ES	Futures	4698.23	4701.49	4694.97	4698.5	5513.0
2023-10-02 20:00:00	ES	Futures	4698.5	4698.77	4689.54	4697.42	22236.0
2023-10-02 21:00:00	ES	Futures	4697.69	4700.4	4693.07	4696.33	11305.0
2023-10-02 22:00:00	ES	Futures	4696.6	4698.77	4694.7	4696.06	6112.0
2023-10-02 23:00:00	ES	Futures	4696.06	4699.59	4694.16	4696.06	4794.0
2023-10-02 00:00:00	NQ	Futures	16453.21	16462.55	16438.1	16444.15	3652.0
2023-10-02 01:00:00	NQ	Futures	16443.6	16449.91	16410.64	16414.76	4512.0
2023-10-02 02:00:00	NQ	Futures	16415.31	16456.23	16402.67	16454.31	6045.0
2023-10-02 03:00:00	NQ	Futures	16454.31	16491.39	16446.62	16466.39	12261.0
2023-10-02 04:00:00	NQ	Futures	16466.94	16480.4	16439.75	16442.22	9525.0
2023-10-02 05:00:00	NQ	Futures	16441.67	16442.22	16360.1	16368.89	14276.0
2023-10-02 06:00:00	NQ	Futures	16368.89	16377.4	16346.09	16359.55	12121.0
2023-10-02 07:00:00	NQ	Futures	16359.55	16378.23	16332.63	16340.87	12941.0
2023-10-02 08:00:00	NQ	Futures	16341.15	16344.44	16309.29	16318.35	21814.0
2023-10-02 09:00:00	NQ	Futures	16318.35	16437.0	16288.69	16393.33	95438.0
2023-10-02 10:00:00	NQ	Futures	16393.33	16471.34	16375.48	16405.69	129770.0
2023-10-02 11:00:00	NQ	Futures	16406.24	16530.39	16380.15	16390.59	108645.0
2023-10-02 12:00:00	NQ	Futures	16390.86	16406.79	16348.29	16358.72	65245.0
2023-10-02 13:00:00	NQ	Futures	16359.0	16404.04	16333.46	16379.87	53230.0
2023-10-02 14:00:00	NQ	Futures	16380.42	16433.71	16330.71	16362.57	67104.0
2023-10-02 15:00:00	NQ	Futures	16362.3	16468.04	16334.55	16466.67	85806.0
2023-10-02 16:00:00	NQ	Futures	16467.22	16485.62	16465.29	16471.61	18236.0
2023-10-02 18:00:00	NQ	Futures	16468.32	16485.34	16465.02	16468.86	3740.0
2023-10-02 19:00:00	NQ	Futures	16468.86	16482.6	16456.23	16473.26	3964.0
2023-10-02 20:00:00	NQ	Futures	16473.26	16474.91	16431.51	16470.24	8520.0
2023-10-02 21:00:00	NQ	Futures	16469.69	16477.1	16449.09	16458.43	6396.0
2023-10-02 22:00:00	NQ	Futures	16458.98	16469.41	16450.74	16458.7	3708.0
2023-10-02 23:00:00	NQ	Futures	16458.7	16475.18	16450.46	16462.27	2953.0
2023-10-02 00:00:00	YM	Futures	36769.1	36774.5	36735.4	36740.9	1266.0
2023-10-02 01:00:00	YM	Futures	36742.0	36750.6	36692.1	36696.4	1449.0
2023-10-02 02:00:00	YM	Futures	36696.4	36777.8	36681.2	36771.2	2444.0
2023-10-02 03:00:00	YM	Futures	36771.2	36816.8	36746.3	36771.2	4738.0

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

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