PREVIEW / etf_1hour / 2021-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-10.parquet
  size:    441 KB
  rows:    15,588

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-10 04:00:00	SPY	ETF	466.51	466.93	466.28	466.85	9201.0
2021-11-10 05:00:00	SPY	ETF	466.88	466.88	465.89	466.21	10918.0
2021-11-10 06:00:00	SPY	ETF	466.27	466.35	465.69	465.83	33156.0
2021-11-10 07:00:00	SPY	ETF	465.78	466.42	465.78	466.28	232217.0
2021-11-10 08:00:00	SPY	ETF	465.9399	467.0	465.26	465.77	663660.0
2021-11-10 09:00:00	SPY	ETF	465.79	467.21	465.31	467.07	4902151.0
2021-11-10 10:00:00	SPY	ETF	467.09	467.38	466.66	466.75	4626722.0
2021-11-10 11:00:00	SPY	ETF	466.75	467.3	466.23	466.8199	3594283.0
2021-11-10 12:00:00	SPY	ETF	466.81	466.95	465.535	466.02	3172622.0
2021-11-10 13:00:00	SPY	ETF	466.02	466.12	463.935	464.23	8837158.0
2021-11-10 14:00:00	SPY	ETF	464.22	464.28	462.04	462.751	11561404.0
2021-11-10 15:00:00	SPY	ETF	462.76	464.29	462.44	463.65	13785811.0
2021-11-10 16:00:00	SPY	ETF	463.65	464.05	463.5	463.99	2425197.0
2021-11-10 17:00:00	SPY	ETF	463.99	464.05	463.62	463.95	45706.0
2021-11-10 18:00:00	SPY	ETF	463.97	464.03	463.37	463.69	90327.0
2021-11-10 19:00:00	SPY	ETF	463.7	464.48	463.7	464.31	101126.0
2021-11-10 04:00:00	QQQ	ETF	394.99	395.18	394.25	394.75	46267.0
2021-11-10 05:00:00	QQQ	ETF	394.87	394.87	393.3	393.7	59142.0
2021-11-10 06:00:00	QQQ	ETF	393.7	393.89	392.78	393.14	70719.0
2021-11-10 07:00:00	QQQ	ETF	393.08	393.61	392.98	393.25	240748.0
2021-11-10 08:00:00	QQQ	ETF	393.0725	395.85	392.02	392.59	1316517.0
2021-11-10 09:00:00	QQQ	ETF	392.57	394.39	391.03	394.23	7911701.0
2021-11-10 10:00:00	QQQ	ETF	394.24	395.36	393.79	394.02	5442208.0
2021-11-10 11:00:00	QQQ	ETF	394.03	394.77	392.81	393.79	3286569.0
2021-11-10 12:00:00	QQQ	ETF	393.77	393.97	392.42	393.14	3822594.0
2021-11-10 13:00:00	QQQ	ETF	393.12	393.26	390.19	390.54	6071113.0
2021-11-10 14:00:00	QQQ	ETF	390.53	390.777	387.53	388.19	7733189.0
2021-11-10 15:00:00	QQQ	ETF	388.2	390.23	388.0	389.49	7562717.0
2021-11-10 16:00:00	QQQ	ETF	389.51	389.9	389.05	389.7	1571114.0
2021-11-10 17:00:00	QQQ	ETF	389.54	389.9	389.51	389.75	119911.0
2021-11-10 18:00:00	QQQ	ETF	389.8	389.91	389.46	389.82	113201.0
2021-11-10 19:00:00	QQQ	ETF	389.89	390.69	389.8	390.5	490531.0
2021-11-10 04:00:00	IWM	ETF	240.66	240.87	240.32	240.66	13351.0
2021-11-10 05:00:00	IWM	ETF	240.62	240.62	239.95	240.25	14585.0
2021-11-10 06:00:00	IWM	ETF	240.24	240.34	240.01	240.01	10842.0
2021-11-10 07:00:00	IWM	ETF	240.06	240.65	240.06	240.65	51798.0
2021-11-10 08:00:00	IWM	ETF	240.3601	241.13	240.0	240.38	178380.0
2021-11-10 09:00:00	IWM	ETF	240.4	241.54	239.65	241.52	3620685.0
2021-11-10 10:00:00	IWM	ETF	241.51	241.56	239.98	239.99	2898793.0
2021-11-10 11:00:00	IWM	ETF	239.99	240.915	239.99	240.57	1764926.0
2021-11-10 12:00:00	IWM	ETF	240.57	240.7	239.27	239.55	2084731.0
2021-11-10 13:00:00	IWM	ETF	239.54	239.68	237.82	238.14	3699063.0
2021-11-10 14:00:00	IWM	ETF	238.14	238.14	236.31	236.86	5212290.0
2021-11-10 15:00:00	IWM	ETF	236.87	238.06	236.7	237.34	4982406.0
2021-11-10 16:00:00	IWM	ETF	237.34	237.41	237.06	237.36	1259770.0
2021-11-10 17:00:00	IWM	ETF	237.4	237.5	237.35	237.38	211512.0
2021-11-10 18:00:00	IWM	ETF	237.49	237.5	236.91	237.08	77114.0
2021-11-10 19:00:00	IWM	ETF	237.08	237.57	237.08	237.39	39969.0
2021-11-10 04:00:00	DIA	ETF	362.75	362.77	362.75	362.77	476.0
2021-11-10 05:00:00	DIA	ETF	362.85	362.85	362.85	362.85	100.0

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

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