PREVIEW / etf_30min / 2023-07-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-27.parquet
  size:    743 KB
  rows:    29,233

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
2023-07-27 04:00:00	SPY	ETF	457.44	458.28	457.27	458.28	40054.0
2023-07-27 04:30:00	SPY	ETF	458.27	458.32	458.01	458.31	16196.0
2023-07-27 05:00:00	SPY	ETF	458.25	458.32	458.1	458.13	8316.0
2023-07-27 05:30:00	SPY	ETF	458.2	458.38	458.2	458.21	3198.0
2023-07-27 06:00:00	SPY	ETF	458.17	458.34	458.17	458.32	12901.0
2023-07-27 06:30:00	SPY	ETF	458.39	458.47	458.16	458.2	22203.0
2023-07-27 07:00:00	SPY	ETF	458.2	458.39	458.08	458.35	70459.0
2023-07-27 07:30:00	SPY	ETF	458.35	458.73	458.35	458.65	59622.0
2023-07-27 08:00:00	SPY	ETF	458.09	458.92	456.85	458.8	258446.0
2023-07-27 08:30:00	SPY	ETF	458.78	459.55	458.63	459.04	517140.0
2023-07-27 09:00:00	SPY	ETF	459.03	459.27	458.88	459.02	319564.0
2023-07-27 09:30:00	SPY	ETF	459.02	459.44	458.66	458.9779	5983685.0
2023-07-27 10:00:00	SPY	ETF	458.97	459.05	457.61	457.7	4825221.0
2023-07-27 10:30:00	SPY	ETF	457.7	458.4512	457.27	457.4799	3438817.0
2023-07-27 11:00:00	SPY	ETF	457.48	457.81	457.065	457.7079	2746327.0
2023-07-27 11:30:00	SPY	ETF	457.705	458.01	457.21	457.45	2129390.0
2023-07-27 12:00:00	SPY	ETF	457.45	458.41	457.39	458.3801	2282525.0
2023-07-27 12:30:00	SPY	ETF	458.39	458.5995	458.15	458.384	2600178.0
2023-07-27 13:00:00	SPY	ETF	458.39	458.59	456.26	456.3	5169704.0
2023-07-27 13:30:00	SPY	ETF	456.31	456.44	455.7	456.04	4600933.0
2023-07-27 14:00:00	SPY	ETF	456.04	456.22	453.835	453.935	6280756.0
2023-07-27 14:30:00	SPY	ETF	453.935	454.31	452.73	452.73	6966383.0
2023-07-27 15:00:00	SPY	ETF	452.73	453.87	452.41	452.74	5215453.0
2023-07-27 15:30:00	SPY	ETF	452.74	453.14	451.55	452.48	13196554.0
2023-07-27 16:00:00	SPY	ETF	452.47	454.0105	452.4	452.95	3796639.0
2023-07-27 16:30:00	SPY	ETF	452.91	453.07	452.86	452.91	117782.0
2023-07-27 17:00:00	SPY	ETF	452.96	452.9802	452.82	452.93	30571.0
2023-07-27 17:30:00	SPY	ETF	452.91	452.91	452.83	452.9	15917.0
2023-07-27 18:00:00	SPY	ETF	452.86	452.95	452.7	452.88	40939.0
2023-07-27 18:30:00	SPY	ETF	452.879	452.94	452.82	452.88	16151.0
2023-07-27 19:00:00	SPY	ETF	452.95	453.0	452.8	452.9	6682.0
2023-07-27 19:30:00	SPY	ETF	452.9	452.9	452.65	452.79	27364.0
2023-07-27 04:00:00	QQQ	ETF	381.11	382.13	380.05	382.08	63379.0
2023-07-27 04:30:00	QQQ	ETF	382.05	382.34	381.78	382.32	32855.0
2023-07-27 05:00:00	QQQ	ETF	382.28	382.28	381.86	382.14	36745.0
2023-07-27 05:30:00	QQQ	ETF	382.14	382.42	382.08	382.24	28268.0
2023-07-27 06:00:00	QQQ	ETF	382.24	382.28	382.03	382.28	14081.0
2023-07-27 06:30:00	QQQ	ETF	382.27	382.39	382.14	382.23	28844.0
2023-07-27 07:00:00	QQQ	ETF	382.18	382.31	382.02	382.14	50665.0
2023-07-27 07:30:00	QQQ	ETF	382.15	382.63	382.15	382.55	128223.0
2023-07-27 08:00:00	QQQ	ETF	382.1811	383.08	377.803	382.94	234473.0
2023-07-27 08:30:00	QQQ	ETF	382.92	383.26	382.43	382.73	439488.0
2023-07-27 09:00:00	QQQ	ETF	382.7	383.21	382.6	383.03	368897.0
2023-07-27 09:30:00	QQQ	ETF	383.07	384.71	382.7769	383.905	6769748.0
2023-07-27 10:00:00	QQQ	ETF	383.9	384.235	381.49	381.51	4134010.0
2023-07-27 10:30:00	QQQ	ETF	381.55	383.05	381.31	381.545	3054191.0
2023-07-27 11:00:00	QQQ	ETF	381.56	382.8	381.53	382.8	1819828.0
2023-07-27 11:30:00	QQQ	ETF	382.8	383.23	381.77	382.0001	2046527.0
2023-07-27 12:00:00	QQQ	ETF	382.01	383.468	381.96	383.4197	1626982.0
2023-07-27 12:30:00	QQQ	ETF	383.425	383.57	382.71	383.04	1271981.0

> showing 50 of 29,233 rows — these rows as CSV

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