PREVIEW / futures_30min / 2023-08-20

all futures 30-min files

  file:    by_date/futures_30min/2023/2023-08-20.parquet
  size:    28 KB
  rows:    773

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-08-20 18:00:00	ES	Futures	4812.18	4817.95	4811.36	4816.03	4960.0
2023-08-20 18:30:00	ES	Futures	4816.03	4816.85	4813.28	4814.38	2013.0
2023-08-20 19:00:00	ES	Futures	4814.38	4814.66	4811.36	4813.56	2449.0
2023-08-20 19:30:00	ES	Futures	4813.83	4816.58	4813.28	4816.3	2156.0
2023-08-20 20:00:00	ES	Futures	4816.3	4819.6	4814.11	4819.05	4456.0
2023-08-20 20:30:00	ES	Futures	4819.05	4820.69	4817.68	4819.05	2955.0
2023-08-20 21:00:00	ES	Futures	4818.77	4818.77	4807.79	4814.66	9028.0
2023-08-20 21:30:00	ES	Futures	4814.66	4816.58	4811.09	4813.56	7182.0
2023-08-20 22:00:00	ES	Futures	4813.28	4818.77	4812.46	4817.95	4844.0
2023-08-20 22:30:00	ES	Futures	4817.95	4819.32	4817.13	4817.68	2501.0
2023-08-20 23:00:00	ES	Futures	4817.68	4818.77	4814.38	4815.48	2078.0
2023-08-20 23:30:00	ES	Futures	4815.75	4815.75	4813.56	4814.66	1584.0
2023-08-20 18:00:00	NQ	Futures	16423.64	16452.01	16411.96	16444.23	3731.0
2023-08-20 18:30:00	NQ	Futures	16443.95	16446.17	16429.76	16433.93	1469.0
2023-08-20 19:00:00	NQ	Futures	16434.21	16435.33	16421.42	16430.04	2150.0
2023-08-20 19:30:00	NQ	Futures	16430.88	16443.11	16428.65	16442.0	1421.0
2023-08-20 20:00:00	NQ	Futures	16442.0	16454.52	16430.6	16453.4	2804.0
2023-08-20 20:30:00	NQ	Futures	16453.68	16460.08	16446.73	16452.01	1712.0
2023-08-20 21:00:00	NQ	Futures	16451.18	16451.18	16392.49	16425.59	5478.0
2023-08-20 21:30:00	NQ	Futures	16426.15	16433.38	16405.01	16415.02	3655.0
2023-08-20 22:00:00	NQ	Futures	16415.3	16440.89	16409.46	16437.55	2577.0
2023-08-20 22:30:00	NQ	Futures	16438.11	16443.11	16432.27	16435.33	1278.0
2023-08-20 23:00:00	NQ	Futures	16435.05	16441.44	16423.09	16428.37	1272.0
2023-08-20 23:30:00	NQ	Futures	16429.21	16429.76	16418.92	16425.31	923.0
2023-08-20 18:00:00	YM	Futures	37867.5	37888.3	37856.6	37877.4	785.0
2023-08-20 18:30:00	YM	Futures	37876.3	37880.7	37857.7	37864.2	288.0
2023-08-20 19:00:00	YM	Futures	37863.1	37864.2	37845.6	37860.9	313.0
2023-08-20 19:30:00	YM	Futures	37860.9	37879.6	37857.7	37878.5	203.0
2023-08-20 20:00:00	YM	Futures	37877.4	37905.9	37866.4	37903.7	670.0
2023-08-20 20:30:00	YM	Futures	37902.6	37908.1	37889.4	37898.2	399.0
2023-08-20 21:00:00	YM	Futures	37896.0	37897.1	37831.4	37876.3	914.0
2023-08-20 21:30:00	YM	Futures	37878.5	37888.3	37855.5	37873.0	545.0
2023-08-20 22:00:00	YM	Futures	37873.0	37905.9	37867.5	37898.2	483.0
2023-08-20 22:30:00	YM	Futures	37899.3	37909.2	37892.7	37900.4	469.0
2023-08-20 23:00:00	YM	Futures	37900.4	37904.8	37877.4	37886.1	234.0
2023-08-20 23:30:00	YM	Futures	37884.0	37885.0	37871.9	37878.5	156.0
2023-08-20 18:00:00	CL	Futures	66.19	66.23	65.92	66.03	1434.0
2023-08-20 18:30:00	CL	Futures	66.03	66.11	66.02	66.1	444.0
2023-08-20 19:00:00	CL	Futures	66.1	66.1	66.03	66.05	333.0
2023-08-20 19:30:00	CL	Futures	66.05	66.07	66.04	66.05	243.0
2023-08-20 20:00:00	CL	Futures	66.05	66.1	66.02	66.09	645.0
2023-08-20 20:30:00	CL	Futures	66.09	66.1	66.03	66.07	583.0
2023-08-20 21:00:00	CL	Futures	66.06	66.51	66.05	66.45	4095.0
2023-08-20 21:30:00	CL	Futures	66.46	66.7	66.44	66.69	2948.0
2023-08-20 22:00:00	CL	Futures	66.69	66.78	66.58	66.73	2317.0
2023-08-20 22:30:00	CL	Futures	66.72	66.79	66.69	66.74	1391.0
2023-08-20 23:00:00	CL	Futures	66.73	66.74	66.61	66.64	1105.0
2023-08-20 23:30:00	CL	Futures	66.64	66.69	66.59	66.6	734.0
2023-08-20 18:00:00	GC	Futures	2142.8	2144.2	2142.6	2143.8	807.0
2023-08-20 18:30:00	GC	Futures	2143.7	2144.1	2143.1	2143.7	488.0

> showing 50 of 773 rows — these rows as CSV

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