PREVIEW / etf_30min / 2023-11-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-21.parquet
  size:    735 KB
  rows:    29,340

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-11-21 04:00:00	SPY	ETF	454.4	454.4	453.85	454.05	12319.0
2023-11-21 04:30:00	SPY	ETF	454.06	454.2	453.74	453.75	5634.0
2023-11-21 05:00:00	SPY	ETF	453.75	454.0	453.75	454.0	3637.0
2023-11-21 05:30:00	SPY	ETF	454.09	454.14	453.98	453.99	4827.0
2023-11-21 06:00:00	SPY	ETF	454.0	454.0	453.75	453.83	11035.0
2023-11-21 06:30:00	SPY	ETF	453.79	453.85	453.68	453.71	22929.0
2023-11-21 07:00:00	SPY	ETF	453.75	453.94	453.63	453.94	55083.0
2023-11-21 07:30:00	SPY	ETF	453.9	454.0	453.49	453.54	78214.0
2023-11-21 08:00:00	SPY	ETF	453.741	454.51	453.36	453.46	170882.0
2023-11-21 08:30:00	SPY	ETF	453.49	453.59	453.0	453.05	150302.0
2023-11-21 09:00:00	SPY	ETF	453.05	453.32	452.92	453.19	308078.0
2023-11-21 09:30:00	SPY	ETF	453.1842	453.32	452.71	452.82	4050190.0
2023-11-21 10:00:00	SPY	ETF	452.82	453.175	452.04	452.15	4124755.0
2023-11-21 10:30:00	SPY	ETF	452.16	452.76	451.9599	452.68	3243419.0
2023-11-21 11:00:00	SPY	ETF	452.68	452.79	452.31	452.5	2783336.0
2023-11-21 11:30:00	SPY	ETF	452.4901	452.91	452.22	452.885	2124558.0
2023-11-21 12:00:00	SPY	ETF	452.89	453.2	452.7599	453.13	1784783.0
2023-11-21 12:30:00	SPY	ETF	453.1338	453.59	453.085	453.5397	1992820.0
2023-11-21 13:00:00	SPY	ETF	453.535	453.56	452.6414	452.8409	2020025.0
2023-11-21 13:30:00	SPY	ETF	452.85	453.57	452.79	453.24	1744023.0
2023-11-21 14:00:00	SPY	ETF	453.26	453.555	452.8997	453.25	2352740.0
2023-11-21 14:30:00	SPY	ETF	453.25	453.325	452.82	453.305	2344775.0
2023-11-21 15:00:00	SPY	ETF	453.31	453.65	453.063	453.27	2320300.0
2023-11-21 15:30:00	SPY	ETF	453.275	453.49	452.89	453.27	6029486.0
2023-11-21 16:00:00	SPY	ETF	453.26	453.27	451.88	453.0	2085137.0
2023-11-21 16:30:00	SPY	ETF	453.11	453.11	452.77	452.94	166261.0
2023-11-21 17:00:00	SPY	ETF	452.97	453.16	452.85	453.07	64882.0
2023-11-21 17:30:00	SPY	ETF	452.911	453.15	452.89	452.95	12766.0
2023-11-21 18:00:00	SPY	ETF	452.96	452.96	452.5	452.5704	47198.0
2023-11-21 18:30:00	SPY	ETF	452.6	452.72	452.6	452.72	7247.0
2023-11-21 19:00:00	SPY	ETF	452.72	452.97	452.71	452.95	7158.0
2023-11-21 19:30:00	SPY	ETF	452.92	453.0002	452.88	452.98	14067.0
2023-11-21 04:00:00	QQQ	ETF	390.8	391.0	390.61	390.81	25995.0
2023-11-21 04:30:00	QQQ	ETF	390.83	390.94	390.49	390.56	17759.0
2023-11-21 05:00:00	QQQ	ETF	390.52	390.83	390.49	390.83	8860.0
2023-11-21 05:30:00	QQQ	ETF	390.8	390.99	390.7	390.7	8300.0
2023-11-21 06:00:00	QQQ	ETF	390.77	390.78	390.58	390.67	12810.0
2023-11-21 06:30:00	QQQ	ETF	390.65	390.68	390.12	390.18	39163.0
2023-11-21 07:00:00	QQQ	ETF	390.21	390.43	390.18	390.42	41411.0
2023-11-21 07:30:00	QQQ	ETF	390.32	390.52	389.69	389.76	72446.0
2023-11-21 08:00:00	QQQ	ETF	390.2099	391.3	389.5	389.52	107109.0
2023-11-21 08:30:00	QQQ	ETF	389.52	389.68	388.84	388.92	234370.0
2023-11-21 09:00:00	QQQ	ETF	388.89	389.2	388.73	388.99	327853.0
2023-11-21 09:30:00	QQQ	ETF	389.01	389.23	388.23	388.3799	4768535.0
2023-11-21 10:00:00	QQQ	ETF	388.37	388.81	386.83	386.94	3391000.0
2023-11-21 10:30:00	QQQ	ETF	386.95	387.471	386.7	387.33	2683165.0
2023-11-21 11:00:00	QQQ	ETF	387.34	387.58	386.95	387.46	2415293.0
2023-11-21 11:30:00	QQQ	ETF	387.45	387.81	387.02	387.77	1983199.0
2023-11-21 12:00:00	QQQ	ETF	387.78	388.105	387.6	388.04	1554598.0
2023-11-21 12:30:00	QQQ	ETF	388.035	388.49	387.92	388.4	1432429.0

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

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