PREVIEW / etf_30min / 2021-10-28

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-28.parquet
  size:    620 KB
  rows:    24,045

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-10-28 04:00:00	SPY	ETF	454.53	454.64	454.28	454.46	5694.0
2021-10-28 04:30:00	SPY	ETF	454.5	455.04	454.5	454.87	15994.0
2021-10-28 05:00:00	SPY	ETF	454.87	454.95	454.62	454.67	4281.0
2021-10-28 05:30:00	SPY	ETF	454.6	454.72	454.47	454.67	36474.0
2021-10-28 06:00:00	SPY	ETF	454.69	454.78	454.6	454.76	30926.0
2021-10-28 06:30:00	SPY	ETF	454.89	455.43	454.89	455.43	64103.0
2021-10-28 07:00:00	SPY	ETF	455.37	455.63	455.32	455.46	166368.0
2021-10-28 07:30:00	SPY	ETF	455.45	455.45	455.08	455.15	140193.0
2021-10-28 08:00:00	SPY	ETF	455.42	455.76	454.28	455.39	190460.0
2021-10-28 08:30:00	SPY	ETF	455.37	455.58	455.01	455.37	266254.0
2021-10-28 09:00:00	SPY	ETF	455.37	455.51	455.12	455.48	161613.0
2021-10-28 09:30:00	SPY	ETF	455.46	456.96	455.45	456.76	4724523.0
2021-10-28 10:00:00	SPY	ETF	456.77	457.125	456.0424	457.06	2850344.0
2021-10-28 10:30:00	SPY	ETF	457.07	457.976	457.0	457.47	2868539.0
2021-10-28 11:00:00	SPY	ETF	457.46	457.865	457.4	457.52	1800308.0
2021-10-28 11:30:00	SPY	ETF	457.53	457.95	456.86	457.08	2167776.0
2021-10-28 12:00:00	SPY	ETF	457.08	457.71	457.07	457.305	1344002.0
2021-10-28 12:30:00	SPY	ETF	457.31	457.43	456.5	456.69	1858234.0
2021-10-28 13:00:00	SPY	ETF	456.72	457.14	456.68	457.05	1158236.0
2021-10-28 13:30:00	SPY	ETF	457.06	457.495	457.0525	457.34	1086879.0
2021-10-28 14:00:00	SPY	ETF	457.34	457.87	457.325	457.78	1631950.0
2021-10-28 14:30:00	SPY	ETF	457.785	457.91	457.39	457.5	1093020.0
2021-10-28 15:00:00	SPY	ETF	457.49	457.58	457.0929	457.24	2160452.0
2021-10-28 15:30:00	SPY	ETF	457.23	458.4	457.1	458.26	7986088.0
2021-10-28 16:00:00	SPY	ETF	458.26	458.48	457.61	457.96	3589423.0
2021-10-28 16:30:00	SPY	ETF	457.92	458.32	456.69	457.31	606105.0
2021-10-28 17:00:00	SPY	ETF	457.25	457.61	457.24	457.58	49104.0
2021-10-28 17:30:00	SPY	ETF	457.58	457.71	457.35	457.35	67767.0
2021-10-28 18:00:00	SPY	ETF	457.4	457.48	457.14	457.45	244183.0
2021-10-28 18:30:00	SPY	ETF	458.32	458.32	456.98	457.11	48250.0
2021-10-28 19:00:00	SPY	ETF	457.1	457.1	456.83	456.86	20912.0
2021-10-28 19:30:00	SPY	ETF	456.86	457.08	456.82	457.0	38502.0
2021-10-28 04:00:00	QQQ	ETF	381.14	381.17	380.82	381.04	157157.0
2021-10-28 04:30:00	QQQ	ETF	381.03	381.8	381.03	381.69	120684.0
2021-10-28 05:00:00	QQQ	ETF	381.66	381.7	381.48	381.51	92570.0
2021-10-28 05:30:00	QQQ	ETF	381.51	381.55	381.19	381.4	71166.0
2021-10-28 06:00:00	QQQ	ETF	381.42	381.55	381.35	381.55	85480.0
2021-10-28 06:30:00	QQQ	ETF	381.55	382.03	381.48	381.99	80512.0
2021-10-28 07:00:00	QQQ	ETF	382.0	382.39	381.97	382.14	134659.0
2021-10-28 07:30:00	QQQ	ETF	382.12	382.36	381.88	382.02	85155.0
2021-10-28 08:00:00	QQQ	ETF	382.23	382.41	380.285	382.14	188509.0
2021-10-28 08:30:00	QQQ	ETF	382.21	382.39	381.569	381.86	233937.0
2021-10-28 09:00:00	QQQ	ETF	381.87	382.12	381.73	381.94	157547.0
2021-10-28 09:30:00	QQQ	ETF	381.95	382.55	381.155	381.89	5005988.0
2021-10-28 10:00:00	QQQ	ETF	381.87	382.97	381.6501	382.72	2644835.0
2021-10-28 10:30:00	QQQ	ETF	382.72	383.88	382.62	383.04	2885545.0
2021-10-28 11:00:00	QQQ	ETF	383.04	383.95	382.8799	383.67	1500347.0
2021-10-28 11:30:00	QQQ	ETF	383.67	384.03	383.03	383.27	1136985.0
2021-10-28 12:00:00	QQQ	ETF	383.29	383.975	383.28	383.77	1093734.0
2021-10-28 12:30:00	QQQ	ETF	383.77	383.915	382.415	382.75	986158.0

> showing 50 of 24,045 rows — these rows as CSV

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