PREVIEW / futures_30min / 2023-04-23

all futures 30-min files

  file:    by_date/futures_30min/2023/2023-04-23.parquet
  size:    27 KB
  rows:    765

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-04-23 18:00:00	ES	Futures	4604.07	4605.73	4602.4	4603.79	4201.0
2023-04-23 18:30:00	ES	Futures	4604.07	4605.73	4603.51	4605.18	1424.0
2023-04-23 19:00:00	ES	Futures	4605.18	4606.84	4604.9	4605.45	1802.0
2023-04-23 19:30:00	ES	Futures	4605.45	4606.29	4604.34	4604.62	1495.0
2023-04-23 20:00:00	ES	Futures	4604.62	4604.62	4598.8	4599.91	5461.0
2023-04-23 20:30:00	ES	Futures	4599.91	4601.29	4597.96	4601.02	3223.0
2023-04-23 21:00:00	ES	Futures	4600.74	4602.12	4599.91	4601.29	2981.0
2023-04-23 21:30:00	ES	Futures	4601.29	4602.68	4599.63	4599.91	2894.0
2023-04-23 22:00:00	ES	Futures	4599.63	4601.57	4599.07	4601.02	2301.0
2023-04-23 22:30:00	ES	Futures	4600.74	4601.02	4596.58	4598.52	3634.0
2023-04-23 23:00:00	ES	Futures	4598.52	4599.35	4598.24	4599.07	1577.0
2023-04-23 23:30:00	ES	Futures	4598.8	4598.8	4596.86	4597.69	1159.0
2023-04-23 18:00:00	NQ	Futures	14719.59	14721.0	14708.89	14714.52	1887.0
2023-04-23 18:30:00	NQ	Futures	14713.68	14723.25	14712.27	14719.87	736.0
2023-04-23 19:00:00	NQ	Futures	14720.72	14724.94	14718.47	14720.15	975.0
2023-04-23 19:30:00	NQ	Futures	14720.15	14724.1	14715.65	14718.18	686.0
2023-04-23 20:00:00	NQ	Futures	14717.34	14717.62	14697.07	14700.45	2745.0
2023-04-23 20:30:00	NQ	Futures	14699.32	14706.64	14692.84	14704.67	1896.0
2023-04-23 21:00:00	NQ	Futures	14704.39	14710.86	14701.29	14706.08	1769.0
2023-04-23 21:30:00	NQ	Futures	14706.08	14713.68	14701.29	14702.7	1486.0
2023-04-23 22:00:00	NQ	Futures	14701.85	14714.52	14699.88	14712.55	1450.0
2023-04-23 22:30:00	NQ	Futures	14712.55	14712.55	14695.94	14702.7	1849.0
2023-04-23 23:00:00	NQ	Futures	14702.14	14705.51	14698.76	14703.26	801.0
2023-04-23 23:30:00	NQ	Futures	14702.98	14702.98	14695.94	14699.32	718.0
2023-04-23 18:00:00	YM	Futures	37494.3	37494.3	37465.5	37475.5	578.0
2023-04-23 18:30:00	YM	Futures	37476.6	37481.0	37471.1	37476.6	336.0
2023-04-23 19:00:00	YM	Futures	37476.6	37487.6	37474.4	37479.9	271.0
2023-04-23 19:30:00	YM	Futures	37479.9	37483.2	37473.3	37474.4	329.0
2023-04-23 20:00:00	YM	Futures	37473.3	37473.3	37423.5	37431.3	1206.0
2023-04-23 20:30:00	YM	Futures	37430.2	37441.2	37419.1	37439.0	703.0
2023-04-23 21:00:00	YM	Futures	37436.8	37445.6	37431.3	37440.1	612.0
2023-04-23 21:30:00	YM	Futures	37440.1	37444.5	37420.2	37420.2	457.0
2023-04-23 22:00:00	YM	Futures	37420.2	37429.1	37416.9	37421.3	495.0
2023-04-23 22:30:00	YM	Futures	37421.3	37422.4	37390.4	37404.7	810.0
2023-04-23 23:00:00	YM	Futures	37404.7	37412.5	37404.7	37409.2	373.0
2023-04-23 23:30:00	YM	Futures	37408.1	37408.1	37399.2	37403.6	215.0
2023-04-23 18:00:00	CL	Futures	63.37	63.38	63.11	63.11	1364.0
2023-04-23 18:30:00	CL	Futures	63.12	63.25	63.08	63.24	846.0
2023-04-23 19:00:00	CL	Futures	63.24	63.24	63.16	63.16	301.0
2023-04-23 19:30:00	CL	Futures	63.16	63.2	63.14	63.16	277.0
2023-04-23 20:00:00	CL	Futures	63.17	63.17	62.99	62.99	1075.0
2023-04-23 20:30:00	CL	Futures	63.0	63.01	62.86	62.93	1223.0
2023-04-23 21:00:00	CL	Futures	62.93	63.07	62.83	62.93	2283.0
2023-04-23 21:30:00	CL	Futures	62.92	62.98	62.75	62.76	1458.0
2023-04-23 22:00:00	CL	Futures	62.76	62.84	62.72	62.76	1210.0
2023-04-23 22:30:00	CL	Futures	62.75	62.77	62.61	62.64	1346.0
2023-04-23 23:00:00	CL	Futures	62.64	62.77	62.64	62.72	1119.0
2023-04-23 23:30:00	CL	Futures	62.72	62.72	62.67	62.71	472.0
2023-04-23 18:00:00	GC	Futures	2290.8	2292.4	2289.9	2292.1	998.0
2023-04-23 18:30:00	GC	Futures	2292.0	2293.7	2292.0	2293.6	572.0

> showing 50 of 765 rows — these rows as CSV

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