PREVIEW / etf_30min / 2024-10-14

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-14.parquet
  size:    835 KB
  rows:    33,551

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-10-14 04:00:00	SPY	ETF	579.34	580.17	579.3	580.11	39946.0
2024-10-14 04:30:00	SPY	ETF	580.01	580.12	579.86	579.86	13617.0
2024-10-14 05:00:00	SPY	ETF	579.96	580.28	579.95	580.22	6729.0
2024-10-14 05:30:00	SPY	ETF	580.2	580.39	580.2	580.29	32211.0
2024-10-14 06:00:00	SPY	ETF	580.29	580.93	580.29	580.65	57793.0
2024-10-14 06:30:00	SPY	ETF	580.75	580.82	580.5	580.5	19718.0
2024-10-14 07:00:00	SPY	ETF	580.5	580.53	580.16	580.29	106147.0
2024-10-14 07:30:00	SPY	ETF	580.29	580.57	580.29	580.49	34167.0
2024-10-14 08:00:00	SPY	ETF	580.44	580.71	579.2	580.57	215724.0
2024-10-14 08:30:00	SPY	ETF	580.57	580.94	580.52	580.92	96200.0
2024-10-14 09:00:00	SPY	ETF	580.91	581.35	580.9	581.2	162597.0
2024-10-14 09:30:00	SPY	ETF	581.22	583.3	580.73	583.3	3411346.0
2024-10-14 10:00:00	SPY	ETF	583.3	583.6099	582.61	583.43	1629403.0
2024-10-14 10:30:00	SPY	ETF	583.43	583.78	582.68	582.8305	1530695.0
2024-10-14 11:00:00	SPY	ETF	582.83	583.38	582.3	582.7848	1435023.0
2024-10-14 11:30:00	SPY	ETF	582.8	583.46	582.54	583.45	775224.0
2024-10-14 12:00:00	SPY	ETF	583.45	583.9	583.4	583.7299	906132.0
2024-10-14 12:30:00	SPY	ETF	583.72	583.96	583.71	583.8001	767381.0
2024-10-14 13:00:00	SPY	ETF	583.8	584.14	583.6	583.7799	697051.0
2024-10-14 13:30:00	SPY	ETF	583.77	583.785	583.52	583.6	482577.0
2024-10-14 14:00:00	SPY	ETF	583.6	584.19	583.31	584.04	1064910.0
2024-10-14 14:30:00	SPY	ETF	584.04	584.64	584.025	584.26	1329498.0
2024-10-14 15:00:00	SPY	ETF	584.26	584.545	584.0	584.54	1334442.0
2024-10-14 15:30:00	SPY	ETF	584.53	585.27	584.07	584.28	6545587.0
2024-10-14 16:00:00	SPY	ETF	584.28	584.53	584.07	584.24	1723963.0
2024-10-14 16:30:00	SPY	ETF	584.2115	584.86	584.15	584.73	250214.0
2024-10-14 17:00:00	SPY	ETF	584.74	584.79	584.32	584.59	136209.0
2024-10-14 17:30:00	SPY	ETF	584.59	584.64	584.42	584.54	25086.0
2024-10-14 18:00:00	SPY	ETF	584.54	584.85	584.52	584.59	34518.0
2024-10-14 18:30:00	SPY	ETF	584.65	584.65	584.44	584.58	11560.0
2024-10-14 19:00:00	SPY	ETF	584.59	584.69	584.52	584.65	7851.0
2024-10-14 19:30:00	SPY	ETF	584.72	584.79	584.63	584.71	30150.0
2024-10-14 04:00:00	QQQ	ETF	493.64	494.2	493.56	494.04	40293.0
2024-10-14 04:30:00	QQQ	ETF	494.02	494.06	493.71	493.81	20673.0
2024-10-14 05:00:00	QQQ	ETF	493.76	494.22	493.76	494.15	12493.0
2024-10-14 05:30:00	QQQ	ETF	494.08	494.33	494.08	494.25	16501.0
2024-10-14 06:00:00	QQQ	ETF	494.31	495.14	494.31	494.85	19383.0
2024-10-14 06:30:00	QQQ	ETF	494.88	495.15	494.76	494.83	14639.0
2024-10-14 07:00:00	QQQ	ETF	494.79	494.79	494.5	494.526	69741.0
2024-10-14 07:30:00	QQQ	ETF	494.55	494.97	494.53	494.76	34564.0
2024-10-14 08:00:00	QQQ	ETF	494.57	495.01	492.32	494.93	89651.0
2024-10-14 08:30:00	QQQ	ETF	494.96	495.57	494.87	495.57	139148.0
2024-10-14 09:00:00	QQQ	ETF	495.58	496.14	495.58	495.83	143880.0
2024-10-14 09:30:00	QQQ	ETF	495.76	498.62	495.54	498.62	2803244.0
2024-10-14 10:00:00	QQQ	ETF	498.63	498.83	496.775	497.97	1798623.0
2024-10-14 10:30:00	QQQ	ETF	497.965	498.12	495.84	496.1099	1804281.0
2024-10-14 11:00:00	QQQ	ETF	496.14	496.69	495.28	495.759	1973134.0
2024-10-14 11:30:00	QQQ	ETF	495.76	496.65	495.26	496.64	680987.0
2024-10-14 12:00:00	QQQ	ETF	496.63	497.18	496.48	497.1	667786.0
2024-10-14 12:30:00	QQQ	ETF	497.1	497.41	496.94	497.065	528494.0

> showing 50 of 33,551 rows — these rows as CSV

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