PREVIEW / futures_1hour / 2023-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-15.parquet
  size:    68 KB
  rows:    2,069

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-06-15 00:00:00	ES	Futures	4851.44	4853.36	4850.89	4851.71	4480.0
2023-06-15 01:00:00	ES	Futures	4851.71	4854.73	4849.24	4851.99	8381.0
2023-06-15 02:00:00	ES	Futures	4851.71	4852.26	4844.03	4846.77	10830.0
2023-06-15 03:00:00	ES	Futures	4847.05	4849.24	4840.19	4848.69	20568.0
2023-06-15 04:00:00	ES	Futures	4848.69	4850.34	4839.91	4841.01	14425.0
2023-06-15 05:00:00	ES	Futures	4841.01	4842.93	4836.34	4838.54	16319.0
2023-06-15 06:00:00	ES	Futures	4838.54	4840.19	4830.85	4832.77	17637.0
2023-06-15 07:00:00	ES	Futures	4832.5	4836.07	4830.03	4834.69	18642.0
2023-06-15 08:00:00	ES	Futures	4834.69	4838.54	4824.54	4836.62	57780.0
2023-06-15 09:00:00	ES	Futures	4836.89	4869.01	4834.97	4867.36	241756.0
2023-06-15 10:00:00	ES	Futures	4867.36	4879.99	4863.52	4875.05	252358.0
2023-06-15 11:00:00	ES	Futures	4875.32	4894.54	4872.85	4889.87	211173.0
2023-06-15 12:00:00	ES	Futures	4889.87	4895.09	4886.03	4891.24	95925.0
2023-06-15 13:00:00	ES	Futures	4891.52	4903.32	4883.01	4901.13	109383.0
2023-06-15 14:00:00	ES	Futures	4901.4	4925.28	4895.91	4922.26	160845.0
2023-06-15 15:00:00	ES	Futures	4922.54	4925.01	4904.7	4911.28	362371.0
2023-06-15 16:00:00	ES	Futures	4911.28	4911.28	4903.05	4905.52	76389.0
2023-06-15 18:00:00	ES	Futures	4907.17	4908.26	4902.22	4903.05	8021.0
2023-06-15 19:00:00	ES	Futures	4903.05	4904.7	4901.95	4903.05	3811.0
2023-06-15 20:00:00	ES	Futures	4903.05	4903.6	4898.93	4900.3	8125.0
2023-06-15 21:00:00	ES	Futures	4900.3	4902.5	4897.83	4898.66	5420.0
2023-06-15 22:00:00	ES	Futures	4898.66	4900.58	4897.01	4898.93	5144.0
2023-06-15 23:00:00	ES	Futures	4898.93	4903.32	4897.56	4903.05	4975.0
2023-06-15 00:00:00	NQ	Futures	16905.92	16915.66	16900.08	16902.86	2772.0
2023-06-15 01:00:00	NQ	Futures	16903.14	16918.44	16892.57	16897.3	3196.0
2023-06-15 02:00:00	NQ	Futures	16897.02	16899.8	16862.53	16878.39	5566.0
2023-06-15 03:00:00	NQ	Futures	16879.22	16903.98	16848.07	16895.63	7687.0
2023-06-15 04:00:00	NQ	Futures	16896.74	16902.03	16823.32	16826.66	8027.0
2023-06-15 05:00:00	NQ	Futures	16825.82	16840.56	16792.45	16807.74	9860.0
2023-06-15 06:00:00	NQ	Futures	16808.86	16813.31	16779.65	16795.23	8025.0
2023-06-15 07:00:00	NQ	Futures	16795.51	16809.13	16778.82	16795.51	9328.0
2023-06-15 08:00:00	NQ	Futures	16796.06	16832.77	16761.3	16824.43	28129.0
2023-06-15 09:00:00	NQ	Futures	16824.15	16935.68	16813.31	16912.04	107518.0
2023-06-15 10:00:00	NQ	Futures	16911.76	17001.6	16893.13	16971.84	105510.0
2023-06-15 11:00:00	NQ	Futures	16971.56	17048.88	16954.6	17028.3	78370.0
2023-06-15 12:00:00	NQ	Futures	17028.86	17043.32	16993.81	17020.79	41632.0
2023-06-15 13:00:00	NQ	Futures	17021.07	17088.38	16979.35	17079.48	53621.0
2023-06-15 14:00:00	NQ	Futures	17079.48	17178.49	17046.66	17164.31	71317.0
2023-06-15 15:00:00	NQ	Futures	17164.59	17174.04	17086.71	17107.85	100475.0
2023-06-15 16:00:00	NQ	Futures	17107.85	17117.86	17078.36	17097.0	19837.0
2023-06-15 18:00:00	NQ	Futures	17097.28	17105.07	17079.2	17084.21	4139.0
2023-06-15 19:00:00	NQ	Futures	17083.93	17091.16	17079.76	17087.54	2016.0
2023-06-15 20:00:00	NQ	Futures	17087.82	17088.66	17050.83	17058.62	5025.0
2023-06-15 21:00:00	NQ	Futures	17058.62	17068.35	17044.43	17046.94	4326.0
2023-06-15 22:00:00	NQ	Futures	17046.66	17064.46	17038.31	17057.5	3969.0
2023-06-15 23:00:00	NQ	Futures	17057.78	17073.64	17052.5	17073.08	3030.0
2023-06-15 00:00:00	YM	Futures	37542.1	37556.4	37541.0	37550.9	751.0
2023-06-15 01:00:00	YM	Futures	37550.9	37561.9	37537.8	37556.4	1026.0
2023-06-15 02:00:00	YM	Futures	37556.4	37559.7	37508.2	37516.9	2098.0
2023-06-15 03:00:00	YM	Futures	37516.9	37521.3	37475.3	37520.2	3455.0

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

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