PREVIEW / etf_1hour / 2021-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-19.parquet
  size:    412 KB
  rows:    14,301

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-03-19 04:00:00	SPY	ETF	391.8	391.81	390.73	391.73	25858.0
2021-03-19 05:00:00	SPY	ETF	391.6	391.76	391.36	391.4	28455.0
2021-03-19 06:00:00	SPY	ETF	391.39	391.68	390.89	391.56	47186.0
2021-03-19 07:00:00	SPY	ETF	391.6	391.6	390.45	391.04	209994.0
2021-03-19 08:00:00	SPY	ETF	390.8	391.55	389.83	391.18	650361.0
2021-03-19 09:00:00	SPY	ETF	391.14	391.14	387.4	388.53	14078551.0
2021-03-19 10:00:00	SPY	ETF	388.51	389.96	387.15	389.84	12796480.0
2021-03-19 11:00:00	SPY	ETF	389.86	390.88	388.33	390.52	8002810.0
2021-03-19 12:00:00	SPY	ETF	390.51	391.19	390.27	391.02	6228227.0
2021-03-19 13:00:00	SPY	ETF	391.0201	391.36	390.24	391.09	5187225.0
2021-03-19 14:00:00	SPY	ETF	391.1	391.5	390.18	391.46	6474586.0
2021-03-19 15:00:00	SPY	ETF	391.45	391.569	389.42	389.5	16577192.0
2021-03-19 16:00:00	SPY	ETF	389.51	389.8594	389.14	389.31	7921963.0
2021-03-19 17:00:00	SPY	ETF	389.28	389.5	389.06	389.06	1013704.0
2021-03-19 18:00:00	SPY	ETF	389.05	389.48	389.05	389.2499	24657.0
2021-03-19 19:00:00	SPY	ETF	389.15	389.19	388.95	389.1	48776.0
2021-03-19 04:00:00	QQQ	ETF	312.84	314.85	312.84	314.37	141088.0
2021-03-19 05:00:00	QQQ	ETF	314.4	314.72	314.02	314.2	108961.0
2021-03-19 06:00:00	QQQ	ETF	314.1	314.13	313.41	313.98	158444.0
2021-03-19 07:00:00	QQQ	ETF	313.99	314.09	313.0	313.68	272221.0
2021-03-19 08:00:00	QQQ	ETF	313.67	314.37	310.42	313.6	402271.0
2021-03-19 09:00:00	QQQ	ETF	313.54	313.55	310.72	311.97	10473027.0
2021-03-19 10:00:00	QQQ	ETF	311.91	313.58	309.6601	313.345	11022274.0
2021-03-19 11:00:00	QQQ	ETF	313.36	313.9899	311.52	313.6	6746142.0
2021-03-19 12:00:00	QQQ	ETF	313.6	314.59	313.36	314.44	4213595.0
2021-03-19 13:00:00	QQQ	ETF	314.46	314.73	313.25	314.2	4114367.0
2021-03-19 14:00:00	QQQ	ETF	314.21	314.48	313.16	314.4	4469041.0
2021-03-19 15:00:00	QQQ	ETF	314.39	314.495	313.12	313.42	8592330.0
2021-03-19 16:00:00	QQQ	ETF	313.41	313.9	313.1	313.19	2369199.0
2021-03-19 17:00:00	QQQ	ETF	313.17	313.61	312.9	313.0	891979.0
2021-03-19 18:00:00	QQQ	ETF	313.04	313.3	305.0	313.2	383961.0
2021-03-19 19:00:00	QQQ	ETF	313.11	313.11	312.77	312.82	22437.0
2021-03-19 04:00:00	IWM	ETF	225.79	226.47	225.79	226.41	41532.0
2021-03-19 05:00:00	IWM	ETF	226.44	226.69	226.15	226.16	36100.0
2021-03-19 06:00:00	IWM	ETF	226.08	226.58	225.71	226.35	18662.0
2021-03-19 07:00:00	IWM	ETF	226.42	226.5	225.5	225.84	52950.0
2021-03-19 08:00:00	IWM	ETF	225.85	226.5199	224.93	226.06	85183.0
2021-03-19 09:00:00	IWM	ETF	225.97	225.99	223.0	224.66	3820138.0
2021-03-19 10:00:00	IWM	ETF	224.66	226.29	222.95	226.19	4688599.0
2021-03-19 11:00:00	IWM	ETF	226.17	228.16	225.39	227.84	2910045.0
2021-03-19 12:00:00	IWM	ETF	227.83	228.6	227.585	228.3225	2195643.0
2021-03-19 13:00:00	IWM	ETF	228.31	228.355	227.25	227.76	1654086.0
2021-03-19 14:00:00	IWM	ETF	227.77	227.97	226.43	227.28	1811924.0
2021-03-19 15:00:00	IWM	ETF	227.27	227.98	226.47	226.97	7216345.0
2021-03-19 16:00:00	IWM	ETF	226.94	227.83	226.94	227.2	1992817.0
2021-03-19 17:00:00	IWM	ETF	227.79	227.79	226.94	227.31	1259673.0
2021-03-19 18:00:00	IWM	ETF	227.23	227.23	226.94	226.94	595750.0
2021-03-19 19:00:00	IWM	ETF	227.23	227.23	227.23	227.23	515.0
2021-03-19 04:00:00	DIA	ETF	329.1	329.53	329.04	329.39	39600.0
2021-03-19 05:00:00	DIA	ETF	329.07	329.36	329.06	329.17	2009.0

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

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