PREVIEW / etf_1hour / 2021-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-05.parquet
  size:    432 KB
  rows:    15,517

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-05 04:00:00	SPY	ETF	466.6	467.14	466.6	467.0	7454.0
2021-11-05 05:00:00	SPY	ETF	467.16	467.84	467.1	467.84	15001.0
2021-11-05 06:00:00	SPY	ETF	467.87	468.04	467.75	468.01	29718.0
2021-11-05 07:00:00	SPY	ETF	468.03	468.26	467.56	467.94	80056.0
2021-11-05 08:00:00	SPY	ETF	468.0399	469.2	466.5	468.91	817422.0
2021-11-05 09:00:00	SPY	ETF	468.89	470.41	468.74	470.26	7189753.0
2021-11-05 10:00:00	SPY	ETF	470.26	470.65	469.81	470.13	6781649.0
2021-11-05 11:00:00	SPY	ETF	470.13	470.31	469.31	469.32	4533634.0
2021-11-05 12:00:00	SPY	ETF	469.31	469.67	468.76	468.92	3828924.0
2021-11-05 13:00:00	SPY	ETF	468.93	469.11	466.92	468.17	7046024.0
2021-11-05 14:00:00	SPY	ETF	468.18	468.81	467.98	468.68	3788998.0
2021-11-05 15:00:00	SPY	ETF	468.68	469.16	467.98	468.49	11876653.0
2021-11-05 16:00:00	SPY	ETF	468.49	468.63	467.77	468.09	4286312.0
2021-11-05 17:00:00	SPY	ETF	468.17	468.21	468.0	468.05	148439.0
2021-11-05 18:00:00	SPY	ETF	468.0	468.53	467.86	467.92	33679.0
2021-11-05 19:00:00	SPY	ETF	467.94	467.95	467.76	467.79	29180.0
2021-11-05 04:00:00	QQQ	ETF	397.87	398.68	397.8	398.55	31610.0
2021-11-05 05:00:00	QQQ	ETF	398.69	400.0	398.65	400.0	48033.0
2021-11-05 06:00:00	QQQ	ETF	399.89	400.37	399.76	399.79	104098.0
2021-11-05 07:00:00	QQQ	ETF	399.78	399.85	398.5	398.89	426289.0
2021-11-05 08:00:00	QQQ	ETF	399.8099	400.19	397.6	399.42	676895.0
2021-11-05 09:00:00	QQQ	ETF	399.43	400.99	399.18	400.19	5410897.0
2021-11-05 10:00:00	QQQ	ETF	400.2	400.87	399.7	400.4503	4681906.0
2021-11-05 11:00:00	QQQ	ETF	400.455	400.95	399.93	400.49	2478820.0
2021-11-05 12:00:00	QQQ	ETF	400.49	400.74	398.99	399.34	3024761.0
2021-11-05 13:00:00	QQQ	ETF	399.35	399.49	397.16	398.7	7265667.0
2021-11-05 14:00:00	QQQ	ETF	398.71	399.23	398.29	399.02	2479670.0
2021-11-05 15:00:00	QQQ	ETF	399.0	399.23	398.09	398.57	4823566.0
2021-11-05 16:00:00	QQQ	ETF	398.56	398.69	398.2	398.44	1376195.0
2021-11-05 17:00:00	QQQ	ETF	398.5	398.5	398.0	398.25	18965.0
2021-11-05 18:00:00	QQQ	ETF	398.32	398.6	398.19	398.2	22960.0
2021-11-05 19:00:00	QQQ	ETF	398.2	398.39	398.15	398.17	14086.0
2021-11-05 04:00:00	IWM	ETF	238.5	238.85	238.5	238.78	8061.0
2021-11-05 05:00:00	IWM	ETF	238.91	239.17	238.85	239.09	5775.0
2021-11-05 06:00:00	IWM	ETF	239.09	239.59	239.04	239.58	83427.0
2021-11-05 07:00:00	IWM	ETF	239.58	240.42	239.55	240.29	429056.0
2021-11-05 08:00:00	IWM	ETF	239.1904	241.91	238.8	241.02	615464.0
2021-11-05 09:00:00	IWM	ETF	241.08	243.11	240.44	242.02	4710944.0
2021-11-05 10:00:00	IWM	ETF	242.05	242.82	240.96	242.47	4041803.0
2021-11-05 11:00:00	IWM	ETF	242.47	243.4	242.17	242.655	3580158.0
2021-11-05 12:00:00	IWM	ETF	242.665	242.71	241.61	242.04	3306209.0
2021-11-05 13:00:00	IWM	ETF	242.05	242.18	240.2	241.11	3886566.0
2021-11-05 14:00:00	IWM	ETF	241.12	242.05	240.85	241.46	2815220.0
2021-11-05 15:00:00	IWM	ETF	241.47	242.28	240.85	241.86	4388484.0
2021-11-05 16:00:00	IWM	ETF	241.86	241.91	241.35	241.43	1459562.0
2021-11-05 17:00:00	IWM	ETF	241.48	241.79	241.4	241.64	51691.0
2021-11-05 18:00:00	IWM	ETF	241.65	241.81	241.5	241.74	18547.0
2021-11-05 19:00:00	IWM	ETF	241.75	241.78	241.55	241.67	7689.0
2021-11-05 04:00:00	DIA	ETF	361.13	361.31	361.13	361.19	386.0
2021-11-05 05:00:00	DIA	ETF	361.48	361.48	361.44	361.45	1142.0

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

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