PREVIEW / etf_1hour / 2021-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-17.parquet
  size:    423 KB
  rows:    14,597

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-02-17 04:00:00	SPY	ETF	392.39	392.74	391.77	391.95	39287.0
2021-02-17 05:00:00	SPY	ETF	391.95	392.34	391.95	392.09	33150.0
2021-02-17 06:00:00	SPY	ETF	392.14	392.34	391.97	392.34	26130.0
2021-02-17 07:00:00	SPY	ETF	392.31	392.68	392.22	392.56	188031.0
2021-02-17 08:00:00	SPY	ETF	392.64	393.0	390.83	391.34	834705.0
2021-02-17 09:00:00	SPY	ETF	391.36	391.67	389.33	391.06	7317958.0
2021-02-17 10:00:00	SPY	ETF	391.06	391.72	390.06	391.1901	6852689.0
2021-02-17 11:00:00	SPY	ETF	391.18	391.27	389.48	390.56	6120926.0
2021-02-17 12:00:00	SPY	ETF	390.56	391.315	390.36	391.0287	2677886.0
2021-02-17 13:00:00	SPY	ETF	391.02	391.6	390.95	391.27	2879200.0
2021-02-17 14:00:00	SPY	ETF	391.27	392.14	391.26	391.84	3537797.0
2021-02-17 15:00:00	SPY	ETF	391.84	392.66	391.77	392.43	7564776.0
2021-02-17 16:00:00	SPY	ETF	392.435	392.46	391.536	392.34	3626073.0
2021-02-17 17:00:00	SPY	ETF	392.37	392.5	392.3	392.46	245372.0
2021-02-17 18:00:00	SPY	ETF	392.46	392.69	392.1	392.59	107008.0
2021-02-17 19:00:00	SPY	ETF	392.67	393.2	392.67	393.09	105718.0
2021-02-17 04:00:00	QQQ	ETF	335.83	335.83	334.83	334.93	45804.0
2021-02-17 05:00:00	QQQ	ETF	334.96	335.16	334.8	334.91	14445.0
2021-02-17 06:00:00	QQQ	ETF	334.99	335.14	334.81	335.05	22706.0
2021-02-17 07:00:00	QQQ	ETF	335.05	335.38	334.81	335.17	74661.0
2021-02-17 08:00:00	QQQ	ETF	334.8604	335.5	332.99	333.4	687331.0
2021-02-17 09:00:00	QQQ	ETF	333.36	333.8	331.8	333.27	3705046.0
2021-02-17 10:00:00	QQQ	ETF	333.28	333.67	331.0	332.81	5249447.0
2021-02-17 11:00:00	QQQ	ETF	332.78	332.92	330.17	331.52	4306742.0
2021-02-17 12:00:00	QQQ	ETF	331.58	332.705	331.33	332.39	1806764.0
2021-02-17 13:00:00	QQQ	ETF	332.39	333.3	332.27	332.862	2036496.0
2021-02-17 14:00:00	QQQ	ETF	332.88	333.7	332.49	332.97	1475248.0
2021-02-17 15:00:00	QQQ	ETF	332.96	334.21	332.94	333.94	3043019.0
2021-02-17 16:00:00	QQQ	ETF	333.94	333.95	323.93	333.94	1297199.0
2021-02-17 17:00:00	QQQ	ETF	333.83	333.98	333.8	333.86	12245.0
2021-02-17 18:00:00	QQQ	ETF	333.9	334.12	333.57	334.0	48749.0
2021-02-17 19:00:00	QQQ	ETF	334.04	334.5	334.0	334.32	46924.0
2021-02-17 04:00:00	IWM	ETF	225.36	225.36	224.9	224.95	13742.0
2021-02-17 05:00:00	IWM	ETF	224.97	225.0	224.95	224.95	1827.0
2021-02-17 06:00:00	IWM	ETF	224.9	225.18	224.76	225.12	10999.0
2021-02-17 07:00:00	IWM	ETF	225.2	225.57	225.13	225.5	63222.0
2021-02-17 08:00:00	IWM	ETF	225.219	225.83	223.92	224.68	265086.0
2021-02-17 09:00:00	IWM	ETF	224.55	224.83	222.62	223.68	3730671.0
2021-02-17 10:00:00	IWM	ETF	223.67	224.74	222.805	223.0	3231537.0
2021-02-17 11:00:00	IWM	ETF	223.0	223.08	220.96	222.45	3840518.0
2021-02-17 12:00:00	IWM	ETF	222.48	223.45	222.32	223.2999	1370735.0
2021-02-17 13:00:00	IWM	ETF	223.29	224.06	223.18	223.99	1506317.0
2021-02-17 14:00:00	IWM	ETF	223.99	224.32	223.33	223.93	1372394.0
2021-02-17 15:00:00	IWM	ETF	223.91	224.48	223.86	224.1	2751156.0
2021-02-17 16:00:00	IWM	ETF	224.09	224.14	223.83	224.07	2103732.0
2021-02-17 17:00:00	IWM	ETF	224.1	224.23	224.06	224.12	11938.0
2021-02-17 18:00:00	IWM	ETF	224.15	224.39	223.71	224.39	71230.0
2021-02-17 19:00:00	IWM	ETF	224.47	224.85	224.47	224.66	30682.0
2021-02-17 06:00:00	DIA	ETF	315.61	315.61	315.61	315.61	100.0
2021-02-17 07:00:00	DIA	ETF	315.68	315.95	315.68	315.95	2090.0

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

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