PREVIEW / etf_30min / 2024-10-25

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-25.parquet
  size:    839 KB
  rows:    33,240

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-25 04:00:00	SPY	ETF	580.1	580.55	579.85	580.2	11417.0
2024-10-25 04:30:00	SPY	ETF	580.1	580.3	580.1	580.2	1598.0
2024-10-25 05:00:00	SPY	ETF	580.42	580.98	580.42	580.93	6186.0
2024-10-25 05:30:00	SPY	ETF	580.9	580.9	580.67	580.79	5833.0
2024-10-25 06:00:00	SPY	ETF	580.85	581.02	580.84	581.02	6600.0
2024-10-25 06:30:00	SPY	ETF	580.98	581.06	580.7	580.7	13449.0
2024-10-25 07:00:00	SPY	ETF	580.67	580.72	580.19	580.63	99141.0
2024-10-25 07:30:00	SPY	ETF	580.66	581.2	580.66	581.01	61157.0
2024-10-25 08:00:00	SPY	ETF	580.99	581.39	578.99	581.16	74570.0
2024-10-25 08:30:00	SPY	ETF	581.07	581.7	581.05	581.63	62580.0
2024-10-25 09:00:00	SPY	ETF	581.63	581.93	581.45	581.55	132953.0
2024-10-25 09:30:00	SPY	ETF	581.51	583.49	581.47	583.3	3720681.0
2024-10-25 10:00:00	SPY	ETF	583.3	584.46	583.3	584.175	2844332.0
2024-10-25 10:30:00	SPY	ETF	584.21	584.32	582.99	583.46	1755424.0
2024-10-25 11:00:00	SPY	ETF	583.48	583.8404	582.32	582.5	1414514.0
2024-10-25 11:30:00	SPY	ETF	582.48	582.76	581.7032	582.17	1884826.0
2024-10-25 12:00:00	SPY	ETF	582.17	582.72	581.8	582.7	943587.0
2024-10-25 12:30:00	SPY	ETF	582.71	582.8	582.0	582.03	832074.0
2024-10-25 13:00:00	SPY	ETF	582.03	582.05	580.01	580.45	1982647.0
2024-10-25 13:30:00	SPY	ETF	580.44	580.57	578.53	579.1899	2409281.0
2024-10-25 14:00:00	SPY	ETF	579.25	580.05	578.08	579.83	2031353.0
2024-10-25 14:30:00	SPY	ETF	579.84	580.52	579.32	580.2	1096370.0
2024-10-25 15:00:00	SPY	ETF	580.2	580.2599	579.01	579.51	1853326.0
2024-10-25 15:30:00	SPY	ETF	579.5	579.7	578.54	579.015	4994228.0
2024-10-25 16:00:00	SPY	ETF	579.02	579.2	578.6	578.6399	2972747.0
2024-10-25 16:30:00	SPY	ETF	578.61	580.843	578.45	578.58	178641.0
2024-10-25 17:00:00	SPY	ETF	578.67	579.04	578.51	578.74	338450.0
2024-10-25 17:30:00	SPY	ETF	578.75	578.98	578.7	578.73	457399.0
2024-10-25 18:00:00	SPY	ETF	578.73	578.73	578.45	578.64	37935.0
2024-10-25 18:30:00	SPY	ETF	578.67	578.74	578.36	578.5	41936.0
2024-10-25 19:00:00	SPY	ETF	578.5	578.73	578.05	578.05	29321.0
2024-10-25 19:30:00	SPY	ETF	578.0506	578.3	577.55	577.95	37327.0
2024-10-25 04:00:00	QQQ	ETF	493.89	494.0	492.98	493.21	33770.0
2024-10-25 04:30:00	QQQ	ETF	493.21	493.51	493.16	493.39	11620.0
2024-10-25 05:00:00	QQQ	ETF	493.44	494.11	493.44	493.98	13766.0
2024-10-25 05:30:00	QQQ	ETF	493.93	493.97	493.7	493.86	19664.0
2024-10-25 06:00:00	QQQ	ETF	493.85	494.04	493.79	493.89	10182.0
2024-10-25 06:30:00	QQQ	ETF	493.98	494.04	493.64	493.64	15948.0
2024-10-25 07:00:00	QQQ	ETF	493.69	493.7	493.26	493.64	48689.0
2024-10-25 07:30:00	QQQ	ETF	493.64	494.35	493.64	494.08	33471.0
2024-10-25 08:00:00	QQQ	ETF	493.4	494.75	492.18	494.39	96350.0
2024-10-25 08:30:00	QQQ	ETF	494.36	495.23	494.25	495.171	140699.0
2024-10-25 09:00:00	QQQ	ETF	495.21	495.66	495.15	495.1899	157601.0
2024-10-25 09:30:00	QQQ	ETF	495.14	499.1	495.12	498.95	4594791.0
2024-10-25 10:00:00	QQQ	ETF	498.93	500.28	498.711	499.95	3582713.0
2024-10-25 10:30:00	QQQ	ETF	499.96	500.155	498.24	499.09	1709711.0
2024-10-25 11:00:00	QQQ	ETF	499.08	499.57	498.4	498.59	1202798.0
2024-10-25 11:30:00	QQQ	ETF	498.57	499.1	497.8501	498.2825	1699521.0
2024-10-25 12:00:00	QQQ	ETF	498.26	499.23	497.991	499.23	1180210.0
2024-10-25 12:30:00	QQQ	ETF	499.221	499.3	498.66	498.695	587271.0

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

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