PREVIEW / etf_30min / 2023-11-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-24.parquet
  size:    441 KB
  rows:    16,464

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-24 04:00:00	SPY	ETF	455.18	455.62	454.87	455.61	10376.0
2023-11-24 04:30:00	SPY	ETF	455.62	455.76	455.56	455.58	7060.0
2023-11-24 05:00:00	SPY	ETF	455.58	455.62	455.52	455.55	2415.0
2023-11-24 05:30:00	SPY	ETF	455.53	455.75	455.4	455.75	3151.0
2023-11-24 06:00:00	SPY	ETF	455.69	455.69	455.41	455.43	3241.0
2023-11-24 06:30:00	SPY	ETF	455.45	455.56	455.4	455.56	1858.0
2023-11-24 07:00:00	SPY	ETF	455.57	455.79	455.57	455.7	10765.0
2023-11-24 07:30:00	SPY	ETF	455.69	455.75	455.53	455.62	12880.0
2023-11-24 08:00:00	SPY	ETF	455.63	455.78	455.05	455.26	65682.0
2023-11-24 08:30:00	SPY	ETF	455.25	455.48	455.12	455.4	68033.0
2023-11-24 09:00:00	SPY	ETF	455.41	455.44	455.01	455.04	50114.0
2023-11-24 09:30:00	SPY	ETF	455.07	455.382	454.73	455.2501	2802992.0
2023-11-24 10:00:00	SPY	ETF	455.26	455.5	454.79	454.98	1964325.0
2023-11-24 10:30:00	SPY	ETF	454.99	455.2281	454.73	455.13	1756820.0
2023-11-24 11:00:00	SPY	ETF	455.14	455.24	454.895	455.045	1444754.0
2023-11-24 11:30:00	SPY	ETF	455.05	455.13	454.88	454.95	1285007.0
2023-11-24 12:00:00	SPY	ETF	454.96	455.135	454.85	454.86	1545839.0
2023-11-24 12:30:00	SPY	ETF	454.86	455.33	454.82	455.26	3365553.0
2023-11-24 13:00:00	SPY	ETF	455.26	455.6	454.985	455.0	1356241.0
2023-11-24 13:30:00	SPY	ETF	454.97	455.3	454.87	455.03	1079568.0
2023-11-24 14:00:00	SPY	ETF	455.0	455.05	454.92	455.0	49088.0
2023-11-24 14:30:00	SPY	ETF	455.09	455.32	455.09	455.3	37844.0
2023-11-24 15:00:00	SPY	ETF	455.3	455.44	455.3	455.4299	18057.0
2023-11-24 15:30:00	SPY	ETF	455.44	455.59	455.28	455.5	13839.0
2023-11-24 16:00:00	SPY	ETF	455.4	455.46	455.1	455.46	16021.0
2023-11-24 16:30:00	SPY	ETF	455.4	455.4	455.32	455.4	658.0
2023-11-24 04:00:00	QQQ	ETF	389.99	390.6	389.99	390.6	17571.0
2023-11-24 04:30:00	QQQ	ETF	390.54	390.66	390.28	390.28	9176.0
2023-11-24 05:00:00	QQQ	ETF	390.29	390.29	389.94	389.95	39974.0
2023-11-24 05:30:00	QQQ	ETF	389.85	390.2	389.67	390.18	15170.0
2023-11-24 06:00:00	QQQ	ETF	390.12	390.16	389.62	389.8	10450.0
2023-11-24 06:30:00	QQQ	ETF	389.82	389.89	389.76	389.82	9367.0
2023-11-24 07:00:00	QQQ	ETF	389.88	390.11	389.84	389.98	27265.0
2023-11-24 07:30:00	QQQ	ETF	389.83	390.03	389.79	389.84	20641.0
2023-11-24 08:00:00	QQQ	ETF	389.8701	390.47	389.62	389.83	66932.0
2023-11-24 08:30:00	QQQ	ETF	389.82	390.24	389.66	390.2	59768.0
2023-11-24 09:00:00	QQQ	ETF	390.14	390.2	389.58	389.61	93089.0
2023-11-24 09:30:00	QQQ	ETF	389.64	390.25	389.0	389.6087	2611159.0
2023-11-24 10:00:00	QQQ	ETF	389.61	389.86	388.72	388.835	1976925.0
2023-11-24 10:30:00	QQQ	ETF	388.84	389.215	388.5	389.015	1493846.0
2023-11-24 11:00:00	QQQ	ETF	389.02	389.26	388.85	389.1699	1034434.0
2023-11-24 11:30:00	QQQ	ETF	389.1586	389.54	388.95	389.395	1015598.0
2023-11-24 12:00:00	QQQ	ETF	389.39	389.51	389.2	389.3001	812245.0
2023-11-24 12:30:00	QQQ	ETF	389.3	389.51	389.05	389.5	2137263.0
2023-11-24 13:00:00	QQQ	ETF	389.5	389.5575	389.22	389.39	746344.0
2023-11-24 13:30:00	QQQ	ETF	389.38	389.38	389.11	389.2	31037.0
2023-11-24 14:00:00	QQQ	ETF	389.14	389.28	389.1	389.21	29913.0
2023-11-24 14:30:00	QQQ	ETF	389.21	389.3099	389.11	389.25	5058.0
2023-11-24 15:00:00	QQQ	ETF	389.2501	389.29	389.22	389.29	2626.0
2023-11-24 15:30:00	QQQ	ETF	389.29	389.3	389.21	389.3	5025.0

> showing 50 of 16,464 rows — these rows as CSV

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