PREVIEW / etf_30min / 2024-03-20

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-20.parquet
  size:    801 KB
  rows:    32,286

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-03-20 04:00:00	SPY	ETF	515.52	515.61	515.29	515.38	15230.0
2024-03-20 04:30:00	SPY	ETF	515.42	515.45	515.04	515.3	10784.0
2024-03-20 05:00:00	SPY	ETF	515.31	515.45	515.06	515.42	3419.0
2024-03-20 05:30:00	SPY	ETF	515.44	515.46	515.22	515.44	2529.0
2024-03-20 06:00:00	SPY	ETF	515.48	515.54	515.33	515.35	1960.0
2024-03-20 06:30:00	SPY	ETF	515.56	515.74	515.56	515.73	3743.0
2024-03-20 07:00:00	SPY	ETF	515.71	516.14	515.71	516.14	43035.0
2024-03-20 07:30:00	SPY	ETF	516.06	516.26	516.04	516.16	23696.0
2024-03-20 08:00:00	SPY	ETF	515.7109	516.28	515.17	515.81	72346.0
2024-03-20 08:30:00	SPY	ETF	515.81	515.91	515.25	515.39	45190.0
2024-03-20 09:00:00	SPY	ETF	515.45	515.88	515.37	515.77	77587.0
2024-03-20 09:30:00	SPY	ETF	515.78	515.99	515.21	515.43	3339512.0
2024-03-20 10:00:00	SPY	ETF	515.43	516.4	515.3401	516.35	2173560.0
2024-03-20 10:30:00	SPY	ETF	516.345	516.44	515.55	515.87	1828579.0
2024-03-20 11:00:00	SPY	ETF	515.88	516.32	515.8293	516.21	1573586.0
2024-03-20 11:30:00	SPY	ETF	516.21	516.34	515.58	515.93	1542020.0
2024-03-20 12:00:00	SPY	ETF	515.91	515.94	515.51	515.75	2302759.0
2024-03-20 12:30:00	SPY	ETF	515.75	516.15	515.3901	516.14	1237316.0
2024-03-20 13:00:00	SPY	ETF	516.14	516.14	515.3	515.425	1407824.0
2024-03-20 13:30:00	SPY	ETF	515.41	515.7	515.08	515.48	1952218.0
2024-03-20 14:00:00	SPY	ETF	515.5	518.4	515.48	517.6302	6647528.0
2024-03-20 14:30:00	SPY	ETF	517.66	519.55	515.8	518.91	7470628.0
2024-03-20 15:00:00	SPY	ETF	518.95	520.51	518.84	520.378	5751848.0
2024-03-20 15:30:00	SPY	ETF	520.38	520.62	519.1	520.42	10872161.0
2024-03-20 16:00:00	SPY	ETF	520.41	521.2	520.17	521.09	3005972.0
2024-03-20 16:30:00	SPY	ETF	521.1	521.4	520.424	521.2	343663.0
2024-03-20 17:00:00	SPY	ETF	521.18	521.18	520.8	520.96	82749.0
2024-03-20 17:30:00	SPY	ETF	520.92	521.04	520.7	520.97	44952.0
2024-03-20 18:00:00	SPY	ETF	521.0	521.42	520.98	521.31	116225.0
2024-03-20 18:30:00	SPY	ETF	521.2901	521.55	521.26	521.52	32437.0
2024-03-20 19:00:00	SPY	ETF	521.48	522.05	521.48	521.9292	76071.0
2024-03-20 19:30:00	SPY	ETF	521.92	522.01	521.8	521.8804	89957.0
2024-03-20 04:00:00	QQQ	ETF	437.74	438.78	437.74	438.32	22660.0
2024-03-20 04:30:00	QQQ	ETF	438.34	438.48	437.76	438.01	23684.0
2024-03-20 05:00:00	QQQ	ETF	438.11	438.34	437.82	438.34	10195.0
2024-03-20 05:30:00	QQQ	ETF	438.3	438.68	438.3	438.68	7944.0
2024-03-20 06:00:00	QQQ	ETF	438.67	438.78	438.36	438.41	12195.0
2024-03-20 06:30:00	QQQ	ETF	438.41	439.14	438.38	439.01	67031.0
2024-03-20 07:00:00	QQQ	ETF	439.0	439.77	438.97	439.75	56772.0
2024-03-20 07:30:00	QQQ	ETF	439.72	440.05	439.62	439.86	32745.0
2024-03-20 08:00:00	QQQ	ETF	439.28	440.059	437.75	439.49	129163.0
2024-03-20 08:30:00	QQQ	ETF	439.49	439.69	438.2	439.31	117167.0
2024-03-20 09:00:00	QQQ	ETF	439.32	439.76	439.08	439.72	156194.0
2024-03-20 09:30:00	QQQ	ETF	439.78	440.16	438.06	438.388	2906905.0
2024-03-20 10:00:00	QQQ	ETF	438.41	439.48	438.21	439.3	1287140.0
2024-03-20 10:30:00	QQQ	ETF	439.29	439.45	438.165	438.47	1080775.0
2024-03-20 11:00:00	QQQ	ETF	438.465	439.21	438.363	439.03	797799.0
2024-03-20 11:30:00	QQQ	ETF	439.01	439.25	438.295	438.89	828638.0
2024-03-20 12:00:00	QQQ	ETF	438.86	439.05	438.26	438.87	1068840.0
2024-03-20 12:30:00	QQQ	ETF	438.88	439.14	438.35	439.14	754034.0

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

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