PREVIEW / etf_30min / 2023-12-07

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-07.parquet
  size:    753 KB
  rows:    30,031

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-12-07 04:00:00	SPY	ETF	454.47	454.73	454.2	454.65	22851.0
2023-12-07 04:30:00	SPY	ETF	454.66	454.81	454.66	454.78	3535.0
2023-12-07 05:00:00	SPY	ETF	454.92	454.92	454.79	454.79	2390.0
2023-12-07 05:30:00	SPY	ETF	454.75	454.79	454.64	454.79	2570.0
2023-12-07 06:00:00	SPY	ETF	454.89	455.05	454.87	455.05	8333.0
2023-12-07 06:30:00	SPY	ETF	455.07	455.13	454.93	454.99	52341.0
2023-12-07 07:00:00	SPY	ETF	454.99	455.03	454.81	454.96	50786.0
2023-12-07 07:30:00	SPY	ETF	454.97	455.35	454.95	455.33	71824.0
2023-12-07 08:00:00	SPY	ETF	454.9995	455.62	454.4	455.38	393042.0
2023-12-07 08:30:00	SPY	ETF	455.36	456.3	455.14	456.2699	442562.0
2023-12-07 09:00:00	SPY	ETF	456.25	456.93	456.13	456.88	606190.0
2023-12-07 09:30:00	SPY	ETF	456.91	457.23	456.29	456.46	6002190.0
2023-12-07 10:00:00	SPY	ETF	456.46	458.015	456.4	457.96	5093715.0
2023-12-07 10:30:00	SPY	ETF	457.98	458.145	457.59	457.87	3205261.0
2023-12-07 11:00:00	SPY	ETF	457.88	458.05	456.512	457.07	4065918.0
2023-12-07 11:30:00	SPY	ETF	457.07	458.12	457.01	458.08	2776076.0
2023-12-07 12:00:00	SPY	ETF	458.1	458.45	457.645	458.25	3148974.0
2023-12-07 12:30:00	SPY	ETF	458.26	458.36	458.01	458.1385	2233618.0
2023-12-07 13:00:00	SPY	ETF	458.135	458.55	457.945	458.09	2117141.0
2023-12-07 13:30:00	SPY	ETF	458.1	458.4325	457.97	458.31	1482311.0
2023-12-07 14:00:00	SPY	ETF	458.3	458.9	458.22	458.72	2838868.0
2023-12-07 14:30:00	SPY	ETF	458.73	458.76	457.9932	458.03	2536658.0
2023-12-07 15:00:00	SPY	ETF	458.04	458.51	457.93	458.3	2653529.0
2023-12-07 15:30:00	SPY	ETF	458.3	458.47	457.96	458.21	7998543.0
2023-12-07 16:00:00	SPY	ETF	458.2	458.308	456.7175	457.91	2875546.0
2023-12-07 16:30:00	SPY	ETF	457.9	457.9	457.66	457.81	533290.0
2023-12-07 17:00:00	SPY	ETF	457.89	458.23	457.83	457.83	384449.0
2023-12-07 17:30:00	SPY	ETF	457.99	458.03	457.97	458.0	22875.0
2023-12-07 18:00:00	SPY	ETF	458.0	458.05	457.74	457.77	28789.0
2023-12-07 18:30:00	SPY	ETF	457.81	457.83	457.7247	457.8	7845.0
2023-12-07 19:00:00	SPY	ETF	457.81	458.06	457.77	458.02	5596.0
2023-12-07 19:30:00	SPY	ETF	458.02	458.13	457.99	458.05	33005.0
2023-12-07 04:00:00	QQQ	ETF	385.36	385.66	384.96	385.66	22463.0
2023-12-07 04:30:00	QQQ	ETF	385.68	386.1	385.68	385.94	11881.0
2023-12-07 05:00:00	QQQ	ETF	385.95	386.05	385.83	385.93	17631.0
2023-12-07 05:30:00	QQQ	ETF	385.78	386.01	385.71	386.01	15083.0
2023-12-07 06:00:00	QQQ	ETF	385.96	386.13	385.73	386.13	13135.0
2023-12-07 06:30:00	QQQ	ETF	386.11	386.21	386.05	386.09	7603.0
2023-12-07 07:00:00	QQQ	ETF	386.07	386.09	385.79	386.01	115127.0
2023-12-07 07:30:00	QQQ	ETF	386.04	386.28	385.94	386.24	63411.0
2023-12-07 08:00:00	QQQ	ETF	385.97	386.58	384.84	386.58	154890.0
2023-12-07 08:30:00	QQQ	ETF	386.5	387.64	386.0	387.5	236509.0
2023-12-07 09:00:00	QQQ	ETF	387.49	388.19	387.4	388.06	553114.0
2023-12-07 09:30:00	QQQ	ETF	388.06	389.2299	386.96	387.4301	5931984.0
2023-12-07 10:00:00	QQQ	ETF	387.42	389.58	387.36	389.48	3937266.0
2023-12-07 10:30:00	QQQ	ETF	389.48	389.8281	389.22	389.58	2374428.0
2023-12-07 11:00:00	QQQ	ETF	389.59	389.91	388.0	388.93	3648115.0
2023-12-07 11:30:00	QQQ	ETF	388.92	390.32	388.9	390.28	2352436.0
2023-12-07 12:00:00	QQQ	ETF	390.29	391.06	389.89	390.843	3136667.0
2023-12-07 12:30:00	QQQ	ETF	390.85	390.96	390.29	390.47	1746574.0

> showing 50 of 30,031 rows — these rows as CSV

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