PREVIEW / futures_30min / 2023-04-07

all futures 30-min files

  file:    by_date/futures_30min/2023/2023-04-07.parquet
  size:    28 KB
  rows:    786

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-07 00:00:00	ES	Futures	4580.21	4581.05	4579.38	4580.77	713.0
2023-04-07 00:30:00	ES	Futures	4580.49	4581.05	4580.21	4580.49	449.0
2023-04-07 01:00:00	ES	Futures	4580.49	4580.77	4579.38	4579.94	624.0
2023-04-07 01:30:00	ES	Futures	4579.94	4581.32	4579.94	4580.77	1120.0
2023-04-07 02:00:00	ES	Futures	4580.77	4580.77	4579.1	4580.49	854.0
2023-04-07 02:30:00	ES	Futures	4580.77	4581.32	4579.38	4579.66	535.0
2023-04-07 03:00:00	ES	Futures	4579.66	4579.94	4575.78	4576.05	1480.0
2023-04-07 03:30:00	ES	Futures	4576.33	4578.0	4576.05	4577.16	978.0
2023-04-07 04:00:00	ES	Futures	4576.89	4579.1	4576.89	4578.83	556.0
2023-04-07 04:30:00	ES	Futures	4578.83	4580.49	4578.55	4580.49	762.0
2023-04-07 05:00:00	ES	Futures	4580.49	4581.32	4579.38	4580.77	917.0
2023-04-07 05:30:00	ES	Futures	4580.77	4582.16	4580.21	4580.77	1000.0
2023-04-07 06:00:00	ES	Futures	4580.77	4581.6	4580.21	4580.49	1017.0
2023-04-07 06:30:00	ES	Futures	4580.77	4581.6	4580.49	4581.6	717.0
2023-04-07 07:00:00	ES	Futures	4581.6	4581.88	4579.1	4581.32	1659.0
2023-04-07 07:30:00	ES	Futures	4581.32	4582.71	4578.0	4578.55	2781.0
2023-04-07 08:00:00	ES	Futures	4578.55	4579.1	4573.83	4578.27	6062.0
2023-04-07 08:30:00	ES	Futures	4578.55	4600.46	4571.89	4590.48	31584.0
2023-04-07 09:00:00	ES	Futures	4590.2	4596.02	4589.92	4594.64	4296.0
2023-04-07 00:00:00	NQ	Futures	14820.67	14824.05	14818.98	14822.64	393.0
2023-04-07 00:30:00	NQ	Futures	14823.48	14825.17	14821.51	14821.8	337.0
2023-04-07 01:00:00	NQ	Futures	14822.08	14822.64	14817.29	14818.7	398.0
2023-04-07 01:30:00	NQ	Futures	14818.98	14825.17	14818.98	14822.36	613.0
2023-04-07 02:00:00	NQ	Futures	14822.36	14827.43	14817.57	14826.3	696.0
2023-04-07 02:30:00	NQ	Futures	14826.3	14834.47	14826.02	14828.55	846.0
2023-04-07 03:00:00	NQ	Futures	14828.83	14830.24	14815.32	14816.16	1130.0
2023-04-07 03:30:00	NQ	Futures	14817.01	14820.39	14813.91	14816.73	713.0
2023-04-07 04:00:00	NQ	Futures	14816.16	14832.21	14815.6	14831.09	760.0
2023-04-07 04:30:00	NQ	Futures	14831.65	14838.97	14829.4	14836.15	1111.0
2023-04-07 05:00:00	NQ	Futures	14835.31	14836.44	14827.14	14830.81	692.0
2023-04-07 05:30:00	NQ	Futures	14830.81	14836.44	14829.12	14831.93	625.0
2023-04-07 06:00:00	NQ	Futures	14831.93	14832.78	14818.7	14820.95	887.0
2023-04-07 06:30:00	NQ	Futures	14821.23	14831.93	14821.23	14830.81	645.0
2023-04-07 07:00:00	NQ	Futures	14831.09	14834.75	14820.95	14828.83	1269.0
2023-04-07 07:30:00	NQ	Futures	14828.55	14831.09	14800.4	14808.56	2140.0
2023-04-07 08:00:00	NQ	Futures	14808.56	14817.85	14798.99	14814.19	2307.0
2023-04-07 08:30:00	NQ	Futures	14816.16	14857.27	14778.15	14829.12	14050.0
2023-04-07 09:00:00	NQ	Futures	14829.68	14850.23	14828.55	14848.26	2087.0
2023-04-07 00:00:00	YM	Futures	37154.9	37161.6	37151.6	37160.5	92.0
2023-04-07 00:30:00	YM	Futures	37160.5	37161.6	37156.0	37158.3	175.0
2023-04-07 01:00:00	YM	Futures	37157.2	37159.4	37150.5	37151.6	259.0
2023-04-07 01:30:00	YM	Futures	37151.6	37160.5	37151.6	37154.9	292.0
2023-04-07 02:00:00	YM	Futures	37154.9	37157.2	37143.9	37150.5	217.0
2023-04-07 02:30:00	YM	Futures	37149.4	37151.6	37133.9	37136.2	229.0
2023-04-07 03:00:00	YM	Futures	37136.2	37136.2	37112.9	37112.9	426.0
2023-04-07 03:30:00	YM	Futures	37114.0	37131.7	37112.9	37127.3	325.0
2023-04-07 04:00:00	YM	Futures	37127.3	37130.6	37121.8	37127.3	236.0
2023-04-07 04:30:00	YM	Futures	37128.4	37139.5	37122.9	37139.5	150.0
2023-04-07 05:00:00	YM	Futures	37140.6	37152.7	37140.6	37151.6	251.0
2023-04-07 05:30:00	YM	Futures	37152.7	37162.7	37150.5	37157.2	210.0

> showing 50 of 786 rows — these rows as CSV

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