PREVIEW / etf_30min / 2023-04-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-21.parquet
  size:    664 KB
  rows:    26,608

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-21 04:00:00	SPY	ETF	411.48	411.96	411.44	411.6	11186.0
2023-04-21 04:30:00	SPY	ETF	411.52	412.02	411.31	412.0	23354.0
2023-04-21 05:00:00	SPY	ETF	412.1	412.18	411.9	412.0	4361.0
2023-04-21 05:30:00	SPY	ETF	411.81	412.18	411.81	412.0	6350.0
2023-04-21 06:00:00	SPY	ETF	411.6	411.71	411.27	411.27	13458.0
2023-04-21 06:30:00	SPY	ETF	411.3	411.34	410.8	410.88	40593.0
2023-04-21 07:00:00	SPY	ETF	410.89	411.22	410.66	410.98	59870.0
2023-04-21 07:30:00	SPY	ETF	411.0	411.27	410.95	411.14	57035.0
2023-04-21 08:00:00	SPY	ETF	410.7	412.1796	410.7	411.77	221516.0
2023-04-21 08:30:00	SPY	ETF	411.8	412.05	411.65	412.0	109629.0
2023-04-21 09:00:00	SPY	ETF	412.01	412.49	411.9	412.2	188230.0
2023-04-21 09:30:00	SPY	ETF	412.2	412.28	410.914	410.95	6005925.0
2023-04-21 10:00:00	SPY	ETF	410.945	412.44	410.44	412.07	5425257.0
2023-04-21 10:30:00	SPY	ETF	412.06	412.29	410.17	410.8163	5252347.0
2023-04-21 11:00:00	SPY	ETF	410.84	411.64	410.7401	411.28	3294218.0
2023-04-21 11:30:00	SPY	ETF	411.29	411.95	410.82	411.745	2871810.0
2023-04-21 12:00:00	SPY	ETF	411.755	412.02	411.38	411.4592	2044834.0
2023-04-21 12:30:00	SPY	ETF	411.45	411.76	411.25	411.61	1994873.0
2023-04-21 13:00:00	SPY	ETF	411.61	412.015	411.34	411.5299	2041698.0
2023-04-21 13:30:00	SPY	ETF	411.535	412.385	411.52	412.22	2728794.0
2023-04-21 14:00:00	SPY	ETF	412.225	412.68	412.21	412.33	2683879.0
2023-04-21 14:30:00	SPY	ETF	412.33	412.475	411.72	412.02	2982611.0
2023-04-21 15:00:00	SPY	ETF	412.02	412.21	411.36	411.82	3720617.0
2023-04-21 15:30:00	SPY	ETF	411.83	412.38	411.5222	412.18	8448984.0
2023-04-21 16:00:00	SPY	ETF	412.17	412.35	411.9	411.92	2179375.0
2023-04-21 16:30:00	SPY	ETF	411.93	412.186	411.93	411.97	291311.0
2023-04-21 17:00:00	SPY	ETF	412.0	412.2	411.94	412.02	463030.0
2023-04-21 17:30:00	SPY	ETF	412.01	412.1	412.0	412.01	22973.0
2023-04-21 18:00:00	SPY	ETF	412.07	412.07	412.03	412.03	1593.0
2023-04-21 18:30:00	SPY	ETF	412.06	412.07	412.03	412.05	3183.0
2023-04-21 19:00:00	SPY	ETF	412.04	412.07	412.04	412.04	2181.0
2023-04-21 19:30:00	SPY	ETF	412.05	412.07	412.03	412.07	9798.0
2023-04-21 04:00:00	QQQ	ETF	315.96	316.54	315.9	316.18	32641.0
2023-04-21 04:30:00	QQQ	ETF	316.17	316.55	315.77	316.55	16928.0
2023-04-21 05:00:00	QQQ	ETF	316.55	316.56	316.26	316.36	6757.0
2023-04-21 05:30:00	QQQ	ETF	316.24	316.55	316.15	316.15	3943.0
2023-04-21 06:00:00	QQQ	ETF	316.14	316.15	315.65	315.66	16228.0
2023-04-21 06:30:00	QQQ	ETF	315.7	315.7	314.75	314.82	146775.0
2023-04-21 07:00:00	QQQ	ETF	314.83	315.18	314.65	314.96	138804.0
2023-04-21 07:30:00	QQQ	ETF	314.96	315.27	314.9	315.08	128599.0
2023-04-21 08:00:00	QQQ	ETF	315.1616	316.68	314.7	315.65	313997.0
2023-04-21 08:30:00	QQQ	ETF	315.65	315.86	315.35	315.82	134501.0
2023-04-21 09:00:00	QQQ	ETF	315.85	316.34	315.73	315.9	367961.0
2023-04-21 09:30:00	QQQ	ETF	315.91	316.3	314.39	314.41	5325348.0
2023-04-21 10:00:00	QQQ	ETF	314.41	316.47	314.1	316.01	4742554.0
2023-04-21 10:30:00	QQQ	ETF	316.0	316.19	314.59	315.52	3535984.0
2023-04-21 11:00:00	QQQ	ETF	315.53	316.25	315.48	316.05	2654849.0
2023-04-21 11:30:00	QQQ	ETF	316.06	316.81	315.67	316.5	2152618.0
2023-04-21 12:00:00	QQQ	ETF	316.52	316.69	316.005	316.11	1608887.0
2023-04-21 12:30:00	QQQ	ETF	316.115	316.41	315.91	316.235	1402340.0

> showing 50 of 26,608 rows — these rows as CSV

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