PREVIEW / etf_1hour / 2021-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-18.parquet
  size:    413 KB
  rows:    14,324

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.34	443.53	15586.0
2021-08-18 05:00:00	SPY	ETF	443.48	443.7	443.35	443.35	4096.0
2021-08-18 06:00:00	SPY	ETF	443.38	443.99	443.23	443.91	16874.0
2021-08-18 07:00:00	SPY	ETF	443.91	444.0	443.5	443.62	51442.0
2021-08-18 08:00:00	SPY	ETF	443.66	444.373	443.13	443.22	164183.0
2021-08-18 09:00:00	SPY	ETF	443.24	444.115	442.67	444.0801	4685709.0
2021-08-18 10:00:00	SPY	ETF	444.09	444.625	443.63	443.795	7421829.0
2021-08-18 11:00:00	SPY	ETF	443.7901	443.8399	443.14	443.3617	5608986.0
2021-08-18 12:00:00	SPY	ETF	443.37	443.7	442.9604	443.3723	3041714.0
2021-08-18 13:00:00	SPY	ETF	443.38	443.44	442.8715	443.32	2764599.0
2021-08-18 14:00:00	SPY	ETF	443.32	444.19	441.7	442.86	11893578.0
2021-08-18 15:00:00	SPY	ETF	442.85	442.85	438.92	439.21	24141549.0
2021-08-18 16:00:00	SPY	ETF	439.22	439.43	437.87	438.59	5522301.0
2021-08-18 17:00:00	SPY	ETF	438.61	439.18	438.55	438.68	1099734.0
2021-08-18 18:00:00	SPY	ETF	438.68	439.18	438.63	439.0	330645.0
2021-08-18 19:00:00	SPY	ETF	439.0	439.03	438.62	438.81	138589.0
2021-08-18 04:00:00	QQQ	ETF	365.41	365.78	365.21	365.42	23418.0
2021-08-18 05:00:00	QQQ	ETF	365.39	365.8	365.39	365.53	11725.0
2021-08-18 06:00:00	QQQ	ETF	365.44	366.37	365.41	366.19	28420.0
2021-08-18 07:00:00	QQQ	ETF	366.14	366.36	365.78	365.79	110826.0
2021-08-18 08:00:00	QQQ	ETF	366.35	366.35	365.11	365.23	192543.0
2021-08-18 09:00:00	QQQ	ETF	365.2	366.6	364.86	366.285	3799661.0
2021-08-18 10:00:00	QQQ	ETF	366.29	366.62	365.3599	365.715	3404674.0
2021-08-18 11:00:00	QQQ	ETF	365.72	365.77	364.69	365.1801	2834308.0
2021-08-18 12:00:00	QQQ	ETF	365.2	365.615	365.01	365.44	1436608.0
2021-08-18 13:00:00	QQQ	ETF	365.46	365.54	364.93	365.2301	1441716.0
2021-08-18 14:00:00	QQQ	ETF	365.23	366.41	363.91	365.44	6166885.0
2021-08-18 15:00:00	QQQ	ETF	365.43	365.43	361.865	362.2	9431801.0
2021-08-18 16:00:00	QQQ	ETF	362.21	364.0	361.01	361.8	1381896.0
2021-08-18 17:00:00	QQQ	ETF	361.88	361.99	361.72	361.99	50469.0
2021-08-18 18:00:00	QQQ	ETF	361.9	362.21	361.83	362.21	103980.0
2021-08-18 19:00:00	QQQ	ETF	362.18	362.18	361.78	361.97	50238.0
2021-08-18 04:00:00	IWM	ETF	216.19	216.6	215.97	215.99	6661.0
2021-08-18 05:00:00	IWM	ETF	216.15	216.26	215.97	216.12	8360.0
2021-08-18 06:00:00	IWM	ETF	216.06	216.5	215.74	216.43	20326.0
2021-08-18 07:00:00	IWM	ETF	216.45	216.54	216.24	216.42	57984.0
2021-08-18 08:00:00	IWM	ETF	216.36	217.31	215.87	216.3	171573.0
2021-08-18 09:00:00	IWM	ETF	216.3	216.48	215.028	216.43	3504861.0
2021-08-18 10:00:00	IWM	ETF	216.45	217.74	215.8901	217.58	4387745.0
2021-08-18 11:00:00	IWM	ETF	217.6	217.79	216.82	217.18	3317038.0
2021-08-18 12:00:00	IWM	ETF	217.17	217.6	216.69	217.28	1531846.0
2021-08-18 13:00:00	IWM	ETF	217.27	217.59	217.08	217.48	1162723.0
2021-08-18 14:00:00	IWM	ETF	217.49	218.04	216.42	217.42	3373084.0
2021-08-18 15:00:00	IWM	ETF	217.41	217.41	214.37	214.52	5702147.0
2021-08-18 16:00:00	IWM	ETF	214.51	214.65	213.35	213.83	1147288.0
2021-08-18 17:00:00	IWM	ETF	213.95	214.51	213.81	214.07	118706.0
2021-08-18 18:00:00	IWM	ETF	214.05	214.51	214.03	214.29	51651.0
2021-08-18 19:00:00	IWM	ETF	214.25	214.36	214.18	214.28	29911.0
2021-08-18 04:00:00	DIA	ETF	353.1	353.1	353.1	353.1	191.0
2021-08-18 05:00:00	DIA	ETF	353.07	353.07	353.07	353.07	100.0

> showing 50 of 14,324 rows — these rows as CSV

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