PREVIEW / etf_30min / 2023-01-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-20.parquet
  size:    697 KB
  rows:    27,253

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-01-20 04:00:00	SPY	ETF	389.37	389.46	388.65	389.28	17125.0
2023-01-20 04:30:00	SPY	ETF	389.23	389.39	388.79	388.8	16265.0
2023-01-20 05:00:00	SPY	ETF	388.76	389.19	388.36	388.85	29519.0
2023-01-20 05:30:00	SPY	ETF	389.03	389.43	388.8	389.42	34767.0
2023-01-20 06:00:00	SPY	ETF	389.3	389.3	388.74	388.82	16937.0
2023-01-20 06:30:00	SPY	ETF	389.09	389.29	388.9	389.05	13166.0
2023-01-20 07:00:00	SPY	ETF	389.05	389.27	388.85	389.2	54514.0
2023-01-20 07:30:00	SPY	ETF	389.28	390.03	389.28	389.83	155173.0
2023-01-20 08:00:00	SPY	ETF	389.07	390.2	388.6204	389.52	249148.0
2023-01-20 08:30:00	SPY	ETF	389.51	389.68	389.04	389.11	206509.0
2023-01-20 09:00:00	SPY	ETF	389.1	390.22	389.0	390.07	311714.0
2023-01-20 09:30:00	SPY	ETF	390.09	390.11	388.38	389.708	5469641.0
2023-01-20 10:00:00	SPY	ETF	389.71	391.05	389.29	390.95	4535794.0
2023-01-20 10:30:00	SPY	ETF	390.95	391.17	390.36	390.65	3298866.0
2023-01-20 11:00:00	SPY	ETF	390.67	392.42	390.6	392.35	4001914.0
2023-01-20 11:30:00	SPY	ETF	392.35	392.48	391.61	391.76	3538692.0
2023-01-20 12:00:00	SPY	ETF	391.77	392.3	391.74	392.06	1928278.0
2023-01-20 12:30:00	SPY	ETF	392.07	392.33	391.77	391.8599	1822030.0
2023-01-20 13:00:00	SPY	ETF	391.86	392.42	391.1	391.615	3037291.0
2023-01-20 13:30:00	SPY	ETF	391.625	393.6	391.625	393.42	3604924.0
2023-01-20 14:00:00	SPY	ETF	393.42	393.97	393.21	393.85	3375713.0
2023-01-20 14:30:00	SPY	ETF	393.86	394.35	393.795	394.31	3314344.0
2023-01-20 15:00:00	SPY	ETF	394.305	395.79	394.305	395.18	5262092.0
2023-01-20 15:30:00	SPY	ETF	395.17	396.04	394.82	395.83	11379589.0
2023-01-20 16:00:00	SPY	ETF	395.83	395.979	388.0	395.65	4971715.0
2023-01-20 16:30:00	SPY	ETF	395.64	395.88	395.63	395.85	162088.0
2023-01-20 17:00:00	SPY	ETF	395.85	396.1	395.77	396.04	478114.0
2023-01-20 17:30:00	SPY	ETF	396.05	396.25	395.87	395.87	78401.0
2023-01-20 18:00:00	SPY	ETF	395.86	396.03	395.86	396.0	12249.0
2023-01-20 18:30:00	SPY	ETF	395.88	396.1	395.88	395.95	213796.0
2023-01-20 19:00:00	SPY	ETF	396.0	396.08	396.0	396.08	5823.0
2023-01-20 19:30:00	SPY	ETF	396.03	396.29	396.03	396.29	13935.0
2023-01-20 04:00:00	QQQ	ETF	276.04	276.1	275.38	275.92	33734.0
2023-01-20 04:30:00	QQQ	ETF	275.95	275.95	275.65	275.71	11750.0
2023-01-20 05:00:00	QQQ	ETF	275.55	276.16	275.35	275.9	47291.0
2023-01-20 05:30:00	QQQ	ETF	276.01	276.32	276.0	276.28	14070.0
2023-01-20 06:00:00	QQQ	ETF	276.23	276.23	275.88	276.15	14392.0
2023-01-20 06:30:00	QQQ	ETF	276.15	276.43	276.15	276.39	72694.0
2023-01-20 07:00:00	QQQ	ETF	276.35	276.58	276.19	276.53	111281.0
2023-01-20 07:30:00	QQQ	ETF	276.57	277.171	276.57	277.024	134138.0
2023-01-20 08:00:00	QQQ	ETF	276.51	277.26	275.356	276.86	162086.0
2023-01-20 08:30:00	QQQ	ETF	276.86	277.0	276.32	276.32	211593.0
2023-01-20 09:00:00	QQQ	ETF	276.35	277.13	276.27	276.77	482278.0
2023-01-20 09:30:00	QQQ	ETF	276.76	277.9	275.71	277.3	4001514.0
2023-01-20 10:00:00	QQQ	ETF	277.35	278.36	276.74	278.24	2702511.0
2023-01-20 10:30:00	QQQ	ETF	278.28	278.5007	277.52	277.6999	1625264.0
2023-01-20 11:00:00	QQQ	ETF	277.72	279.46	277.64	279.43	2646503.0
2023-01-20 11:30:00	QQQ	ETF	279.43	279.57	278.86	279.11	2026318.0
2023-01-20 12:00:00	QQQ	ETF	279.12	279.69	279.085	279.47	1714366.0
2023-01-20 12:30:00	QQQ	ETF	279.48	279.8	279.22	279.31	920995.0

> showing 50 of 27,253 rows — these rows as CSV

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