PREVIEW / etf_1hour / 2021-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-16.parquet
  size:    417 KB
  rows:    14,493

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-16 04:00:00	SPY	ETF	445.2	445.26	445.0	445.05	36917.0
2021-08-16 05:00:00	SPY	ETF	444.97	445.02	444.71	444.89	19647.0
2021-08-16 06:00:00	SPY	ETF	444.7	444.85	443.84	444.79	70233.0
2021-08-16 07:00:00	SPY	ETF	444.81	444.97	444.34	444.55	134299.0
2021-08-16 08:00:00	SPY	ETF	444.53	446.274	443.9204	444.29	246847.0
2021-08-16 09:00:00	SPY	ETF	444.29	444.75	443.0801	443.39	6809101.0
2021-08-16 10:00:00	SPY	ETF	443.39	444.13	442.87	443.13	8893793.0
2021-08-16 11:00:00	SPY	ETF	443.12	444.4	443.07	444.18	5647988.0
2021-08-16 12:00:00	SPY	ETF	444.19	444.93	444.13	444.885	3718225.0
2021-08-16 13:00:00	SPY	ETF	444.8801	445.66	444.805	445.65	4175164.0
2021-08-16 14:00:00	SPY	ETF	445.65	446.42	445.52	446.11	4363673.0
2021-08-16 15:00:00	SPY	ETF	446.105	447.11	446.021	447.02	11286806.0
2021-08-16 16:00:00	SPY	ETF	447.02	447.25	446.61	446.8	2568235.0
2021-08-16 17:00:00	SPY	ETF	446.84	446.97	446.82	446.87	480042.0
2021-08-16 18:00:00	SPY	ETF	446.85	446.85	446.49	446.65	260574.0
2021-08-16 19:00:00	SPY	ETF	446.63	446.81	446.57	446.74	28763.0
2021-08-16 04:00:00	QQQ	ETF	368.43	368.55	368.29	368.31	16057.0
2021-08-16 05:00:00	QQQ	ETF	368.34	368.37	368.04	368.24	15188.0
2021-08-16 06:00:00	QQQ	ETF	368.19	368.25	367.25	367.87	55230.0
2021-08-16 07:00:00	QQQ	ETF	367.94	368.11	367.4	367.57	59996.0
2021-08-16 08:00:00	QQQ	ETF	368.04	369.096	367.27	367.46	158241.0
2021-08-16 09:00:00	QQQ	ETF	367.5	368.45	366.24	366.505	3850804.0
2021-08-16 10:00:00	QQQ	ETF	366.48	366.72	363.7	364.0999	8568696.0
2021-08-16 11:00:00	QQQ	ETF	364.08	365.91	363.99	365.48	4476762.0
2021-08-16 12:00:00	QQQ	ETF	365.48	366.459	365.345	366.29	2213541.0
2021-08-16 13:00:00	QQQ	ETF	366.29	367.64	366.191	367.51	2396322.0
2021-08-16 14:00:00	QQQ	ETF	367.52	368.15	367.34	367.9	2244635.0
2021-08-16 15:00:00	QQQ	ETF	367.9	369.02	367.87	368.97	3990079.0
2021-08-16 16:00:00	QQQ	ETF	368.95	369.09	368.729	368.94	867816.0
2021-08-16 17:00:00	QQQ	ETF	369.07	369.07	368.88	368.92	15129.0
2021-08-16 18:00:00	QQQ	ETF	368.92	368.95	368.67	368.67	131920.0
2021-08-16 19:00:00	QQQ	ETF	368.67	368.94	368.67	368.87	60614.0
2021-08-16 04:00:00	IWM	ETF	220.33	220.46	220.0	220.09	9493.0
2021-08-16 05:00:00	IWM	ETF	220.05	220.13	220.0	220.0	1919.0
2021-08-16 06:00:00	IWM	ETF	219.94	220.33	219.14	220.16	120225.0
2021-08-16 07:00:00	IWM	ETF	220.22	220.26	219.74	219.91	43815.0
2021-08-16 08:00:00	IWM	ETF	219.9	220.48	219.41	219.75	114920.0
2021-08-16 09:00:00	IWM	ETF	219.82	220.11	217.65	217.89	4669480.0
2021-08-16 10:00:00	IWM	ETF	217.88	219.82	217.69	219.04	4563445.0
2021-08-16 11:00:00	IWM	ETF	219.07	220.26	218.7839	220.05	2016773.0
2021-08-16 12:00:00	IWM	ETF	220.06	220.08	219.19	219.72	1952774.0
2021-08-16 13:00:00	IWM	ETF	219.73	220.0	219.57	219.82	1290847.0
2021-08-16 14:00:00	IWM	ETF	219.83	220.12	219.055	219.605	1748364.0
2021-08-16 15:00:00	IWM	ETF	219.6	219.74	218.78	219.06	3258455.0
2021-08-16 16:00:00	IWM	ETF	219.06	219.09	218.7	218.98	883323.0
2021-08-16 17:00:00	IWM	ETF	218.8	219.03	218.8	218.86	16245.0
2021-08-16 18:00:00	IWM	ETF	218.85	218.91	218.76	218.87	30553.0
2021-08-16 19:00:00	IWM	ETF	218.9	219.05	218.85	218.93	24950.0
2021-08-16 04:00:00	DIA	ETF	355.0	355.0	354.63	354.74	744.0
2021-08-16 05:00:00	DIA	ETF	354.53	354.53	354.53	354.53	100.0

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

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