PREVIEW / etf_1hour / 2021-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-21.parquet
  size:    419 KB
  rows:    14,432

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-01-21 04:00:00	SPY	ETF	384.7	384.83	384.6	384.8	6185.0
2021-01-21 05:00:00	SPY	ETF	384.65	384.8	384.44	384.76	9132.0
2021-01-21 06:00:00	SPY	ETF	384.7	385.12	384.7	385.12	23757.0
2021-01-21 07:00:00	SPY	ETF	385.12	385.3	384.74	384.91	151297.0
2021-01-21 08:00:00	SPY	ETF	384.9	385.3	383.8	384.1	392452.0
2021-01-21 09:00:00	SPY	ETF	384.11	384.58	383.25	383.84	4630040.0
2021-01-21 10:00:00	SPY	ETF	383.85	384.9	383.5701	384.76	4367161.0
2021-01-21 11:00:00	SPY	ETF	384.77	384.95	383.66	384.13	3339613.0
2021-01-21 12:00:00	SPY	ETF	384.1109	384.1576	383.2901	383.93	3161444.0
2021-01-21 13:00:00	SPY	ETF	383.9322	384.34	383.8125	384.1799	2217974.0
2021-01-21 14:00:00	SPY	ETF	384.17	384.88	384.11	384.84	3168922.0
2021-01-21 15:00:00	SPY	ETF	384.84	384.94	384.06	384.2	7748641.0
2021-01-21 16:00:00	SPY	ETF	384.21	384.43	383.93	384.25	3312470.0
2021-01-21 17:00:00	SPY	ETF	384.25	384.31	384.07	384.24	295525.0
2021-01-21 18:00:00	SPY	ETF	384.25	384.42	383.83	383.93	157295.0
2021-01-21 19:00:00	SPY	ETF	383.99	384.37	383.61	383.78	77739.0
2021-01-21 04:00:00	QQQ	ETF	325.28	325.6	325.21	325.28	45884.0
2021-01-21 05:00:00	QQQ	ETF	325.31	325.45	325.0	325.38	35917.0
2021-01-21 06:00:00	QQQ	ETF	325.33	325.4	325.1	325.36	71946.0
2021-01-21 07:00:00	QQQ	ETF	325.4	325.59	325.16	325.39	226135.0
2021-01-21 08:00:00	QQQ	ETF	325.4999	326.46	323.77	324.61	481860.0
2021-01-21 09:00:00	QQQ	ETF	324.57	325.26	323.73	324.55	3287520.0
2021-01-21 10:00:00	QQQ	ETF	324.53	326.299	324.34	326.23	3770975.0
2021-01-21 11:00:00	QQQ	ETF	326.2401	326.37	325.29	325.79	2100880.0
2021-01-21 12:00:00	QQQ	ETF	325.7999	325.87	324.5236	325.58	2142865.0
2021-01-21 13:00:00	QQQ	ETF	325.59	326.22	325.581	325.71	1244469.0
2021-01-21 14:00:00	QQQ	ETF	325.71	326.715	325.66	326.7	1969109.0
2021-01-21 15:00:00	QQQ	ETF	326.695	327.13	326.34	326.5	3608914.0
2021-01-21 16:00:00	QQQ	ETF	326.5	326.72	326.34	326.48	781754.0
2021-01-21 17:00:00	QQQ	ETF	326.47	326.61	326.25	326.3	49054.0
2021-01-21 18:00:00	QQQ	ETF	326.44	326.55	326.05	326.13	89277.0
2021-01-21 19:00:00	QQQ	ETF	326.1	326.38	325.73	325.89	132153.0
2021-01-21 04:00:00	IWM	ETF	214.45	214.5	214.45	214.5	200.0
2021-01-21 05:00:00	IWM	ETF	214.51	214.51	214.18	214.5	5056.0
2021-01-21 06:00:00	IWM	ETF	214.44	214.9	214.38	214.9	10202.0
2021-01-21 07:00:00	IWM	ETF	214.85	215.28	214.84	215.07	159379.0
2021-01-21 08:00:00	IWM	ETF	215.1002	215.3	214.21	214.42	129852.0
2021-01-21 09:00:00	IWM	ETF	214.4502	215.155	212.56	212.61	2558453.0
2021-01-21 10:00:00	IWM	ETF	212.61	213.57	212.31	213.52	3025328.0
2021-01-21 11:00:00	IWM	ETF	213.51	213.75	212.38	212.48	2155852.0
2021-01-21 12:00:00	IWM	ETF	212.48	212.68	211.95	212.41	1600616.0
2021-01-21 13:00:00	IWM	ETF	212.41	212.94	212.26	212.76	1446048.0
2021-01-21 14:00:00	IWM	ETF	212.76	213.57	212.35	213.16	1462861.0
2021-01-21 15:00:00	IWM	ETF	213.165	213.5	212.48	212.55	3314074.0
2021-01-21 16:00:00	IWM	ETF	212.53	213.2	212.23	212.7	924003.0
2021-01-21 17:00:00	IWM	ETF	212.81	212.81	212.53	212.6	6845.0
2021-01-21 18:00:00	IWM	ETF	212.6	212.8	212.3	212.44	26195.0
2021-01-21 19:00:00	IWM	ETF	212.51	212.95	212.47	212.65	43458.0
2021-01-21 04:00:00	DIA	ETF	312.18	312.18	312.08	312.08	200.0
2021-01-21 05:00:00	DIA	ETF	312.18	312.18	312.15	312.16	700.0

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

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