PREVIEW / etf_30min / 2023-02-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-21.parquet
  size:    718 KB
  rows:    28,691

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-21 04:00:00	SPY	ETF	403.67	405.49	403.36	404.15	49134.0
2023-02-21 04:30:00	SPY	ETF	404.07	405.43	404.05	405.0	48889.0
2023-02-21 05:00:00	SPY	ETF	405.07	405.07	404.05	404.37	23358.0
2023-02-21 05:30:00	SPY	ETF	404.37	404.37	404.0	404.0	4815.0
2023-02-21 06:00:00	SPY	ETF	403.98	404.34	403.73	404.34	29457.0
2023-02-21 06:30:00	SPY	ETF	404.24	404.66	404.22	404.62	18472.0
2023-02-21 07:00:00	SPY	ETF	404.64	404.7	403.78	403.97	160649.0
2023-02-21 07:30:00	SPY	ETF	403.98	404.43	403.97	404.18	186862.0
2023-02-21 08:00:00	SPY	ETF	404.17	405.65	403.34	403.52	320701.0
2023-02-21 08:30:00	SPY	ETF	403.64	404.03	403.35	403.4	277018.0
2023-02-21 09:00:00	SPY	ETF	403.41	403.76	402.98	403.0	419301.0
2023-02-21 09:30:00	SPY	ETF	403.06	404.16	402.29	402.51	7327727.0
2023-02-21 10:00:00	SPY	ETF	402.51	402.9	401.501	401.7384	5897929.0
2023-02-21 10:30:00	SPY	ETF	401.72	402.56	401.26	401.34	4836060.0
2023-02-21 11:00:00	SPY	ETF	401.34	401.72	400.6504	400.7599	3695332.0
2023-02-21 11:30:00	SPY	ETF	400.75	401.07	400.27	400.4952	3568025.0
2023-02-21 12:00:00	SPY	ETF	400.48	400.79	400.13	400.2799	2388904.0
2023-02-21 12:30:00	SPY	ETF	400.28	400.97	400.11	400.89	2263130.0
2023-02-21 13:00:00	SPY	ETF	400.88	400.97	399.86	400.06	2433462.0
2023-02-21 13:30:00	SPY	ETF	400.07	400.08	399.49	399.655	2206553.0
2023-02-21 14:00:00	SPY	ETF	399.655	399.6799	398.82	399.2999	4402971.0
2023-02-21 14:30:00	SPY	ETF	399.3	400.07	399.19	399.7	3272675.0
2023-02-21 15:00:00	SPY	ETF	399.71	400.1	399.23	399.58	2845619.0
2023-02-21 15:30:00	SPY	ETF	399.59	400.16	398.9	399.13	10769923.0
2023-02-21 16:00:00	SPY	ETF	399.14	399.61	399.0605	399.34	5186586.0
2023-02-21 16:30:00	SPY	ETF	399.33	399.39	399.09	399.37	227565.0
2023-02-21 17:00:00	SPY	ETF	399.35	399.49	399.27	399.27	35833.0
2023-02-21 17:30:00	SPY	ETF	399.28	399.3996	399.24	399.27	17703.0
2023-02-21 18:00:00	SPY	ETF	399.32	399.43	399.13	399.39	46615.0
2023-02-21 18:30:00	SPY	ETF	399.4	399.63	399.28	399.63	33116.0
2023-02-21 19:00:00	SPY	ETF	399.68	399.8	399.45	399.55	27272.0
2023-02-21 19:30:00	SPY	ETF	399.64	399.78	399.5	399.74	51962.0
2023-02-21 04:00:00	QQQ	ETF	297.37	299.0	297.29	297.92	85429.0
2023-02-21 04:30:00	QQQ	ETF	297.86	299.34	297.86	298.94	54823.0
2023-02-21 05:00:00	QQQ	ETF	298.85	298.93	298.19	298.29	27224.0
2023-02-21 05:30:00	QQQ	ETF	298.53	298.74	298.15	298.15	39784.0
2023-02-21 06:00:00	QQQ	ETF	298.17	298.67	298.0	298.54	42516.0
2023-02-21 06:30:00	QQQ	ETF	298.59	298.77	298.4	298.42	39012.0
2023-02-21 07:00:00	QQQ	ETF	298.59	298.62	297.8	298.0	191430.0
2023-02-21 07:30:00	QQQ	ETF	297.99	298.36	297.99	298.15	65022.0
2023-02-21 08:00:00	QQQ	ETF	298.54	300.38	297.3804	297.74	276407.0
2023-02-21 08:30:00	QQQ	ETF	297.76	298.13	297.51	297.51	327835.0
2023-02-21 09:00:00	QQQ	ETF	297.51	297.7901	297.1404	297.27	368298.0
2023-02-21 09:30:00	QQQ	ETF	297.27	298.73	296.98	297.25	5967306.0
2023-02-21 10:00:00	QQQ	ETF	297.23	297.57	296.11	296.24	3784285.0
2023-02-21 10:30:00	QQQ	ETF	296.23	297.24	296.08	296.25	2713204.0
2023-02-21 11:00:00	QQQ	ETF	296.26	296.64	295.451	295.61	1779981.0
2023-02-21 11:30:00	QQQ	ETF	295.5901	295.94	295.21	295.36	2043805.0
2023-02-21 12:00:00	QQQ	ETF	295.33	295.69	295.16	295.2001	1288882.0
2023-02-21 12:30:00	QQQ	ETF	295.215	295.93	295.12	295.86	1325098.0

> showing 50 of 28,691 rows — these rows as CSV

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