PREVIEW / futures_30min / 2023-06-19

all futures 30-min files

  file:    by_date/futures_30min/2023/2023-06-19.parquet
  size:    82 KB
  rows:    3,026

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-19 00:00:00	ES	Futures	4885.48	4886.03	4883.56	4884.66	2240.0
2023-06-19 00:30:00	ES	Futures	4884.66	4885.75	4883.01	4883.83	1383.0
2023-06-19 01:00:00	ES	Futures	4883.83	4886.3	4883.01	4886.03	1961.0
2023-06-19 01:30:00	ES	Futures	4886.3	4890.15	4886.3	4889.87	2527.0
2023-06-19 02:00:00	ES	Futures	4889.87	4891.24	4888.5	4888.77	2614.0
2023-06-19 02:30:00	ES	Futures	4889.05	4890.97	4888.22	4889.32	2237.0
2023-06-19 03:00:00	ES	Futures	4889.6	4895.09	4887.13	4893.99	7544.0
2023-06-19 03:30:00	ES	Futures	4893.99	4898.11	4890.15	4890.42	10331.0
2023-06-19 04:00:00	ES	Futures	4890.42	4892.62	4887.68	4888.77	4789.0
2023-06-19 04:30:00	ES	Futures	4888.77	4890.15	4886.3	4888.77	4317.0
2023-06-19 05:00:00	ES	Futures	4888.5	4890.42	4886.85	4890.15	5530.0
2023-06-19 05:30:00	ES	Futures	4890.15	4892.62	4888.77	4891.52	2719.0
2023-06-19 06:00:00	ES	Futures	4891.52	4892.07	4888.22	4889.87	2937.0
2023-06-19 06:30:00	ES	Futures	4889.6	4890.97	4885.75	4887.13	3134.0
2023-06-19 07:00:00	ES	Futures	4886.85	4888.5	4885.2	4888.22	3003.0
2023-06-19 07:30:00	ES	Futures	4888.22	4888.5	4883.83	4885.2	3257.0
2023-06-19 08:00:00	ES	Futures	4885.2	4885.48	4882.19	4883.56	3914.0
2023-06-19 08:30:00	ES	Futures	4883.56	4886.3	4883.28	4886.03	2888.0
2023-06-19 09:00:00	ES	Futures	4886.3	4886.85	4884.38	4884.38	5014.0
2023-06-19 09:30:00	ES	Futures	4884.38	4884.93	4879.99	4880.54	10729.0
2023-06-19 10:00:00	ES	Futures	4880.81	4883.01	4878.62	4882.19	9451.0
2023-06-19 10:30:00	ES	Futures	4882.19	4883.01	4879.99	4880.54	6072.0
2023-06-19 11:00:00	ES	Futures	4880.81	4882.73	4879.99	4881.09	5628.0
2023-06-19 11:30:00	ES	Futures	4881.36	4884.11	4880.54	4883.83	5952.0
2023-06-19 12:00:00	ES	Futures	4884.11	4884.93	4883.28	4883.83	3143.0
2023-06-19 12:30:00	ES	Futures	4884.11	4885.2	4882.19	4884.38	2801.0
2023-06-19 18:00:00	ES	Futures	4885.2	4887.4	4881.36	4881.91	2906.0
2023-06-19 18:30:00	ES	Futures	4881.91	4883.01	4881.09	4881.64	921.0
2023-06-19 19:00:00	ES	Futures	4881.91	4882.73	4880.54	4881.09	1661.0
2023-06-19 19:30:00	ES	Futures	4880.81	4884.11	4880.54	4882.73	1968.0
2023-06-19 20:00:00	ES	Futures	4882.46	4884.66	4880.26	4882.19	3687.0
2023-06-19 20:30:00	ES	Futures	4882.19	4883.28	4881.64	4882.19	1364.0
2023-06-19 21:00:00	ES	Futures	4882.19	4883.83	4881.64	4883.56	1609.0
2023-06-19 21:30:00	ES	Futures	4883.28	4883.83	4877.79	4879.17	3317.0
2023-06-19 22:00:00	ES	Futures	4879.17	4879.71	4877.79	4878.07	2964.0
2023-06-19 22:30:00	ES	Futures	4878.07	4880.26	4876.97	4878.62	3050.0
2023-06-19 23:00:00	ES	Futures	4878.62	4880.26	4878.07	4878.34	1177.0
2023-06-19 23:30:00	ES	Futures	4878.34	4880.26	4878.07	4879.71	1307.0
2023-06-19 00:00:00	NQ	Futures	16989.36	16995.2	16980.18	16989.08	1848.0
2023-06-19 00:30:00	NQ	Futures	16989.08	16995.2	16984.36	16987.97	1018.0
2023-06-19 01:00:00	NQ	Futures	16987.42	16994.37	16984.36	16992.42	1076.0
2023-06-19 01:30:00	NQ	Futures	16992.98	17004.94	16991.59	17002.71	1787.0
2023-06-19 02:00:00	NQ	Futures	17002.71	17007.44	16996.59	17000.49	1346.0
2023-06-19 02:30:00	NQ	Futures	17000.49	17009.39	16997.43	17002.71	1236.0
2023-06-19 03:00:00	NQ	Futures	17002.71	17020.51	16991.59	17015.79	3818.0
2023-06-19 03:30:00	NQ	Futures	17016.34	17028.02	16990.48	16996.59	3707.0
2023-06-19 04:00:00	NQ	Futures	16996.32	16999.93	16978.24	16984.36	3241.0
2023-06-19 04:30:00	NQ	Futures	16984.36	16991.03	16968.5	16986.3	3100.0
2023-06-19 05:00:00	NQ	Futures	16986.03	16991.87	16969.89	16988.53	2189.0
2023-06-19 05:30:00	NQ	Futures	16988.53	17001.32	16984.36	16992.42	1427.0

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

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