PREVIEW / etf_1hour / 2021-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-27.parquet
  size:    445 KB
  rows:    15,864

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-27 04:00:00	SPY	ETF	471.03	471.51	470.82	471.41	8139.0
2021-12-27 05:00:00	SPY	ETF	471.49	471.6	471.33	471.47	11385.0
2021-12-27 06:00:00	SPY	ETF	471.52	471.53	471.29	471.48	9506.0
2021-12-27 07:00:00	SPY	ETF	471.53	472.36	471.45	472.09	145538.0
2021-12-27 08:00:00	SPY	ETF	471.43	472.54	470.6	472.36	193944.0
2021-12-27 09:00:00	SPY	ETF	472.34	473.71	472.01	473.185	4636428.0
2021-12-27 10:00:00	SPY	ETF	473.19	474.99	473.08	474.98	6022842.0
2021-12-27 11:00:00	SPY	ETF	474.98	475.29	474.633	475.25	3834347.0
2021-12-27 12:00:00	SPY	ETF	475.26	475.8	475.23	475.78	2627529.0
2021-12-27 13:00:00	SPY	ETF	475.77	476.31	475.64	476.3	3176256.0
2021-12-27 14:00:00	SPY	ETF	476.305	476.61	475.93	476.17	4220964.0
2021-12-27 15:00:00	SPY	ETF	476.17	477.31	475.6931	477.27	12202437.0
2021-12-27 16:00:00	SPY	ETF	477.27	477.4	477.05	477.17	3453148.0
2021-12-27 17:00:00	SPY	ETF	477.16	477.26	476.92	477.08	379216.0
2021-12-27 18:00:00	SPY	ETF	477.02	477.26	476.8	476.8	64909.0
2021-12-27 19:00:00	SPY	ETF	476.8	477.01	476.5	476.98	73241.0
2021-12-27 04:00:00	QQQ	ETF	397.37	398.19	397.37	398.13	17319.0
2021-12-27 05:00:00	QQQ	ETF	398.18	398.24	398.1	398.1	3233.0
2021-12-27 06:00:00	QQQ	ETF	398.08	398.11	397.91	398.0	4093.0
2021-12-27 07:00:00	QQQ	ETF	398.06	399.0	397.99	398.76	126080.0
2021-12-27 08:00:00	QQQ	ETF	398.078	399.13	396.96	398.95	1603689.0
2021-12-27 09:00:00	QQQ	ETF	398.9	400.69	398.2194	400.37	4580482.0
2021-12-27 10:00:00	QQQ	ETF	400.42	402.54	400.23	402.36	4577563.0
2021-12-27 11:00:00	QQQ	ETF	402.36	402.78	401.68	402.1845	2708712.0
2021-12-27 12:00:00	QQQ	ETF	402.135	402.68	402.12	402.64	1590341.0
2021-12-27 13:00:00	QQQ	ETF	402.63	403.0901	402.43	403.09	1696824.0
2021-12-27 14:00:00	QQQ	ETF	403.07	403.28	402.7	402.8999	1778844.0
2021-12-27 15:00:00	QQQ	ETF	402.89	403.48	402.28	403.41	4908450.0
2021-12-27 16:00:00	QQQ	ETF	403.41	403.87	403.35	403.66	2022496.0
2021-12-27 17:00:00	QQQ	ETF	403.68	403.79	403.51	403.53	21428.0
2021-12-27 18:00:00	QQQ	ETF	403.53	403.62	403.23	403.23	34911.0
2021-12-27 19:00:00	QQQ	ETF	403.21	403.29	402.91	403.2	46615.0
2021-12-27 04:00:00	IWM	ETF	221.85	222.01	221.56	221.87	8277.0
2021-12-27 05:00:00	IWM	ETF	222.02	222.02	221.7	221.85	12139.0
2021-12-27 06:00:00	IWM	ETF	221.9	222.08	221.85	221.87	4556.0
2021-12-27 07:00:00	IWM	ETF	221.9	222.34	221.83	222.22	51295.0
2021-12-27 08:00:00	IWM	ETF	222.22	222.75	221.81	222.62	73368.0
2021-12-27 09:00:00	IWM	ETF	222.63	222.86	220.6	220.97	3740138.0
2021-12-27 10:00:00	IWM	ETF	220.98	223.44	220.65	223.36	2577862.0
2021-12-27 11:00:00	IWM	ETF	223.38	223.57	222.85	223.17	1817846.0
2021-12-27 12:00:00	IWM	ETF	223.165	223.43	222.94	223.245	916104.0
2021-12-27 13:00:00	IWM	ETF	223.24	223.44	222.99	223.08	765955.0
2021-12-27 14:00:00	IWM	ETF	223.075	223.55	222.925	223.42	1073444.0
2021-12-27 15:00:00	IWM	ETF	223.41	224.235	223.24	224.18	3155293.0
2021-12-27 16:00:00	IWM	ETF	224.12	224.29	223.98	224.26	2411405.0
2021-12-27 17:00:00	IWM	ETF	224.03	224.25	224.02	224.15	46556.0
2021-12-27 18:00:00	IWM	ETF	224.19	224.2	223.98	223.98	13897.0
2021-12-27 19:00:00	IWM	ETF	223.98	224.32	223.71	224.19	35027.0
2021-12-27 04:00:00	DIA	ETF	359.11	359.56	359.11	359.56	600.0
2021-12-27 05:00:00	DIA	ETF	359.65	359.65	359.65	359.65	200.0

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

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