PREVIEW / etf_30min / 2024-05-07

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-07.parquet
  size:    798 KB
  rows:    31,397

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-05-07 04:00:00	SPY	ETF	516.35	516.67	516.2	516.67	3579.0
2024-05-07 04:30:00	SPY	ETF	516.65	517.16	516.65	517.16	10845.0
2024-05-07 05:00:00	SPY	ETF	517.18	517.23	516.95	516.98	3136.0
2024-05-07 05:30:00	SPY	ETF	516.79	516.86	516.75	516.8	2882.0
2024-05-07 06:00:00	SPY	ETF	516.84	516.95	516.73	516.79	2730.0
2024-05-07 06:30:00	SPY	ETF	516.76	516.98	516.76	516.95	7838.0
2024-05-07 07:00:00	SPY	ETF	516.97	517.0	516.5	516.53	49991.0
2024-05-07 07:30:00	SPY	ETF	516.63	516.65	516.44	516.65	21955.0
2024-05-07 08:00:00	SPY	ETF	516.88	517.2096	516.4	516.66	65349.0
2024-05-07 08:30:00	SPY	ETF	516.69	517.24	516.69	517.24	118148.0
2024-05-07 09:00:00	SPY	ETF	517.2	517.62	517.18	517.55	266099.0
2024-05-07 09:30:00	SPY	ETF	517.55	517.93	517.165	517.18	3873885.0
2024-05-07 10:00:00	SPY	ETF	517.21	517.78	516.945	517.31	2416591.0
2024-05-07 10:30:00	SPY	ETF	517.29	518.24	517.24	518.125	2121964.0
2024-05-07 11:00:00	SPY	ETF	518.13	518.28	517.85	517.98	2214111.0
2024-05-07 11:30:00	SPY	ETF	517.97	518.195	517.69	518.08	1484074.0
2024-05-07 12:00:00	SPY	ETF	518.0888	518.295	517.985	518.17	1076496.0
2024-05-07 12:30:00	SPY	ETF	518.175	518.2	517.5702	517.89	1590663.0
2024-05-07 13:00:00	SPY	ETF	517.895	518.48	517.89	518.4199	1898114.0
2024-05-07 13:30:00	SPY	ETF	518.4101	518.57	516.79	516.99	2660215.0
2024-05-07 14:00:00	SPY	ETF	517.0	517.44	516.7	516.84	2573619.0
2024-05-07 14:30:00	SPY	ETF	516.83	517.085	516.45	517.015	2376055.0
2024-05-07 15:00:00	SPY	ETF	517.02	517.29	516.68	517.17	2119630.0
2024-05-07 15:30:00	SPY	ETF	517.175	517.86	516.98	517.2	9479224.0
2024-05-07 16:00:00	SPY	ETF	517.2	517.5	517.03	517.35	3198276.0
2024-05-07 16:30:00	SPY	ETF	517.33	517.4	517.081	517.09	141643.0
2024-05-07 17:00:00	SPY	ETF	517.14	517.28	517.07	517.1	9487.0
2024-05-07 17:30:00	SPY	ETF	517.09	517.17	517.08	517.14	5806.0
2024-05-07 18:00:00	SPY	ETF	517.08	517.14	516.78	517.1001	151391.0
2024-05-07 18:30:00	SPY	ETF	517.1	517.35	517.1	517.35	19347.0
2024-05-07 19:00:00	SPY	ETF	517.34	517.4499	517.23	517.31	27808.0
2024-05-07 19:30:00	SPY	ETF	517.3	517.41	517.22	517.32	21846.0
2024-05-07 04:00:00	QQQ	ETF	439.6	439.91	439.33	439.86	36504.0
2024-05-07 04:30:00	QQQ	ETF	439.87	440.3	439.83	440.3	10916.0
2024-05-07 05:00:00	QQQ	ETF	440.28	440.39	440.04	440.04	16409.0
2024-05-07 05:30:00	QQQ	ETF	439.9	439.9	439.59	439.83	7782.0
2024-05-07 06:00:00	QQQ	ETF	439.8	439.8	439.61	439.68	7995.0
2024-05-07 06:30:00	QQQ	ETF	439.7	439.9	439.65	439.9	4681.0
2024-05-07 07:00:00	QQQ	ETF	439.96	440.02	439.37	439.51	96852.0
2024-05-07 07:30:00	QQQ	ETF	439.5	439.6	439.26	439.55	55835.0
2024-05-07 08:00:00	QQQ	ETF	439.9	440.58	439.28	439.48	61505.0
2024-05-07 08:30:00	QQQ	ETF	439.51	440.28	439.48	440.21	59709.0
2024-05-07 09:00:00	QQQ	ETF	440.23	440.74	440.15	440.69	163247.0
2024-05-07 09:30:00	QQQ	ETF	440.7	441.2914	440.14	440.25	3308652.0
2024-05-07 10:00:00	QQQ	ETF	440.28	440.9899	439.98	440.15	1809784.0
2024-05-07 10:30:00	QQQ	ETF	440.13	441.65	440.05	441.6294	1640312.0
2024-05-07 11:00:00	QQQ	ETF	441.625	441.92	441.39	441.51	1612412.0
2024-05-07 11:30:00	QQQ	ETF	441.51	441.84	441.24	441.665	915662.0
2024-05-07 12:00:00	QQQ	ETF	441.7	441.94	441.58	441.76	735405.0
2024-05-07 12:30:00	QQQ	ETF	441.76	441.825	441.1	441.35	1420994.0

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

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