PREVIEW / etf_30min / 2023-02-01

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-01.parquet
  size:    722 KB
  rows:    29,331

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-02-01 04:00:00	SPY	ETF	405.23	405.32	404.9	405.26	22938.0
2023-02-01 04:30:00	SPY	ETF	405.04	405.16	404.85	404.87	11848.0
2023-02-01 05:00:00	SPY	ETF	404.96	405.15	404.68	404.85	14667.0
2023-02-01 05:30:00	SPY	ETF	404.75	404.86	404.61	404.8	7589.0
2023-02-01 06:00:00	SPY	ETF	404.8	405.22	404.69	405.21	14413.0
2023-02-01 06:30:00	SPY	ETF	405.18	405.32	405.1	405.25	44844.0
2023-02-01 07:00:00	SPY	ETF	405.22	405.9	405.11	405.77	115348.0
2023-02-01 07:30:00	SPY	ETF	405.75	405.88	405.39	405.76	89913.0
2023-02-01 08:00:00	SPY	ETF	405.3799	405.93	404.83	405.4	300000.0
2023-02-01 08:30:00	SPY	ETF	405.37	405.62	404.9	405.07	107553.0
2023-02-01 09:00:00	SPY	ETF	405.06	405.35	404.88	405.23	178515.0
2023-02-01 09:30:00	SPY	ETF	405.211	406.43	404.81	406.2	5457834.0
2023-02-01 10:00:00	SPY	ETF	406.21	406.3575	404.79	405.56	3885834.0
2023-02-01 10:30:00	SPY	ETF	405.58	405.85	403.9605	404.13	3913959.0
2023-02-01 11:00:00	SPY	ETF	404.1491	405.36	403.93	405.26	3286293.0
2023-02-01 11:30:00	SPY	ETF	405.25	405.54	404.535	404.575	1904122.0
2023-02-01 12:00:00	SPY	ETF	404.565	404.66	403.76	404.2714	2164620.0
2023-02-01 12:30:00	SPY	ETF	404.26	404.4499	404.02	404.13	1515967.0
2023-02-01 13:00:00	SPY	ETF	404.13	404.6	403.96	404.58	1689208.0
2023-02-01 13:30:00	SPY	ETF	404.59	405.41	404.18	404.73	2383580.0
2023-02-01 14:00:00	SPY	ETF	404.72	406.1	402.4	404.69	6777713.0
2023-02-01 14:30:00	SPY	ETF	404.68	410.28	402.35	409.12	15534146.0
2023-02-01 15:00:00	SPY	ETF	409.18	411.81	409.13	411.24	9614704.0
2023-02-01 15:30:00	SPY	ETF	411.25	413.67	409.98	410.79	16116246.0
2023-02-01 16:00:00	SPY	ETF	410.79	412.02	410.15	411.43	4423526.0
2023-02-01 16:30:00	SPY	ETF	411.43	411.75	411.4	411.63	312641.0
2023-02-01 17:00:00	SPY	ETF	411.63	412.1494	411.55	412.12	74129.0
2023-02-01 17:30:00	SPY	ETF	412.05	412.1	411.97	412.05	97977.0
2023-02-01 18:00:00	SPY	ETF	412.04	412.72	411.93	412.43	171786.0
2023-02-01 18:30:00	SPY	ETF	412.4	412.41	411.92	412.4	48997.0
2023-02-01 19:00:00	SPY	ETF	412.43	412.44	411.61	411.75	88914.0
2023-02-01 19:30:00	SPY	ETF	411.75	412.37	411.75	412.12	235295.0
2023-02-01 04:00:00	QQQ	ETF	294.0	294.25	293.77	294.12	42608.0
2023-02-01 04:30:00	QQQ	ETF	294.12	294.12	293.74	293.94	21398.0
2023-02-01 05:00:00	QQQ	ETF	293.8	293.99	293.59	293.66	7024.0
2023-02-01 05:30:00	QQQ	ETF	293.61	293.74	293.49	293.63	13205.0
2023-02-01 06:00:00	QQQ	ETF	293.68	294.07	293.59	294.07	8747.0
2023-02-01 06:30:00	QQQ	ETF	293.94	294.16	293.94	294.16	45367.0
2023-02-01 07:00:00	QQQ	ETF	294.13	295.0	294.05	294.99	85876.0
2023-02-01 07:30:00	QQQ	ETF	295.01	295.03	294.42	294.71	88089.0
2023-02-01 08:00:00	QQQ	ETF	294.12	295.01	293.5704	294.33	304200.0
2023-02-01 08:30:00	QQQ	ETF	294.33	294.58	294.11	294.18	202768.0
2023-02-01 09:00:00	QQQ	ETF	294.25	294.62	294.22	294.41	176748.0
2023-02-01 09:30:00	QQQ	ETF	294.41	294.79	293.41	294.58	3402234.0
2023-02-01 10:00:00	QQQ	ETF	294.61	294.75	293.59	294.37	2831883.0
2023-02-01 10:30:00	QQQ	ETF	294.38	294.72	292.95	293.08	1981795.0
2023-02-01 11:00:00	QQQ	ETF	293.03	294.26	292.84	294.114	1681838.0
2023-02-01 11:30:00	QQQ	ETF	294.13	294.44	293.68	293.89	909071.0
2023-02-01 12:00:00	QQQ	ETF	293.91	294.0	293.33	293.81	892502.0
2023-02-01 12:30:00	QQQ	ETF	293.81	294.17	293.59	293.93	611922.0

> showing 50 of 29,331 rows — these rows as CSV

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