PREVIEW / etf_1hour / 2021-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-15.parquet
  size:    438 KB
  rows:    15,571

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-15 04:00:00	SPY	ETF	468.05	468.31	467.94	468.11	12027.0
2021-11-15 05:00:00	SPY	ETF	468.12	468.49	468.12	468.44	12620.0
2021-11-15 06:00:00	SPY	ETF	468.47	468.55	468.32	468.46	31871.0
2021-11-15 07:00:00	SPY	ETF	468.45	468.46	468.24	468.44	93460.0
2021-11-15 08:00:00	SPY	ETF	468.4499	469.22	467.31	468.89	200834.0
2021-11-15 09:00:00	SPY	ETF	468.91	469.04	467.63	468.55	4286591.0
2021-11-15 10:00:00	SPY	ETF	468.56	468.58	467.49	467.76	4559848.0
2021-11-15 11:00:00	SPY	ETF	467.76	468.07	466.24	466.8993	5514039.0
2021-11-15 12:00:00	SPY	ETF	466.88	467.26	466.23	467.193	3134713.0
2021-11-15 13:00:00	SPY	ETF	467.2	467.55	466.9413	467.06	2732108.0
2021-11-15 14:00:00	SPY	ETF	467.09	467.45	466.58	467.265	3027021.0
2021-11-15 15:00:00	SPY	ETF	467.275	467.52	466.58	467.4	8127956.0
2021-11-15 16:00:00	SPY	ETF	467.39	467.69	467.2418	467.6	2432150.0
2021-11-15 17:00:00	SPY	ETF	467.61	467.63	467.43	467.5	146948.0
2021-11-15 18:00:00	SPY	ETF	467.52	467.59	467.36	467.46	107310.0
2021-11-15 19:00:00	SPY	ETF	467.46	467.7	467.18	467.57	66173.0
2021-11-15 04:00:00	QQQ	ETF	395.44	396.0	395.17	395.46	123509.0
2021-11-15 05:00:00	QQQ	ETF	395.48	395.8	395.46	395.61	141169.0
2021-11-15 06:00:00	QQQ	ETF	395.62	395.82	395.47	395.72	95111.0
2021-11-15 07:00:00	QQQ	ETF	395.74	395.81	395.46	395.75	150897.0
2021-11-15 08:00:00	QQQ	ETF	395.53	396.77	394.996	396.36	393375.0
2021-11-15 09:00:00	QQQ	ETF	396.38	396.46	394.653	395.6419	4526294.0
2021-11-15 10:00:00	QQQ	ETF	395.66	395.69	393.6423	394.2282	4852383.0
2021-11-15 11:00:00	QQQ	ETF	394.235	394.78	392.369	393.17	4035268.0
2021-11-15 12:00:00	QQQ	ETF	393.1502	393.715	392.095	393.39	2751357.0
2021-11-15 13:00:00	QQQ	ETF	393.37	394.0	393.1899	393.2328	1743290.0
2021-11-15 14:00:00	QQQ	ETF	393.25	394.45	393.0	394.32	2161704.0
2021-11-15 15:00:00	QQQ	ETF	394.29	394.8122	393.91	394.63	4084068.0
2021-11-15 16:00:00	QQQ	ETF	394.64	394.88	394.5	394.81	681951.0
2021-11-15 17:00:00	QQQ	ETF	394.79	394.84	394.61	394.72	203513.0
2021-11-15 18:00:00	QQQ	ETF	394.74	394.88	394.54	394.68	61053.0
2021-11-15 19:00:00	QQQ	ETF	394.69	394.87	394.39	394.75	89909.0
2021-11-15 04:00:00	IWM	ETF	239.93	240.18	239.86	240.09	19765.0
2021-11-15 05:00:00	IWM	ETF	240.1	240.41	240.09	240.37	6642.0
2021-11-15 06:00:00	IWM	ETF	240.37	240.57	240.24	240.51	6713.0
2021-11-15 07:00:00	IWM	ETF	240.48	240.55	240.29	240.5	36627.0
2021-11-15 08:00:00	IWM	ETF	240.1096	241.12	240.0096	240.65	91979.0
2021-11-15 09:00:00	IWM	ETF	240.68	240.94	239.09	239.84	2486048.0
2021-11-15 10:00:00	IWM	ETF	239.86	239.89	238.38	238.85	2870310.0
2021-11-15 11:00:00	IWM	ETF	238.86	239.07	237.77	237.93	2491598.0
2021-11-15 12:00:00	IWM	ETF	237.91	238.51	237.55	238.41	2120850.0
2021-11-15 13:00:00	IWM	ETF	238.41	238.75	238.04	238.06	1679903.0
2021-11-15 14:00:00	IWM	ETF	238.06	238.89	237.92	238.58	2030549.0
2021-11-15 15:00:00	IWM	ETF	238.6	238.78	237.85	238.54	4090634.0
2021-11-15 16:00:00	IWM	ETF	238.54	238.69	238.4	238.55	3194662.0
2021-11-15 17:00:00	IWM	ETF	238.55	238.55	238.35	238.47	336121.0
2021-11-15 18:00:00	IWM	ETF	238.47	238.55	238.35	238.46	119374.0
2021-11-15 19:00:00	IWM	ETF	238.55	238.61	238.13	238.37	81395.0
2021-11-15 04:00:00	DIA	ETF	361.97	361.97	361.93	361.93	300.0
2021-11-15 06:00:00	DIA	ETF	362.49	362.49	362.34	362.34	3608.0

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

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