PREVIEW / etf_30min / 2021-08-18

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-18.parquet
  size:    609 KB
  rows:    22,854

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-08-18 04:00:00	SPY	ETF	443.45	443.91	443.42	443.42	11635.0
2021-08-18 04:30:00	SPY	ETF	443.42	443.57	443.34	443.53	3951.0
2021-08-18 05:00:00	SPY	ETF	443.48	443.7	443.42	443.66	2296.0
2021-08-18 05:30:00	SPY	ETF	443.57	443.57	443.35	443.35	1800.0
2021-08-18 06:00:00	SPY	ETF	443.38	443.41	443.23	443.28	3854.0
2021-08-18 06:30:00	SPY	ETF	443.43	443.99	443.43	443.91	13020.0
2021-08-18 07:00:00	SPY	ETF	443.91	444.0	443.57	443.58	24435.0
2021-08-18 07:30:00	SPY	ETF	443.56	443.69	443.5	443.62	27007.0
2021-08-18 08:00:00	SPY	ETF	443.66	444.373	443.4	443.4	91573.0
2021-08-18 08:30:00	SPY	ETF	443.4	443.62	443.13	443.22	72610.0
2021-08-18 09:00:00	SPY	ETF	443.24	443.3	442.79	442.93	152480.0
2021-08-18 09:30:00	SPY	ETF	442.96	444.115	442.67	444.0801	4533229.0
2021-08-18 10:00:00	SPY	ETF	444.09	444.625	443.841	444.19	4138984.0
2021-08-18 10:30:00	SPY	ETF	444.19	444.5	443.63	443.795	3282845.0
2021-08-18 11:00:00	SPY	ETF	443.7901	443.8399	443.255	443.59	3179094.0
2021-08-18 11:30:00	SPY	ETF	443.58	443.75	443.14	443.3617	2429892.0
2021-08-18 12:00:00	SPY	ETF	443.37	443.7	442.9604	442.995	1698839.0
2021-08-18 12:30:00	SPY	ETF	442.99	443.38	442.99	443.3723	1342875.0
2021-08-18 13:00:00	SPY	ETF	443.38	443.38	442.8715	443.045	1455596.0
2021-08-18 13:30:00	SPY	ETF	443.045	443.44	443.02	443.32	1309003.0
2021-08-18 14:00:00	SPY	ETF	443.32	444.19	441.7	443.2399	6974469.0
2021-08-18 14:30:00	SPY	ETF	443.24	443.57	442.46	442.86	4919109.0
2021-08-18 15:00:00	SPY	ETF	442.85	442.85	441.5	441.55	4663318.0
2021-08-18 15:30:00	SPY	ETF	441.55	441.55	438.92	439.21	19478231.0
2021-08-18 16:00:00	SPY	ETF	439.22	439.43	438.6	438.72	4821285.0
2021-08-18 16:30:00	SPY	ETF	438.7	439.18	437.87	438.59	701016.0
2021-08-18 17:00:00	SPY	ETF	438.61	439.18	438.55	438.66	152293.0
2021-08-18 17:30:00	SPY	ETF	438.74	439.18	438.6	438.68	947441.0
2021-08-18 18:00:00	SPY	ETF	438.68	439.05	438.63	439.01	88953.0
2021-08-18 18:30:00	SPY	ETF	439.18	439.18	438.95	439.0	241692.0
2021-08-18 19:00:00	SPY	ETF	439.0	439.03	438.74	438.75	55136.0
2021-08-18 19:30:00	SPY	ETF	438.75	438.96	438.62	438.81	83453.0
2021-08-18 04:00:00	QQQ	ETF	365.41	365.78	365.21	365.34	17424.0
2021-08-18 04:30:00	QQQ	ETF	365.38	365.54	365.24	365.42	5994.0
2021-08-18 05:00:00	QQQ	ETF	365.39	365.8	365.39	365.65	5800.0
2021-08-18 05:30:00	QQQ	ETF	365.6	365.74	365.5	365.53	5925.0
2021-08-18 06:00:00	QQQ	ETF	365.44	365.45	365.41	365.41	900.0
2021-08-18 06:30:00	QQQ	ETF	365.63	366.37	365.63	366.19	27520.0
2021-08-18 07:00:00	QQQ	ETF	366.14	366.36	365.99	366.05	22366.0
2021-08-18 07:30:00	QQQ	ETF	366.05	366.05	365.78	365.79	88460.0
2021-08-18 08:00:00	QQQ	ETF	366.35	366.35	365.5	365.57	114409.0
2021-08-18 08:30:00	QQQ	ETF	365.59	365.59	365.11	365.23	78134.0
2021-08-18 09:00:00	QQQ	ETF	365.2	365.37	364.94	365.11	83166.0
2021-08-18 09:30:00	QQQ	ETF	365.18	366.6	364.86	366.285	3716495.0
2021-08-18 10:00:00	QQQ	ETF	366.29	366.62	365.66	366.1554	2025399.0
2021-08-18 10:30:00	QQQ	ETF	366.17	366.37	365.3599	365.715	1379275.0
2021-08-18 11:00:00	QQQ	ETF	365.72	365.77	365.05	365.31	1583680.0
2021-08-18 11:30:00	QQQ	ETF	365.31	365.54	364.69	365.1801	1250628.0
2021-08-18 12:00:00	QQQ	ETF	365.2	365.6	365.01	365.19	827515.0
2021-08-18 12:30:00	QQQ	ETF	365.24	365.615	365.24	365.44	609093.0

> showing 50 of 22,854 rows — these rows as CSV

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