PREVIEW / etf_30min / 2024-01-17

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-17.parquet
  size:    804 KB
  rows:    31,738

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
2024-01-17 04:00:00	SPY	ETF	472.6	472.87	472.11	472.61	25757.0
2024-01-17 04:30:00	SPY	ETF	472.78	473.02	472.77	472.97	13963.0
2024-01-17 05:00:00	SPY	ETF	473.01	473.12	472.77	472.77	7351.0
2024-01-17 05:30:00	SPY	ETF	472.76	472.85	472.58	472.85	7300.0
2024-01-17 06:00:00	SPY	ETF	472.65	472.74	472.5	472.71	4851.0
2024-01-17 06:30:00	SPY	ETF	472.94	473.2	472.9	473.11	19145.0
2024-01-17 07:00:00	SPY	ETF	473.19	473.67	473.05	473.5	144290.0
2024-01-17 07:30:00	SPY	ETF	473.48	473.58	473.2	473.26	91998.0
2024-01-17 08:00:00	SPY	ETF	473.4601	473.82	472.46	472.86	210942.0
2024-01-17 08:30:00	SPY	ETF	472.85	474.77	471.8	471.97	368339.0
2024-01-17 09:00:00	SPY	ETF	471.99	472.35	471.73	471.82	309707.0
2024-01-17 09:30:00	SPY	ETF	471.82	471.94	471.05	471.325	7165845.0
2024-01-17 10:00:00	SPY	ETF	471.32	472.26	471.05	471.84	5135784.0
2024-01-17 10:30:00	SPY	ETF	471.82	472.36	471.5	472.02	3386055.0
2024-01-17 11:00:00	SPY	ETF	472.02	472.78	472.0	472.5	3307004.0
2024-01-17 11:30:00	SPY	ETF	472.505	472.79	472.13	472.1789	2342246.0
2024-01-17 12:00:00	SPY	ETF	472.18	472.3	471.4098	471.52	2587853.0
2024-01-17 12:30:00	SPY	ETF	471.53	471.935	471.12	471.68	2824696.0
2024-01-17 13:00:00	SPY	ETF	471.68	472.04	470.45	470.69	2845752.0
2024-01-17 13:30:00	SPY	ETF	470.69	470.77	469.87	470.6602	3855929.0
2024-01-17 14:00:00	SPY	ETF	470.6699	471.4	470.52	471.215	2909472.0
2024-01-17 14:30:00	SPY	ETF	471.22	471.765	471.19	471.47	2994058.0
2024-01-17 15:00:00	SPY	ETF	471.47	471.55	470.67	470.8789	3275975.0
2024-01-17 15:30:00	SPY	ETF	470.88	472.61	470.83	472.275	8653938.0
2024-01-17 16:00:00	SPY	ETF	472.27	472.39	471.2009	472.11	2193148.0
2024-01-17 16:30:00	SPY	ETF	472.1	472.19	472.05	472.13	387732.0
2024-01-17 17:00:00	SPY	ETF	472.09	472.19	472.05	472.14	23568.0
2024-01-17 17:30:00	SPY	ETF	472.15	472.18	472.01	472.03	6692.0
2024-01-17 18:00:00	SPY	ETF	472.03	472.24	471.75	472.22	41717.0
2024-01-17 18:30:00	SPY	ETF	472.25	472.25	472.11	472.2	31227.0
2024-01-17 19:00:00	SPY	ETF	472.15	472.25	471.95	472.08	9556.0
2024-01-17 19:30:00	SPY	ETF	472.06	472.32	472.06	472.32	35952.0
2024-01-17 04:00:00	QQQ	ETF	407.36	407.4	406.02	406.62	83324.0
2024-01-17 04:30:00	QQQ	ETF	406.79	407.33	406.74	407.27	15126.0
2024-01-17 05:00:00	QQQ	ETF	407.26	407.51	407.15	407.15	15952.0
2024-01-17 05:30:00	QQQ	ETF	407.16	407.29	406.89	407.29	13603.0
2024-01-17 06:00:00	QQQ	ETF	407.29	407.44	406.89	407.24	33351.0
2024-01-17 06:30:00	QQQ	ETF	407.22	407.92	407.22	407.68	25177.0
2024-01-17 07:00:00	QQQ	ETF	407.78	408.16	407.57	408.01	51928.0
2024-01-17 07:30:00	QQQ	ETF	407.96	408.0	407.591	407.73	40547.0
2024-01-17 08:00:00	QQQ	ETF	407.8086	409.213	406.08	407.34	377795.0
2024-01-17 08:30:00	QQQ	ETF	407.2	407.2	405.72	406.05	274208.0
2024-01-17 09:00:00	QQQ	ETF	406.03	406.58	405.82	406.16	275594.0
2024-01-17 09:30:00	QQQ	ETF	406.17	406.61	403.27	403.36	7952483.0
2024-01-17 10:00:00	QQQ	ETF	403.35	404.71	402.92	404.41	4638218.0
2024-01-17 10:30:00	QQQ	ETF	404.4	405.28	403.86	404.88	3460893.0
2024-01-17 11:00:00	QQQ	ETF	404.86	406.2678	404.84	406.02	2886834.0
2024-01-17 11:30:00	QQQ	ETF	406.03	406.565	405.64	405.83	2202142.0
2024-01-17 12:00:00	QQQ	ETF	405.84	406.1499	405.1399	405.31	1684299.0
2024-01-17 12:30:00	QQQ	ETF	405.3299	405.97	404.93	405.78	1385451.0

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

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