PREVIEW / futures_30min / 2023-07-07

all futures 30-min files

  file:    by_date/futures_30min/2023/2023-07-07.parquet
  size:    93 KB
  rows:    3,136

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	4879.44	2447.0
2023-07-07 00:30:00	ES	Futures	4879.44	4880.26	4878.89	4878.89	1733.0
2023-07-07 01:00:00	ES	Futures	4879.17	4882.46	4878.34	4881.09	3674.0
2023-07-07 01:30:00	ES	Futures	4880.81	4881.09	4877.52	4878.07	3418.0
2023-07-07 02:00:00	ES	Futures	4878.07	4880.26	4876.97	4878.07	5541.0
2023-07-07 02:30:00	ES	Futures	4878.07	4878.34	4874.77	4875.05	4847.0
2023-07-07 03:00:00	ES	Futures	4875.05	4875.87	4870.66	4871.48	17174.0
2023-07-07 03:30:00	ES	Futures	4871.2	4875.32	4869.01	4873.95	16575.0
2023-07-07 04:00:00	ES	Futures	4873.95	4875.87	4869.83	4875.6	13218.0
2023-07-07 04:30:00	ES	Futures	4875.6	4878.62	4873.13	4876.97	9835.0
2023-07-07 05:00:00	ES	Futures	4876.97	4881.91	4876.42	4880.26	9427.0
2023-07-07 05:30:00	ES	Futures	4880.26	4880.81	4878.34	4879.44	6481.0
2023-07-07 06:00:00	ES	Futures	4879.17	4879.99	4875.87	4878.89	6629.0
2023-07-07 06:30:00	ES	Futures	4878.89	4880.26	4878.34	4879.99	3892.0
2023-07-07 07:00:00	ES	Futures	4879.71	4881.36	4878.07	4878.62	5111.0
2023-07-07 07:30:00	ES	Futures	4878.62	4881.36	4877.52	4877.79	6848.0
2023-07-07 08:00:00	ES	Futures	4877.79	4880.81	4876.42	4880.81	12969.0
2023-07-07 08:30:00	ES	Futures	4880.26	4890.7	4869.83	4874.5	120097.0
2023-07-07 09:00:00	ES	Futures	4874.22	4876.97	4865.99	4869.56	61976.0
2023-07-07 09:30:00	ES	Futures	4869.56	4887.13	4868.19	4886.85	196210.0
2023-07-07 10:00:00	ES	Futures	4886.58	4887.68	4876.97	4879.17	103119.0
2023-07-07 10:30:00	ES	Futures	4879.17	4884.38	4871.75	4883.56	89857.0
2023-07-07 11:00:00	ES	Futures	4883.56	4886.58	4881.36	4884.38	56007.0
2023-07-07 11:30:00	ES	Futures	4884.66	4889.6	4883.83	4889.32	56523.0
2023-07-07 12:00:00	ES	Futures	4889.32	4897.28	4889.05	4897.01	67553.0
2023-07-07 12:30:00	ES	Futures	4897.01	4911.01	4897.01	4910.46	97534.0
2023-07-07 13:00:00	ES	Futures	4910.73	4914.85	4910.19	4914.3	66443.0
2023-07-07 13:30:00	ES	Futures	4914.58	4914.85	4901.95	4905.24	72258.0
2023-07-07 14:00:00	ES	Futures	4905.24	4906.34	4902.22	4904.97	42479.0
2023-07-07 14:30:00	ES	Futures	4905.24	4906.07	4897.28	4898.38	51398.0
2023-07-07 15:00:00	ES	Futures	4898.66	4899.48	4887.68	4888.5	80969.0
2023-07-07 15:30:00	ES	Futures	4888.5	4891.52	4866.26	4869.56	221488.0
2023-07-07 16:00:00	ES	Futures	4869.56	4875.6	4868.46	4873.95	59940.0
2023-07-07 16:30:00	ES	Futures	4873.95	4874.22	4870.66	4873.13	6876.0
2023-07-07 00:00:00	NQ	Futures	16947.36	16947.92	16935.13	16939.02	822.0
2023-07-07 00:30:00	NQ	Futures	16939.02	16942.64	16935.41	16936.52	746.0
2023-07-07 01:00:00	NQ	Futures	16936.8	16952.93	16932.9	16943.47	1851.0
2023-07-07 01:30:00	NQ	Futures	16943.19	16944.31	16930.4	16932.07	1592.0
2023-07-07 02:00:00	NQ	Futures	16931.79	16939.02	16925.39	16931.23	2471.0
2023-07-07 02:30:00	NQ	Futures	16931.51	16931.51	16915.38	16916.77	2458.0
2023-07-07 03:00:00	NQ	Futures	16916.77	16920.11	16894.8	16899.53	6415.0
2023-07-07 03:30:00	NQ	Futures	16899.25	16912.04	16884.23	16904.81	4119.0
2023-07-07 04:00:00	NQ	Futures	16905.37	16916.77	16889.51	16914.82	3554.0
2023-07-07 04:30:00	NQ	Futures	16914.55	16927.62	16906.2	16924.28	2998.0
2023-07-07 05:00:00	NQ	Futures	16924.84	16941.8	16921.5	16932.07	3546.0
2023-07-07 05:30:00	NQ	Futures	16931.79	16934.85	16925.95	16927.34	2381.0
2023-07-07 06:00:00	NQ	Futures	16927.06	16927.62	16907.87	16916.77	3329.0
2023-07-07 06:30:00	NQ	Futures	16917.05	16925.67	16911.21	16922.61	1934.0
2023-07-07 07:00:00	NQ	Futures	16922.61	16931.51	16920.94	16925.11	2786.0
2023-07-07 07:30:00	NQ	Futures	16925.11	16931.23	16914.27	16914.82	3095.0

> showing 50 of 3,136 rows — these rows as CSV

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