PREVIEW / etf_1hour / 2021-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-22.parquet
  size:    444 KB
  rows:    15,614

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-12-22 04:00:00	SPY	ETF	461.98	462.46	461.83	462.04	45076.0
2021-12-22 05:00:00	SPY	ETF	462.18	463.13	462.1	463.05	18589.0
2021-12-22 06:00:00	SPY	ETF	463.08	463.63	462.98	463.62	83299.0
2021-12-22 07:00:00	SPY	ETF	463.6	463.67	463.01	463.01	98524.0
2021-12-22 08:00:00	SPY	ETF	463.26	463.6399	461.68	462.05	336823.0
2021-12-22 09:00:00	SPY	ETF	462.08	463.925	461.9	463.4799	5199749.0
2021-12-22 10:00:00	SPY	ETF	463.46	466.31	463.11	466.12	7641647.0
2021-12-22 11:00:00	SPY	ETF	466.13	466.68	465.77	466.495	4608350.0
2021-12-22 12:00:00	SPY	ETF	466.51	466.91	466.1	466.825	3413528.0
2021-12-22 13:00:00	SPY	ETF	466.83	466.87	465.61	465.8727	2713503.0
2021-12-22 14:00:00	SPY	ETF	465.88	466.39	465.27	466.315	3545434.0
2021-12-22 15:00:00	SPY	ETF	466.32	467.81	466.08	467.7	11525807.0
2021-12-22 16:00:00	SPY	ETF	467.71	468.06	465.8499	468.0	3300095.0
2021-12-22 17:00:00	SPY	ETF	468.06	468.07	467.69	467.95	1414581.0
2021-12-22 18:00:00	SPY	ETF	467.95	468.3	467.69	468.11	44056.0
2021-12-22 19:00:00	SPY	ETF	468.11	468.13	467.8	468.0	47032.0
2021-12-22 04:00:00	QQQ	ETF	387.63	388.2	387.54	387.82	125706.0
2021-12-22 05:00:00	QQQ	ETF	387.96	388.91	387.83	388.76	22009.0
2021-12-22 06:00:00	QQQ	ETF	388.8	389.45	388.7	389.35	65052.0
2021-12-22 07:00:00	QQQ	ETF	389.34	389.49	388.8	388.81	111909.0
2021-12-22 08:00:00	QQQ	ETF	389.33	389.49	387.65	388.26	458067.0
2021-12-22 09:00:00	QQQ	ETF	388.275	390.9276	388.11	390.02	4361177.0
2021-12-22 10:00:00	QQQ	ETF	389.99	392.22	388.63	392.13	6027380.0
2021-12-22 11:00:00	QQQ	ETF	392.14	393.0832	391.59	392.96	3340728.0
2021-12-22 12:00:00	QQQ	ETF	392.9699	393.24	391.93	392.6	2611220.0
2021-12-22 13:00:00	QQQ	ETF	392.615	392.8	390.8	391.4003	3107968.0
2021-12-22 14:00:00	QQQ	ETF	391.4289	392.66	390.76	392.5735	2501873.0
2021-12-22 15:00:00	QQQ	ETF	392.61	394.16	392.17	393.92	5095462.0
2021-12-22 16:00:00	QQQ	ETF	393.94	394.28	393.72	394.2	1136171.0
2021-12-22 17:00:00	QQQ	ETF	394.19	394.19	394.05	394.09	52378.0
2021-12-22 18:00:00	QQQ	ETF	394.13	394.52	394.03	394.27	45844.0
2021-12-22 19:00:00	QQQ	ETF	394.32	394.32	393.91	394.04	44082.0
2021-12-22 04:00:00	IWM	ETF	218.05	218.54	218.0	218.18	13221.0
2021-12-22 05:00:00	IWM	ETF	218.11	219.2	218.09	219.14	13761.0
2021-12-22 06:00:00	IWM	ETF	219.04	219.33	218.79	219.14	21698.0
2021-12-22 07:00:00	IWM	ETF	219.15	219.21	218.67	218.67	48338.0
2021-12-22 08:00:00	IWM	ETF	219.1301	219.2004	217.72	217.83	163642.0
2021-12-22 09:00:00	IWM	ETF	217.88	218.69	217.13	217.51	4183276.0
2021-12-22 10:00:00	IWM	ETF	217.49	219.21	217.27	219.17	3422692.0
2021-12-22 11:00:00	IWM	ETF	219.18	219.84	218.78	219.76	2629862.0
2021-12-22 12:00:00	IWM	ETF	219.76	220.01	219.06	219.95	2312549.0
2021-12-22 13:00:00	IWM	ETF	219.95	220.23	219.32	219.6199	2644894.0
2021-12-22 14:00:00	IWM	ETF	219.61	219.61	218.64	219.54	2464677.0
2021-12-22 15:00:00	IWM	ETF	219.55	220.35	219.19	220.33	4491292.0
2021-12-22 16:00:00	IWM	ETF	220.28	220.67	220.22	220.44	847427.0
2021-12-22 17:00:00	IWM	ETF	220.62	220.65	220.44	220.55	28287.0
2021-12-22 18:00:00	IWM	ETF	220.48	220.85	220.28	220.77	37409.0
2021-12-22 19:00:00	IWM	ETF	220.68	220.76	220.45	220.62	25266.0
2021-12-22 04:00:00	DIA	ETF	354.37	354.66	354.37	354.49	1272.0
2021-12-22 05:00:00	DIA	ETF	355.15	355.3	355.15	355.3	1675.0

> showing 50 of 15,614 rows — these rows as CSV

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