PREVIEW / etf_30min / 2023-12-18

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-18.parquet
  size:    820 KB
  rows:    31,911

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-18 04:00:00	SPY	ETF	470.61	470.74	470.41	470.74	8964.0
2023-12-18 04:30:00	SPY	ETF	470.76	470.76	470.33	470.63	17577.0
2023-12-18 05:00:00	SPY	ETF	470.61	470.8	470.53	470.7	7081.0
2023-12-18 05:30:00	SPY	ETF	470.78	470.88	470.46	470.52	2059.0
2023-12-18 06:00:00	SPY	ETF	470.47	470.74	470.45	470.45	3595.0
2023-12-18 06:30:00	SPY	ETF	470.33	470.36	470.12	470.24	13819.0
2023-12-18 07:00:00	SPY	ETF	470.24	470.7	470.24	470.59	61126.0
2023-12-18 07:30:00	SPY	ETF	470.6	470.75	470.45	470.75	19454.0
2023-12-18 08:00:00	SPY	ETF	470.2697	470.97	470.01	470.79	148058.0
2023-12-18 08:30:00	SPY	ETF	470.75	471.15	470.55	471.01	130334.0
2023-12-18 09:00:00	SPY	ETF	471.0	471.07	470.64	470.99	246991.0
2023-12-18 09:30:00	SPY	ETF	470.99	471.43	470.8	471.37	4747345.0
2023-12-18 10:00:00	SPY	ETF	471.375	471.88	471.34	471.79	3904783.0
2023-12-18 10:30:00	SPY	ETF	471.8	471.86	471.08	471.27	3171530.0
2023-12-18 11:00:00	SPY	ETF	471.27	472.09	471.105	471.98	3194762.0
2023-12-18 11:30:00	SPY	ETF	471.99	472.17	471.91	471.99	2379809.0
2023-12-18 12:00:00	SPY	ETF	472.0	472.65	472.0	472.485	2431733.0
2023-12-18 12:30:00	SPY	ETF	472.5	472.56	472.21	472.425	1864173.0
2023-12-18 13:00:00	SPY	ETF	472.425	472.56	472.11	472.525	1715740.0
2023-12-18 13:30:00	SPY	ETF	472.53	472.62	472.28	472.49	1724900.0
2023-12-18 14:00:00	SPY	ETF	472.49	472.98	472.365	472.48	3245769.0
2023-12-18 14:30:00	SPY	ETF	472.49	472.74	472.205	472.54	2884645.0
2023-12-18 15:00:00	SPY	ETF	472.555	472.81	472.38	472.71	2915038.0
2023-12-18 15:30:00	SPY	ETF	472.72	472.725	471.95	472.02	8057204.0
2023-12-18 16:00:00	SPY	ETF	472.02	472.3809	471.58	471.78	9863330.0
2023-12-18 16:30:00	SPY	ETF	471.79	471.97	471.66	471.97	1375715.0
2023-12-18 17:00:00	SPY	ETF	471.97	471.97	471.65	471.71	767909.0
2023-12-18 17:30:00	SPY	ETF	471.73	472.02	471.65	471.67	86730.0
2023-12-18 18:00:00	SPY	ETF	471.73	471.78	471.65	471.75	13568.0
2023-12-18 18:30:00	SPY	ETF	471.79	472.02	471.73	471.79	84322.0
2023-12-18 19:00:00	SPY	ETF	471.79	471.8003	471.7	471.8003	8293.0
2023-12-18 19:30:00	SPY	ETF	471.7804	471.8404	471.76	471.79	20605.0
2023-12-18 04:00:00	QQQ	ETF	404.76	405.08	404.7	405.06	16782.0
2023-12-18 04:30:00	QQQ	ETF	405.0	405.0	404.77	404.82	6287.0
2023-12-18 05:00:00	QQQ	ETF	404.77	405.0	404.77	404.89	3927.0
2023-12-18 05:30:00	QQQ	ETF	404.97	405.01	404.64	404.67	25735.0
2023-12-18 06:00:00	QQQ	ETF	404.56	404.69	404.47	404.47	19945.0
2023-12-18 06:30:00	QQQ	ETF	404.45	404.45	404.14	404.27	15728.0
2023-12-18 07:00:00	QQQ	ETF	404.29	404.75	404.21	404.63	29236.0
2023-12-18 07:30:00	QQQ	ETF	404.6	404.77	404.4	404.75	18727.0
2023-12-18 08:00:00	QQQ	ETF	404.71	405.15	404.03	404.84	97356.0
2023-12-18 08:30:00	QQQ	ETF	404.84	405.08	404.5317	405.08	131102.0
2023-12-18 09:00:00	QQQ	ETF	405.1	405.14	404.64	404.9	247839.0
2023-12-18 09:30:00	QQQ	ETF	404.93	405.81	404.6	405.71	3504494.0
2023-12-18 10:00:00	QQQ	ETF	405.71	406.34	405.56	406.26	2702429.0
2023-12-18 10:30:00	QQQ	ETF	406.27	406.315	405.39	405.465	1610244.0
2023-12-18 11:00:00	QQQ	ETF	405.46	406.26	405.145	406.1988	1699417.0
2023-12-18 11:30:00	QQQ	ETF	406.2	406.55	406.19	406.32	1620826.0
2023-12-18 12:00:00	QQQ	ETF	406.33	407.1	406.325	406.881	1409523.0
2023-12-18 12:30:00	QQQ	ETF	406.89	407.08	406.74	406.97	871144.0

> showing 50 of 31,911 rows — these rows as CSV

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