PREVIEW / futures_1hour / 2023-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-07.parquet
  size:    57 KB
  rows:    1,652

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-07-07 00:00:00	ES	Futures	4881.36	4881.64	4878.34	4878.89	4180.0
2023-07-07 01:00:00	ES	Futures	4879.17	4882.46	4877.52	4878.07	7092.0
2023-07-07 02:00:00	ES	Futures	4878.07	4880.26	4874.77	4875.05	10388.0
2023-07-07 03:00:00	ES	Futures	4875.05	4875.87	4869.01	4873.95	33749.0
2023-07-07 04:00:00	ES	Futures	4873.95	4878.62	4869.83	4876.97	23053.0
2023-07-07 05:00:00	ES	Futures	4876.97	4881.91	4876.42	4879.44	15908.0
2023-07-07 06:00:00	ES	Futures	4879.17	4880.26	4875.87	4879.99	10521.0
2023-07-07 07:00:00	ES	Futures	4879.71	4881.36	4877.52	4877.79	11959.0
2023-07-07 08:00:00	ES	Futures	4877.79	4890.7	4869.83	4874.5	133066.0
2023-07-07 09:00:00	ES	Futures	4874.22	4887.13	4865.99	4886.85	258186.0
2023-07-07 10:00:00	ES	Futures	4886.58	4887.68	4871.75	4883.56	192976.0
2023-07-07 11:00:00	ES	Futures	4883.56	4889.6	4881.36	4889.32	112530.0
2023-07-07 12:00:00	ES	Futures	4889.32	4911.01	4889.05	4910.46	165087.0
2023-07-07 13:00:00	ES	Futures	4910.73	4914.85	4901.95	4905.24	138701.0
2023-07-07 14:00:00	ES	Futures	4905.24	4906.34	4897.28	4898.38	93877.0
2023-07-07 15:00:00	ES	Futures	4898.66	4899.48	4866.26	4869.56	302457.0
2023-07-07 16:00:00	ES	Futures	4869.56	4875.6	4868.46	4873.13	66816.0
2023-07-07 00:00:00	NQ	Futures	16947.36	16947.92	16935.13	16936.52	1568.0
2023-07-07 01:00:00	NQ	Futures	16936.8	16952.93	16930.4	16932.07	3443.0
2023-07-07 02:00:00	NQ	Futures	16931.79	16939.02	16915.38	16916.77	4929.0
2023-07-07 03:00:00	NQ	Futures	16916.77	16920.11	16884.23	16904.81	10534.0
2023-07-07 04:00:00	NQ	Futures	16905.37	16927.62	16889.51	16924.28	6552.0
2023-07-07 05:00:00	NQ	Futures	16924.84	16941.8	16921.5	16927.34	5927.0
2023-07-07 06:00:00	NQ	Futures	16927.06	16927.62	16907.87	16922.61	5263.0
2023-07-07 07:00:00	NQ	Futures	16922.61	16931.51	16914.27	16914.82	5881.0
2023-07-07 08:00:00	NQ	Futures	16914.55	17037.2	16910.1	16930.4	46499.0
2023-07-07 09:00:00	NQ	Futures	16929.84	16995.76	16892.02	16991.59	87156.0
2023-07-07 10:00:00	NQ	Futures	16991.31	16997.15	16887.57	16952.65	83424.0
2023-07-07 11:00:00	NQ	Futures	16952.93	17001.04	16948.48	16999.65	42687.0
2023-07-07 12:00:00	NQ	Futures	16999.93	17063.9	16999.38	17058.9	52951.0
2023-07-07 13:00:00	NQ	Futures	17059.17	17088.1	17041.09	17054.45	41555.0
2023-07-07 14:00:00	NQ	Futures	17055.0	17057.23	17012.73	17022.46	33148.0
2023-07-07 15:00:00	NQ	Futures	17023.02	17025.24	16879.5	16892.02	81056.0
2023-07-07 16:00:00	NQ	Futures	16891.74	16915.66	16889.24	16902.03	14964.0
2023-07-07 00:00:00	YM	Futures	37392.1	37393.1	37370.1	37381.1	732.0
2023-07-07 01:00:00	YM	Futures	37382.2	37403.0	37372.3	37376.7	1016.0
2023-07-07 02:00:00	YM	Futures	37374.5	37388.8	37346.0	37348.2	1903.0
2023-07-07 03:00:00	YM	Futures	37348.2	37358.1	37303.3	37334.0	4380.0
2023-07-07 04:00:00	YM	Futures	37336.2	37355.9	37304.4	37344.9	2828.0
2023-07-07 05:00:00	YM	Futures	37344.9	37387.7	37342.8	37377.8	2298.0
2023-07-07 06:00:00	YM	Futures	37375.6	37391.0	37355.9	37383.3	1543.0
2023-07-07 07:00:00	YM	Futures	37384.4	37397.5	37371.2	37375.6	1711.0
2023-07-07 08:00:00	YM	Futures	37373.4	37415.1	37275.9	37330.7	12146.0
2023-07-07 09:00:00	YM	Futures	37329.6	37374.5	37211.3	37369.0	26896.0
2023-07-07 10:00:00	YM	Futures	37368.0	37383.3	37293.5	37343.9	12599.0
2023-07-07 11:00:00	YM	Futures	37343.9	37360.3	37306.6	37341.7	8102.0
2023-07-07 12:00:00	YM	Futures	37341.7	37487.4	37338.4	37484.1	13418.0
2023-07-07 13:00:00	YM	Futures	37485.2	37515.9	37429.3	37452.3	10528.0
2023-07-07 14:00:00	YM	Futures	37453.4	37455.6	37371.2	37382.2	6612.0
2023-07-07 15:00:00	YM	Futures	37382.2	37391.0	37158.7	37187.2	21494.0

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

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