PREVIEW / etf_1hour / 2021-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-08.parquet
  size:    436 KB
  rows:    15,662

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-11-08 04:00:00	SPY	ETF	468.05	468.88	468.05	468.64	34889.0
2021-11-08 05:00:00	SPY	ETF	468.65	468.95	468.54	468.77	27680.0
2021-11-08 06:00:00	SPY	ETF	468.84	468.99	468.72	468.93	55119.0
2021-11-08 07:00:00	SPY	ETF	468.92	469.01	468.64	468.7	239460.0
2021-11-08 08:00:00	SPY	ETF	468.88	469.5	467.6	469.49	383478.0
2021-11-08 09:00:00	SPY	ETF	469.5	470.23	469.03	469.45	4543822.0
2021-11-08 10:00:00	SPY	ETF	469.45	469.78	468.655	469.055	4317394.0
2021-11-08 11:00:00	SPY	ETF	469.05	469.35	468.51	468.65	2795624.0
2021-11-08 12:00:00	SPY	ETF	468.65	468.79	468.2031	468.61	2674885.0
2021-11-08 13:00:00	SPY	ETF	468.61	469.13	468.44	469.06	2295461.0
2021-11-08 14:00:00	SPY	ETF	469.05	469.479	468.9	469.47	2964457.0
2021-11-08 15:00:00	SPY	ETF	469.48	469.48	468.54	468.96	8351666.0
2021-11-08 16:00:00	SPY	ETF	468.99	469.1	468.4	468.69	3446561.0
2021-11-08 17:00:00	SPY	ETF	468.69	468.73	468.51	468.51	91020.0
2021-11-08 18:00:00	SPY	ETF	468.56	468.66	468.27	468.4	83726.0
2021-11-08 19:00:00	SPY	ETF	468.29	468.48	467.72	467.77	68470.0
2021-11-08 04:00:00	QQQ	ETF	398.28	398.29	398.04	398.14	53670.0
2021-11-08 05:00:00	QQQ	ETF	398.23	398.69	398.18	398.38	204328.0
2021-11-08 06:00:00	QQQ	ETF	398.38	398.82	398.38	398.61	170949.0
2021-11-08 07:00:00	QQQ	ETF	398.62	398.77	398.2	398.36	301429.0
2021-11-08 08:00:00	QQQ	ETF	398.48	398.898	397.0	398.67	177451.0
2021-11-08 09:00:00	QQQ	ETF	398.65	399.62	397.76	398.27	4456546.0
2021-11-08 10:00:00	QQQ	ETF	398.28	398.85	397.4	398.23	4251505.0
2021-11-08 11:00:00	QQQ	ETF	398.23	398.99	397.73	398.17	2590103.0
2021-11-08 12:00:00	QQQ	ETF	398.18	398.48	397.65	398.42	1928457.0
2021-11-08 13:00:00	QQQ	ETF	398.43	398.98	398.27	398.78	1498604.0
2021-11-08 14:00:00	QQQ	ETF	398.8	399.37	398.36	399.0	1720848.0
2021-11-08 15:00:00	QQQ	ETF	399.01	399.015	397.5	398.06	3668559.0
2021-11-08 16:00:00	QQQ	ETF	398.06	398.13	397.41	397.89	817890.0
2021-11-08 17:00:00	QQQ	ETF	397.88	398.08	397.5	397.67	58808.0
2021-11-08 18:00:00	QQQ	ETF	397.65	397.87	397.46	397.65	48504.0
2021-11-08 19:00:00	QQQ	ETF	397.57	397.7	397.01	397.09	73545.0
2021-11-08 04:00:00	IWM	ETF	242.06	243.12	242.06	242.62	19782.0
2021-11-08 05:00:00	IWM	ETF	242.61	242.85	242.49	242.84	5426.0
2021-11-08 06:00:00	IWM	ETF	242.9	242.97	242.58	242.79	11681.0
2021-11-08 07:00:00	IWM	ETF	242.78	243.13	242.62	242.95	107218.0
2021-11-08 08:00:00	IWM	ETF	242.66	243.57	241.81	243.499	991809.0
2021-11-08 09:00:00	IWM	ETF	243.43	244.46	243.14	243.74	4798355.0
2021-11-08 10:00:00	IWM	ETF	243.76	244.315	243.03	243.9	4550794.0
2021-11-08 11:00:00	IWM	ETF	243.91	244.35	243.6	243.61	2810929.0
2021-11-08 12:00:00	IWM	ETF	243.615	243.76	242.57	243.025	2414914.0
2021-11-08 13:00:00	IWM	ETF	243.025	243.23	242.58	243.0	1419368.0
2021-11-08 14:00:00	IWM	ETF	243.02	243.21	242.24	242.635	1893612.0
2021-11-08 15:00:00	IWM	ETF	242.63	243.04	241.93	242.61	2766153.0
2021-11-08 16:00:00	IWM	ETF	242.56	243.2877	242.05	242.13	1278355.0
2021-11-08 17:00:00	IWM	ETF	242.11	242.56	242.1	242.18	50668.0
2021-11-08 18:00:00	IWM	ETF	242.18	242.56	241.91	242.08	23667.0
2021-11-08 19:00:00	IWM	ETF	242.12	242.17	241.63	241.66	22773.0
2021-11-08 04:00:00	DIA	ETF	363.7	364.04	363.7	364.04	505.0
2021-11-08 05:00:00	DIA	ETF	364.13	364.13	364.04	364.04	500.0

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

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