PREVIEW / etf_30min / 2021-09-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-22.parquet
  size:    616 KB
  rows:    23,649

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
2021-09-22 04:00:00	SPY	ETF	434.02	435.7	433.02	435.62	16768.0
2021-09-22 04:30:00	SPY	ETF	435.53	436.12	435.53	436.03	22330.0
2021-09-22 05:00:00	SPY	ETF	436.03	436.25	435.96	435.98	8674.0
2021-09-22 05:30:00	SPY	ETF	435.91	436.01	435.51	435.96	32018.0
2021-09-22 06:00:00	SPY	ETF	435.97	436.4	435.97	436.11	82624.0
2021-09-22 06:30:00	SPY	ETF	436.18	436.56	435.97	435.98	95865.0
2021-09-22 07:00:00	SPY	ETF	435.99	436.01	435.67	435.92	74517.0
2021-09-22 07:30:00	SPY	ETF	435.91	436.13	435.88	435.98	94130.0
2021-09-22 08:00:00	SPY	ETF	435.9199	436.5096	433.915	436.2	211489.0
2021-09-22 08:30:00	SPY	ETF	436.19	436.43	436.17	436.27	153351.0
2021-09-22 09:00:00	SPY	ETF	436.35	436.73	435.65	436.08	356356.0
2021-09-22 09:30:00	SPY	ETF	436.05	436.83	435.07	436.83	5957854.0
2021-09-22 10:00:00	SPY	ETF	436.82	437.7283	436.61	437.395	5595791.0
2021-09-22 10:30:00	SPY	ETF	437.39	438.05	437.27	437.955	3773899.0
2021-09-22 11:00:00	SPY	ETF	437.96	438.31	437.93	438.1305	3033118.0
2021-09-22 11:30:00	SPY	ETF	438.14	439.57	438.135	438.94	5303307.0
2021-09-22 12:00:00	SPY	ETF	438.93	439.01	438.5	438.8	2202439.0
2021-09-22 12:30:00	SPY	ETF	438.81	439.03	438.28	438.47	2251397.0
2021-09-22 13:00:00	SPY	ETF	438.46	438.4899	437.8	438.29	2533023.0
2021-09-22 13:30:00	SPY	ETF	438.28	438.45	437.53	438.01	3119309.0
2021-09-22 14:00:00	SPY	ETF	437.98	440.03	436.96	439.465	9856591.0
2021-09-22 14:30:00	SPY	ETF	439.46	439.71	436.6	437.62	10801039.0
2021-09-22 15:00:00	SPY	ETF	437.6296	439.73	437.11	438.99	6680709.0
2021-09-22 15:30:00	SPY	ETF	438.97	439.24	437.54	437.83	14577835.0
2021-09-22 16:00:00	SPY	ETF	437.82	438.33	437.6	437.97	3730175.0
2021-09-22 16:30:00	SPY	ETF	437.97	438.14	437.76	438.05	156799.0
2021-09-22 17:00:00	SPY	ETF	437.94	438.05	437.88	437.96	22036.0
2021-09-22 17:30:00	SPY	ETF	437.96	438.0	437.91	437.97	55362.0
2021-09-22 18:00:00	SPY	ETF	438.0	438.3	437.86	438.15	659084.0
2021-09-22 18:30:00	SPY	ETF	437.86	438.36	437.86	438.31	22373.0
2021-09-22 19:00:00	SPY	ETF	438.38	438.71	438.38	438.6	64002.0
2021-09-22 19:30:00	SPY	ETF	438.5999	438.7	438.25	438.6	17916.0
2021-09-22 04:00:00	QQQ	ETF	366.74	367.36	366.73	367.27	21024.0
2021-09-22 04:30:00	QQQ	ETF	367.36	367.75	367.21	367.61	13870.0
2021-09-22 05:00:00	QQQ	ETF	367.67	367.71	367.41	367.47	14452.0
2021-09-22 05:30:00	QQQ	ETF	367.5	367.5	367.0	367.3	19979.0
2021-09-22 06:00:00	QQQ	ETF	367.38	367.65	367.38	367.5	32780.0
2021-09-22 06:30:00	QQQ	ETF	367.49	367.62	367.34	367.35	12847.0
2021-09-22 07:00:00	QQQ	ETF	367.32	367.35	366.93	367.16	169732.0
2021-09-22 07:30:00	QQQ	ETF	367.121	367.26	367.08	367.21	23480.0
2021-09-22 08:00:00	QQQ	ETF	367.2899	367.69	366.01	367.55	78592.0
2021-09-22 08:30:00	QQQ	ETF	367.55	367.82	367.53	367.63	74441.0
2021-09-22 09:00:00	QQQ	ETF	367.69	368.08	366.99	367.14	328447.0
2021-09-22 09:30:00	QQQ	ETF	367.09	367.46	365.9584	367.455	3945015.0
2021-09-22 10:00:00	QQQ	ETF	367.46	368.78	367.43	368.465	2777592.0
2021-09-22 10:30:00	QQQ	ETF	368.46	368.94	368.29	368.7	2030865.0
2021-09-22 11:00:00	QQQ	ETF	368.71	369.17	368.71	369.0	1186928.0
2021-09-22 11:30:00	QQQ	ETF	369.0	370.51	369.0	369.88	2230986.0
2021-09-22 12:00:00	QQQ	ETF	369.89	369.9181	369.3754	369.735	1053875.0
2021-09-22 12:30:00	QQQ	ETF	369.74	369.97	369.14	369.285	1121106.0

> showing 50 of 23,649 rows — these rows as CSV

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