PREVIEW / etf_30min / 2021-08-06

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-06.parquet
  size:    594 KB
  rows:    22,618

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-06 04:00:00	SPY	ETF	441.41	441.51	441.4	441.51	4452.0
2021-08-06 04:30:00	SPY	ETF	441.56	441.93	441.54	441.88	3873.0
2021-08-06 05:00:00	SPY	ETF	441.85	441.9	441.81	441.81	4582.0
2021-08-06 05:30:00	SPY	ETF	441.84	441.89	441.84	441.89	1100.0
2021-08-06 06:00:00	SPY	ETF	441.87	442.07	441.83	442.0	23675.0
2021-08-06 06:30:00	SPY	ETF	442.0	442.0	441.9	441.93	13886.0
2021-08-06 07:00:00	SPY	ETF	441.94	442.1	441.93	442.0	21865.0
2021-08-06 07:30:00	SPY	ETF	442.01	442.11	441.94	441.95	38318.0
2021-08-06 08:00:00	SPY	ETF	441.9501	442.1	441.56	441.82	81242.0
2021-08-06 08:30:00	SPY	ETF	441.77	442.6	441.36	441.85	779263.0
2021-08-06 09:00:00	SPY	ETF	441.86	442.35	441.81	442.1	305863.0
2021-08-06 09:30:00	SPY	ETF	442.1	442.94	441.845	442.04	4642824.0
2021-08-06 10:00:00	SPY	ETF	442.05	442.52	441.8	442.41	3432333.0
2021-08-06 10:30:00	SPY	ETF	442.42	442.64	441.83	442.11	2713583.0
2021-08-06 11:00:00	SPY	ETF	442.1	442.45	441.8511	442.375	3363880.0
2021-08-06 11:30:00	SPY	ETF	442.3719	442.57	442.03	442.55	1229347.0
2021-08-06 12:00:00	SPY	ETF	442.55	442.6	442.3201	442.51	991970.0
2021-08-06 12:30:00	SPY	ETF	442.5298	442.79	442.36	442.76	973221.0
2021-08-06 13:00:00	SPY	ETF	442.76	442.83	442.56	442.6199	1173965.0
2021-08-06 13:30:00	SPY	ETF	442.615	442.71	442.5	442.65	1163154.0
2021-08-06 14:00:00	SPY	ETF	442.65	442.73	442.45	442.53	1499429.0
2021-08-06 14:30:00	SPY	ETF	442.52	442.565	442.06	442.0611	1478295.0
2021-08-06 15:00:00	SPY	ETF	442.06	442.5	441.945	442.485	1755615.0
2021-08-06 15:30:00	SPY	ETF	442.48	442.67	442.02	442.53	7211424.0
2021-08-06 16:00:00	SPY	ETF	442.52	442.67	442.3375	442.57	2481926.0
2021-08-06 16:30:00	SPY	ETF	442.58	442.66	442.45	442.63	214201.0
2021-08-06 17:00:00	SPY	ETF	442.52	442.61	442.52	442.57	47985.0
2021-08-06 17:30:00	SPY	ETF	442.63	442.69	442.58	442.62	16263.0
2021-08-06 18:00:00	SPY	ETF	442.62	442.68	442.52	442.68	24455.0
2021-08-06 18:30:00	SPY	ETF	442.56	442.56	442.31	442.39	30494.0
2021-08-06 19:00:00	SPY	ETF	442.49	442.54	442.2	442.31	199444.0
2021-08-06 19:30:00	SPY	ETF	442.36	442.39	442.31	442.37	5573.0
2021-08-06 04:00:00	QQQ	ETF	369.45	369.45	369.18	369.42	20421.0
2021-08-06 04:30:00	QQQ	ETF	369.43	369.45	369.38	369.45	3493.0
2021-08-06 05:00:00	QQQ	ETF	369.53	369.54	369.41	369.41	6326.0
2021-08-06 05:30:00	QQQ	ETF	369.4	369.51	369.4	369.46	6550.0
2021-08-06 06:00:00	QQQ	ETF	369.46	369.48	369.28	369.38	20599.0
2021-08-06 06:30:00	QQQ	ETF	369.3	369.36	369.26	369.33	15640.0
2021-08-06 07:00:00	QQQ	ETF	369.32	369.48	369.32	369.35	26461.0
2021-08-06 07:30:00	QQQ	ETF	369.37	369.43	369.33	369.36	23924.0
2021-08-06 08:00:00	QQQ	ETF	369.34	369.947	369.22	369.22	48044.0
2021-08-06 08:30:00	QQQ	ETF	369.3	369.41	367.74	368.36	792961.0
2021-08-06 09:00:00	QQQ	ETF	368.36	368.5	368.01	368.33	217300.0
2021-08-06 09:30:00	QQQ	ETF	368.35	369.37	368.15	368.4423	4384585.0
2021-08-06 10:00:00	QQQ	ETF	368.45	368.92	368.065	368.51	2286470.0
2021-08-06 10:30:00	QQQ	ETF	368.505	368.71	367.39	367.61	1998313.0
2021-08-06 11:00:00	QQQ	ETF	367.62	367.905	366.905	367.86	1965673.0
2021-08-06 11:30:00	QQQ	ETF	367.83	368.235	367.48	368.23	1145526.0
2021-08-06 12:00:00	QQQ	ETF	368.23	368.31	367.61	368.045	945172.0
2021-08-06 12:30:00	QQQ	ETF	368.03	368.24	367.66	368.11	749801.0

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

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