PREVIEW / etf_30min / 2021-08-31

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-31.parquet
  size:    610 KB
  rows:    23,118

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-31 04:00:00	SPY	ETF	453.17	453.42	453.17	453.33	16703.0
2021-08-31 04:30:00	SPY	ETF	453.19	453.28	453.13	453.22	2609.0
2021-08-31 05:00:00	SPY	ETF	453.22	453.25	453.15	453.18	3368.0
2021-08-31 05:30:00	SPY	ETF	453.18	453.18	452.92	452.94	6609.0
2021-08-31 06:00:00	SPY	ETF	452.91	453.05	452.67	452.81	8914.0
2021-08-31 06:30:00	SPY	ETF	452.83	452.83	451.88	452.05	49345.0
2021-08-31 07:00:00	SPY	ETF	452.07	452.48	451.87	452.31	62672.0
2021-08-31 07:30:00	SPY	ETF	452.26	452.3	451.92	452.01	103276.0
2021-08-31 08:00:00	SPY	ETF	452.16	453.48	451.4	451.48	142779.0
2021-08-31 08:30:00	SPY	ETF	451.43	451.88	451.28	451.88	111512.0
2021-08-31 09:00:00	SPY	ETF	451.87	452.3	451.72	452.13	151153.0
2021-08-31 09:30:00	SPY	ETF	452.13	452.26	450.92	451.12	4429316.0
2021-08-31 10:00:00	SPY	ETF	451.11	451.97	451.04	451.63	3168222.0
2021-08-31 10:30:00	SPY	ETF	451.63	452.12	451.4626	452.08	2038009.0
2021-08-31 11:00:00	SPY	ETF	452.08	452.4818	451.67	452.17	1757575.0
2021-08-31 11:30:00	SPY	ETF	452.16	452.49	452.1	452.33	1583323.0
2021-08-31 12:00:00	SPY	ETF	452.34	452.47	452.13	452.44	1095868.0
2021-08-31 12:30:00	SPY	ETF	452.44	452.46	452.195	452.27	743219.0
2021-08-31 13:00:00	SPY	ETF	452.28	452.29	451.405	451.59	1783673.0
2021-08-31 13:30:00	SPY	ETF	451.59	451.88	451.42	451.8599	1236840.0
2021-08-31 14:00:00	SPY	ETF	451.8522	451.905	451.52	451.61	2275611.0
2021-08-31 14:30:00	SPY	ETF	451.61	451.87	451.33	451.84	2117757.0
2021-08-31 15:00:00	SPY	ETF	451.83	451.915	451.2036	451.275	3149061.0
2021-08-31 15:30:00	SPY	ETF	451.2701	451.96	451.17	451.61	12992757.0
2021-08-31 16:00:00	SPY	ETF	451.61	452.4	451.55	452.36	4921965.0
2021-08-31 16:30:00	SPY	ETF	452.38	452.44	452.28	452.38	94082.0
2021-08-31 17:00:00	SPY	ETF	452.33	452.39	452.25	452.35	46896.0
2021-08-31 17:30:00	SPY	ETF	452.32	452.35	452.26	452.31	40300.0
2021-08-31 18:00:00	SPY	ETF	452.35	452.44	451.56	452.21	628046.0
2021-08-31 18:30:00	SPY	ETF	451.56	452.29	451.56	452.26	5210.0
2021-08-31 19:00:00	SPY	ETF	452.29	452.29	452.18	452.21	11839.0
2021-08-31 19:30:00	SPY	ETF	452.25	452.47	452.25	452.44	17450.0
2021-08-31 04:00:00	QQQ	ETF	381.22	381.91	381.22	381.72	48075.0
2021-08-31 04:30:00	QQQ	ETF	381.73	381.78	381.48	381.6	16147.0
2021-08-31 05:00:00	QQQ	ETF	381.62	381.65	381.35	381.37	14388.0
2021-08-31 05:30:00	QQQ	ETF	381.34	381.36	381.08	381.16	31305.0
2021-08-31 06:00:00	QQQ	ETF	381.13	381.23	380.74	380.84	25631.0
2021-08-31 06:30:00	QQQ	ETF	380.86	380.92	379.7	379.87	110028.0
2021-08-31 07:00:00	QQQ	ETF	379.92	380.73	379.81	380.64	139225.0
2021-08-31 07:30:00	QQQ	ETF	380.6	380.62	380.2	380.29	96942.0
2021-08-31 08:00:00	QQQ	ETF	380.23	382.04	379.52	379.56	229351.0
2021-08-31 08:30:00	QQQ	ETF	379.55	380.01	379.45	380.01	198031.0
2021-08-31 09:00:00	QQQ	ETF	380.0	380.7	379.87	380.54	131925.0
2021-08-31 09:30:00	QQQ	ETF	380.51	380.579	378.47	378.52	4579579.0
2021-08-31 10:00:00	QQQ	ETF	378.525	379.37	378.36	379.09	2349076.0
2021-08-31 10:30:00	QQQ	ETF	379.1001	379.57	378.8004	379.32	1433920.0
2021-08-31 11:00:00	QQQ	ETF	379.33	379.79	378.81	379.5	1065013.0
2021-08-31 11:30:00	QQQ	ETF	379.47	379.995	379.31	379.85	1118781.0
2021-08-31 12:00:00	QQQ	ETF	379.86	380.17	379.48	380.11	985738.0
2021-08-31 12:30:00	QQQ	ETF	380.09	380.2605	379.98	380.2499	772362.0

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

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