PREVIEW / etf_30min / 2024-08-27

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-27.parquet
  size:    827 KB
  rows:    32,439

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-27 04:00:00	SPY	ETF	561.03	561.62	561.0	561.31	11366.0
2024-08-27 04:30:00	SPY	ETF	561.42	561.6	561.3	561.3	2432.0
2024-08-27 05:00:00	SPY	ETF	561.28	561.65	561.28	561.44	3871.0
2024-08-27 05:30:00	SPY	ETF	561.47	561.48	561.32	561.32	1146.0
2024-08-27 06:00:00	SPY	ETF	561.31	561.31	560.39	560.48	7305.0
2024-08-27 06:30:00	SPY	ETF	560.48	560.62	559.88	560.1	9856.0
2024-08-27 07:00:00	SPY	ETF	560.11	560.57	559.84	560.49	8630.0
2024-08-27 07:30:00	SPY	ETF	560.65	561.11	560.65	560.7	15821.0
2024-08-27 08:00:00	SPY	ETF	560.11	561.05	559.85	560.2	43727.0
2024-08-27 08:30:00	SPY	ETF	560.15	560.15	558.88	559.26	89634.0
2024-08-27 09:00:00	SPY	ETF	559.27	559.58	558.4	559.44	194343.0
2024-08-27 09:30:00	SPY	ETF	559.49	560.22	558.32	559.825	2960200.0
2024-08-27 10:00:00	SPY	ETF	559.84	561.13	559.58	561.075	1870105.0
2024-08-27 10:30:00	SPY	ETF	561.04	561.71	560.875	561.63	1768566.0
2024-08-27 11:00:00	SPY	ETF	561.63	562.05	560.75	560.79	1585518.0
2024-08-27 11:30:00	SPY	ETF	560.78	560.87	559.811	560.68	1238216.0
2024-08-27 12:00:00	SPY	ETF	560.68	561.19	560.395	560.815	849536.0
2024-08-27 12:30:00	SPY	ETF	560.78	561.12	559.85	560.8	894025.0
2024-08-27 13:00:00	SPY	ETF	560.8	561.87	560.755	561.79	749212.0
2024-08-27 13:30:00	SPY	ETF	561.8	562.03	561.38	561.94	878647.0
2024-08-27 14:00:00	SPY	ETF	561.915	562.06	561.51	561.775	866822.0
2024-08-27 14:30:00	SPY	ETF	561.77	561.86	561.36	561.59	799071.0
2024-08-27 15:00:00	SPY	ETF	561.61	561.705	561.15	561.52	1084017.0
2024-08-27 15:30:00	SPY	ETF	561.51	561.85	561.13	561.5318	4634879.0
2024-08-27 16:00:00	SPY	ETF	561.53	561.82	561.39	561.65	1736801.0
2024-08-27 16:30:00	SPY	ETF	561.6204	561.68	561.33	561.39	62048.0
2024-08-27 17:00:00	SPY	ETF	561.51	561.633	561.37	561.58	33670.0
2024-08-27 17:30:00	SPY	ETF	561.56	561.5844	561.4	561.56	24546.0
2024-08-27 18:00:00	SPY	ETF	561.51	561.66	560.41	560.78	51573.0
2024-08-27 18:30:00	SPY	ETF	560.74	560.85	560.64	560.81	9051.0
2024-08-27 19:00:00	SPY	ETF	560.7886	561.0	560.36	560.36	5058.0
2024-08-27 19:30:00	SPY	ETF	560.46	560.81	560.46	560.76	17028.0
2024-08-27 04:00:00	QQQ	ETF	475.09	476.66	475.09	476.46	25117.0
2024-08-27 04:30:00	QQQ	ETF	476.46	476.57	475.99	476.02	5333.0
2024-08-27 05:00:00	QQQ	ETF	476.07	476.69	476.07	476.56	12375.0
2024-08-27 05:30:00	QQQ	ETF	476.37	476.44	476.18	476.39	7022.0
2024-08-27 06:00:00	QQQ	ETF	476.25	476.25	475.09	475.37	12534.0
2024-08-27 06:30:00	QQQ	ETF	475.34	475.53	474.61	475.01	9895.0
2024-08-27 07:00:00	QQQ	ETF	475.05	475.41	474.44	475.4	44621.0
2024-08-27 07:30:00	QQQ	ETF	475.42	475.88	475.39	475.47	50377.0
2024-08-27 08:00:00	QQQ	ETF	475.35	476.6296	474.27	474.72	94632.0
2024-08-27 08:30:00	QQQ	ETF	474.75	474.75	473.24	473.51	146501.0
2024-08-27 09:00:00	QQQ	ETF	473.53	473.79	472.64	473.65	212044.0
2024-08-27 09:30:00	QQQ	ETF	473.69	474.81	471.71	474.13	3246440.0
2024-08-27 10:00:00	QQQ	ETF	474.24	476.39	473.88	476.28	1983658.0
2024-08-27 10:30:00	QQQ	ETF	476.28	477.34	476.1	477.25	2435867.0
2024-08-27 11:00:00	QQQ	ETF	477.25	477.84	476.1766	476.18	1907919.0
2024-08-27 11:30:00	QQQ	ETF	476.17	476.28	475.05	475.83	1421150.0
2024-08-27 12:00:00	QQQ	ETF	475.825	476.56	475.62	476.14	882899.0
2024-08-27 12:30:00	QQQ	ETF	476.14	476.705	475.18	476.16	1058340.0

> showing 50 of 32,439 rows — these rows as CSV

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