PREVIEW / futures_1hour / 2023-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-30.parquet
  size:    57 KB
  rows:    1,650

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-30 00:00:00	ES	Futures	4872.3	4873.13	4871.2	4872.85	2759.0
2023-06-30 01:00:00	ES	Futures	4872.85	4878.62	4872.85	4876.7	6737.0
2023-06-30 02:00:00	ES	Futures	4876.7	4876.7	4871.48	4871.75	7315.0
2023-06-30 03:00:00	ES	Futures	4871.75	4876.7	4870.66	4875.87	12501.0
2023-06-30 04:00:00	ES	Futures	4875.87	4882.73	4875.6	4881.64	13525.0
2023-06-30 05:00:00	ES	Futures	4881.91	4887.68	4881.36	4885.48	17701.0
2023-06-30 06:00:00	ES	Futures	4885.48	4893.17	4884.93	4889.87	20041.0
2023-06-30 07:00:00	ES	Futures	4889.87	4891.79	4886.03	4887.68	19728.0
2023-06-30 08:00:00	ES	Futures	4887.68	4904.15	4887.68	4901.95	62699.0
2023-06-30 09:00:00	ES	Futures	4902.22	4920.07	4901.95	4916.77	199943.0
2023-06-30 10:00:00	ES	Futures	4916.77	4927.48	4913.21	4920.34	238289.0
2023-06-30 11:00:00	ES	Futures	4920.34	4925.28	4912.66	4917.6	160726.0
2023-06-30 12:00:00	ES	Futures	4917.87	4930.77	4915.68	4929.68	120052.0
2023-06-30 13:00:00	ES	Futures	4929.68	4934.62	4926.93	4933.24	95819.0
2023-06-30 14:00:00	ES	Futures	4933.24	4936.81	4931.05	4934.07	108487.0
2023-06-30 15:00:00	ES	Futures	4934.34	4939.01	4925.28	4926.11	362684.0
2023-06-30 16:00:00	ES	Futures	4926.38	4928.03	4920.07	4921.99	137139.0
2023-06-30 00:00:00	NQ	Futures	16824.43	16831.94	16822.21	16829.72	1217.0
2023-06-30 01:00:00	NQ	Futures	16831.11	16860.59	16831.11	16846.96	3847.0
2023-06-30 02:00:00	NQ	Futures	16846.96	16848.07	16823.32	16828.32	3707.0
2023-06-30 03:00:00	NQ	Futures	16828.05	16850.3	16822.21	16846.4	5480.0
2023-06-30 04:00:00	NQ	Futures	16846.68	16876.16	16845.57	16871.44	5979.0
2023-06-30 05:00:00	NQ	Futures	16871.71	16888.68	16868.1	16877.83	5472.0
2023-06-30 06:00:00	NQ	Futures	16876.72	16893.69	16869.49	16882.56	5575.0
2023-06-30 07:00:00	NQ	Futures	16881.73	16893.13	16871.71	16878.39	5537.0
2023-06-30 08:00:00	NQ	Futures	16879.78	16977.12	16879.78	16949.87	31787.0
2023-06-30 09:00:00	NQ	Futures	16950.15	17055.56	16948.48	17037.2	84579.0
2023-06-30 10:00:00	NQ	Futures	17043.04	17107.01	17034.14	17058.62	88472.0
2023-06-30 11:00:00	NQ	Futures	17058.34	17085.87	17003.83	17035.81	59451.0
2023-06-30 12:00:00	NQ	Futures	17036.09	17087.82	17024.96	17083.65	40976.0
2023-06-30 13:00:00	NQ	Futures	17084.21	17089.77	17063.62	17083.37	32494.0
2023-06-30 14:00:00	NQ	Futures	17083.37	17092.55	17059.45	17073.64	35365.0
2023-06-30 15:00:00	NQ	Futures	17074.19	17098.67	17053.33	17056.11	68399.0
2023-06-30 16:00:00	NQ	Futures	17055.84	17062.79	17029.97	17039.98	20829.0
2023-06-30 00:00:00	YM	Futures	37621.0	37624.3	37612.3	37619.9	471.0
2023-06-30 01:00:00	YM	Futures	37622.1	37655.0	37622.1	37642.9	800.0
2023-06-30 02:00:00	YM	Futures	37642.9	37645.1	37605.7	37605.7	1620.0
2023-06-30 03:00:00	YM	Futures	37606.8	37639.6	37596.9	37635.3	3173.0
2023-06-30 04:00:00	YM	Futures	37636.4	37676.9	37625.4	37670.3	2500.0
2023-06-30 05:00:00	YM	Futures	37670.3	37720.7	37669.2	37709.8	3496.0
2023-06-30 06:00:00	YM	Futures	37708.7	37770.0	37708.7	37751.4	3963.0
2023-06-30 07:00:00	YM	Futures	37750.3	37759.1	37720.7	37733.9	2453.0
2023-06-30 08:00:00	YM	Futures	37735.0	37837.9	37732.8	37820.4	7873.0
2023-06-30 09:00:00	YM	Futures	37820.4	37902.6	37819.3	37853.3	21705.0
2023-06-30 10:00:00	YM	Futures	37852.2	37943.1	37806.2	37869.7	17882.0
2023-06-30 11:00:00	YM	Futures	37869.7	37922.3	37845.6	37870.8	10481.0
2023-06-30 12:00:00	YM	Futures	37870.8	37955.2	37850.0	37946.4	8061.0
2023-06-30 13:00:00	YM	Futures	37946.4	37983.6	37923.4	37972.7	6927.0
2023-06-30 14:00:00	YM	Futures	37972.7	38004.5	37969.4	37995.7	6513.0
2023-06-30 15:00:00	YM	Futures	37996.8	38020.9	37932.2	37936.5	18044.0

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

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