PREVIEW / etf_1hour / 2021-12-16

all etf 1-hour files

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

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-16 04:00:00	SPY	ETF	472.51	473.28	471.0	473.1	89086.0
2021-12-16 05:00:00	SPY	ETF	473.08	473.9	472.95	473.9	30141.0
2021-12-16 06:00:00	SPY	ETF	473.92	474.86	473.75	474.44	250170.0
2021-12-16 07:00:00	SPY	ETF	474.4	474.41	473.6	473.71	225225.0
2021-12-16 08:00:00	SPY	ETF	473.0396	474.8396	471.75	473.02	646762.0
2021-12-16 09:00:00	SPY	ETF	473.03	473.03	470.8	470.8301	7909084.0
2021-12-16 10:00:00	SPY	ETF	470.84	472.29	469.79	471.57	10401154.0
2021-12-16 11:00:00	SPY	ETF	471.56	471.67	469.35	469.43	8416894.0
2021-12-16 12:00:00	SPY	ETF	469.42	469.87	467.6	467.65	6555398.0
2021-12-16 13:00:00	SPY	ETF	467.65	469.22	467.64	468.2246	5862981.0
2021-12-16 14:00:00	SPY	ETF	468.24	468.61	464.8	465.88	10246884.0
2021-12-16 15:00:00	SPY	ETF	465.9	468.33	464.9683	466.43	23258537.0
2021-12-16 16:00:00	SPY	ETF	466.42	467.36	466.16	467.12	7937690.0
2021-12-16 17:00:00	SPY	ETF	467.07	467.15	466.71	466.91	203781.0
2021-12-16 18:00:00	SPY	ETF	466.92	467.02	465.89	466.39	418351.0
2021-12-16 19:00:00	SPY	ETF	466.44	467.1	466.44	466.96	81172.0
2021-12-16 04:00:00	QQQ	ETF	399.23	400.01	399.15	399.5	56398.0
2021-12-16 05:00:00	QQQ	ETF	399.52	400.28	399.5	400.25	38638.0
2021-12-16 06:00:00	QQQ	ETF	400.29	401.24	400.12	400.83	86508.0
2021-12-16 07:00:00	QQQ	ETF	400.72	400.73	399.54	399.65	335559.0
2021-12-16 08:00:00	QQQ	ETF	400.33	401.2696	398.06	398.52	723504.0
2021-12-16 09:00:00	QQQ	ETF	398.54	398.54	394.22	394.28	8905374.0
2021-12-16 10:00:00	QQQ	ETF	394.28	394.91	392.39	393.19	9613928.0
2021-12-16 11:00:00	QQQ	ETF	393.17	393.35	389.51	389.72	8254552.0
2021-12-16 12:00:00	QQQ	ETF	389.68	390.18	387.8	387.86	6904981.0
2021-12-16 13:00:00	QQQ	ETF	387.85	389.7299	387.8499	388.4101	4435046.0
2021-12-16 14:00:00	QQQ	ETF	388.423	388.85	385.21	386.22	9337818.0
2021-12-16 15:00:00	QQQ	ETF	386.22	388.78	385.55	386.86	15888640.0
2021-12-16 16:00:00	QQQ	ETF	386.86	388.0	385.9	387.28	2882698.0
2021-12-16 17:00:00	QQQ	ETF	387.34	387.36	386.7	386.77	259893.0
2021-12-16 18:00:00	QQQ	ETF	387.0	387.13	385.68	386.22	204694.0
2021-12-16 19:00:00	QQQ	ETF	386.25	387.08	386.25	386.91	103502.0
2021-12-16 04:00:00	IWM	ETF	219.85	219.85	219.47	219.59	50915.0
2021-12-16 05:00:00	IWM	ETF	219.57	219.91	219.45	219.88	17004.0
2021-12-16 06:00:00	IWM	ETF	219.85	220.7	219.85	220.45	33505.0
2021-12-16 07:00:00	IWM	ETF	220.41	220.59	220.15	220.33	131484.0
2021-12-16 08:00:00	IWM	ETF	220.4	220.73	219.5	219.88	318943.0
2021-12-16 09:00:00	IWM	ETF	219.84	219.91	217.83	218.77	4993002.0
2021-12-16 10:00:00	IWM	ETF	218.8	219.44	217.64	218.5	5685292.0
2021-12-16 11:00:00	IWM	ETF	218.51	218.52	216.58	216.64	4039874.0
2021-12-16 12:00:00	IWM	ETF	216.62	217.07	214.64	214.68	4474307.0
2021-12-16 13:00:00	IWM	ETF	214.68	215.87	214.535	214.97	3688554.0
2021-12-16 14:00:00	IWM	ETF	214.98	215.2	212.25	213.06	5584665.0
2021-12-16 15:00:00	IWM	ETF	213.05	214.22	212.62	213.17	7077244.0
2021-12-16 16:00:00	IWM	ETF	213.18	213.76	213.08	213.53	2437695.0
2021-12-16 17:00:00	IWM	ETF	213.44	213.6	213.18	213.43	265404.0
2021-12-16 18:00:00	IWM	ETF	213.56	213.6	212.89	213.2	84037.0
2021-12-16 19:00:00	IWM	ETF	213.4	213.83	213.35	213.75	80469.0
2021-12-16 04:00:00	DIA	ETF	361.49	361.49	361.35	361.43	1857.0
2021-12-16 05:00:00	DIA	ETF	361.45	361.98	361.45	361.98	20100.0

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

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