PREVIEW / etf_30min / 2024-08-30

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-30.parquet
  size:    800 KB
  rows:    31,986

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-08-30 04:00:00	SPY	ETF	560.76	561.09	560.71	560.98	7530.0
2024-08-30 04:30:00	SPY	ETF	560.99	560.99	560.85	560.87	1100.0
2024-08-30 05:00:00	SPY	ETF	561.0	561.0	560.8	560.87	1800.0
2024-08-30 05:30:00	SPY	ETF	560.72	560.96	560.71	560.96	2457.0
2024-08-30 06:00:00	SPY	ETF	561.0	561.0	560.68	560.75	2484.0
2024-08-30 06:30:00	SPY	ETF	560.75	561.31	560.35	561.31	6799.0
2024-08-30 07:00:00	SPY	ETF	561.28	561.34	560.94	561.04	86483.0
2024-08-30 07:30:00	SPY	ETF	561.13	561.22	560.58	560.95	20893.0
2024-08-30 08:00:00	SPY	ETF	561.3	561.51	559.39	561.35	85787.0
2024-08-30 08:30:00	SPY	ETF	561.3	561.62	560.24	560.39	122698.0
2024-08-30 09:00:00	SPY	ETF	560.44	561.03	560.25	560.78	104300.0
2024-08-30 09:30:00	SPY	ETF	560.78	561.9295	560.41	561.7219	3268821.0
2024-08-30 10:00:00	SPY	ETF	561.73	562.25	560.62	561.28	1774272.0
2024-08-30 10:30:00	SPY	ETF	561.28	562.17	559.96	559.98	1763638.0
2024-08-30 11:00:00	SPY	ETF	559.995	560.5	559.07	559.19	1632854.0
2024-08-30 11:30:00	SPY	ETF	559.18	559.4	558.11	559.145	2084695.0
2024-08-30 12:00:00	SPY	ETF	559.13	559.67	558.0	558.11	1533289.0
2024-08-30 12:30:00	SPY	ETF	558.07	559.265	557.14	559.1001	1516534.0
2024-08-30 13:00:00	SPY	ETF	559.1	559.84	558.57	558.91	1142265.0
2024-08-30 13:30:00	SPY	ETF	558.91	559.33	558.7	558.867	699515.0
2024-08-30 14:00:00	SPY	ETF	558.87	560.07	558.6	559.67	1983766.0
2024-08-30 14:30:00	SPY	ETF	559.7	560.9395	559.63	560.7	2588174.0
2024-08-30 15:00:00	SPY	ETF	560.7	561.96	560.155	561.82	3588364.0
2024-08-30 15:30:00	SPY	ETF	561.825	564.2	561.21	563.57	11106627.0
2024-08-30 16:00:00	SPY	ETF	563.55	563.86	563.03	563.65	5806686.0
2024-08-30 16:30:00	SPY	ETF	563.64	563.65	563.31	563.351	85422.0
2024-08-30 17:00:00	SPY	ETF	563.341	563.86	562.6	563.35	3555438.0
2024-08-30 17:30:00	SPY	ETF	563.35	563.61	563.35	563.5996	21744.0
2024-08-30 18:00:00	SPY	ETF	563.55	563.55	563.41	563.42	5252.0
2024-08-30 18:30:00	SPY	ETF	563.42	563.61	563.41	563.5003	7206.0
2024-08-30 19:00:00	SPY	ETF	563.62	563.62	563.45	563.4532	3462.0
2024-08-30 19:30:00	SPY	ETF	563.5	563.6	563.3999	563.45	10531.0
2024-08-30 04:00:00	QQQ	ETF	474.12	474.2	473.73	474.0	28865.0
2024-08-30 04:30:00	QQQ	ETF	474.0	474.35	473.96	474.07	4976.0
2024-08-30 05:00:00	QQQ	ETF	474.02	474.17	473.87	474.09	7033.0
2024-08-30 05:30:00	QQQ	ETF	473.98	474.28	473.93	474.22	15169.0
2024-08-30 06:00:00	QQQ	ETF	474.33	474.33	473.88	473.99	37697.0
2024-08-30 06:30:00	QQQ	ETF	474.02	474.67	473.66	474.67	20175.0
2024-08-30 07:00:00	QQQ	ETF	474.71	474.73	474.38	474.41	32315.0
2024-08-30 07:30:00	QQQ	ETF	474.5	474.67	474.0	474.26	87881.0
2024-08-30 08:00:00	QQQ	ETF	474.64	475.28	472.15	474.85	162560.0
2024-08-30 08:30:00	QQQ	ETF	474.83	475.42	473.87	474.25	232912.0
2024-08-30 09:00:00	QQQ	ETF	474.27	475.11	474.0	474.81	114590.0
2024-08-30 09:30:00	QQQ	ETF	475.04	476.12	473.97	475.86	2883357.0
2024-08-30 10:00:00	QQQ	ETF	475.8801	476.73	474.06	474.795	2327482.0
2024-08-30 10:30:00	QQQ	ETF	474.79	476.17	472.83	472.86	2499144.0
2024-08-30 11:00:00	QQQ	ETF	472.84	473.72	472.3	472.81	1847324.0
2024-08-30 11:30:00	QQQ	ETF	472.78	473.09	471.57	472.71	1436914.0
2024-08-30 12:00:00	QQQ	ETF	472.72	473.2	471.52	471.655	1000912.0
2024-08-30 12:30:00	QQQ	ETF	471.69	472.86	470.51	472.74	1431518.0

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

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