PREVIEW / etf_1hour / 2021-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-10.parquet
  size:    421 KB
  rows:    14,771

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-10 04:00:00	SPY	ETF	387.51	387.98	387.17	387.94	19496.0
2021-03-10 05:00:00	SPY	ETF	387.85	388.15	387.13	387.19	105046.0
2021-03-10 06:00:00	SPY	ETF	387.17	387.51	386.39	387.18	95640.0
2021-03-10 07:00:00	SPY	ETF	387.14	387.66	386.93	387.3	111992.0
2021-03-10 08:00:00	SPY	ETF	386.9799	389.06	385.76	388.98	987757.0
2021-03-10 09:00:00	SPY	ETF	388.99	390.92	388.74	390.32	13472954.0
2021-03-10 10:00:00	SPY	ETF	390.32	390.82	388.1702	389.35	16755489.0
2021-03-10 11:00:00	SPY	ETF	389.35	390.56	389.05	390.105	10062496.0
2021-03-10 12:00:00	SPY	ETF	390.11	390.32	389.03	390.2395	7748943.0
2021-03-10 13:00:00	SPY	ETF	390.24	390.73	388.89	389.8702	11365515.0
2021-03-10 14:00:00	SPY	ETF	389.87	391.4	389.48	390.815	8780760.0
2021-03-10 15:00:00	SPY	ETF	390.82	391.14	389.36	389.5199	14922504.0
2021-03-10 16:00:00	SPY	ETF	389.51	390.58	389.38	390.54	4661931.0
2021-03-10 17:00:00	SPY	ETF	390.43	390.55	389.58	390.47	107879.0
2021-03-10 18:00:00	SPY	ETF	390.49	390.61	389.58	389.82	160917.0
2021-03-10 19:00:00	SPY	ETF	389.82	390.01	389.1	389.39	141220.0
2021-03-10 04:00:00	QQQ	ETF	311.8	312.31	311.23	312.24	67275.0
2021-03-10 05:00:00	QQQ	ETF	312.16	312.56	311.26	311.26	73579.0
2021-03-10 06:00:00	QQQ	ETF	311.19	311.39	309.8	311.08	203430.0
2021-03-10 07:00:00	QQQ	ETF	311.04	311.74	310.79	311.35	310549.0
2021-03-10 08:00:00	QQQ	ETF	311.0004	315.0	309.9604	314.14	1988507.0
2021-03-10 09:00:00	QQQ	ETF	314.13	316.76	313.76	314.81	11625583.0
2021-03-10 10:00:00	QQQ	ETF	314.81	315.88	310.97	312.44	12688482.0
2021-03-10 11:00:00	QQQ	ETF	312.42	313.53	311.31	313.03	6796426.0
2021-03-10 12:00:00	QQQ	ETF	313.025	313.21	310.73	312.755	6321423.0
2021-03-10 13:00:00	QQQ	ETF	312.77	312.86	310.17	311.02	8940625.0
2021-03-10 14:00:00	QQQ	ETF	310.98	313.11	310.54	312.47	5018598.0
2021-03-10 15:00:00	QQQ	ETF	312.49	312.99	310.75	310.92	7303980.0
2021-03-10 16:00:00	QQQ	ETF	310.91	312.4092	310.8554	311.82	1202690.0
2021-03-10 17:00:00	QQQ	ETF	311.78	311.89	311.7	311.84	31302.0
2021-03-10 18:00:00	QQQ	ETF	311.87	312.05	311.27	311.37	109431.0
2021-03-10 19:00:00	QQQ	ETF	311.42	311.6	310.3	310.55	178184.0
2021-03-10 04:00:00	IWM	ETF	223.82	224.25	223.82	224.08	19296.0
2021-03-10 05:00:00	IWM	ETF	224.1	224.24	223.5	223.61	16658.0
2021-03-10 06:00:00	IWM	ETF	223.41	223.82	223.2	223.39	13138.0
2021-03-10 07:00:00	IWM	ETF	223.76	224.3	223.59	223.87	50117.0
2021-03-10 08:00:00	IWM	ETF	223.6499	225.2	223.6499	225.2	219286.0
2021-03-10 09:00:00	IWM	ETF	225.25	228.44	224.9	227.86	4691468.0
2021-03-10 10:00:00	IWM	ETF	227.89	228.97	226.25	227.38	6894132.0
2021-03-10 11:00:00	IWM	ETF	227.4	228.45	226.9	227.99	2945434.0
2021-03-10 12:00:00	IWM	ETF	228.02	228.29	225.86	227.07	2857370.0
2021-03-10 13:00:00	IWM	ETF	227.08	227.78	226.1	227.09	3577890.0
2021-03-10 14:00:00	IWM	ETF	227.05	228.22	226.76	227.71	2081273.0
2021-03-10 15:00:00	IWM	ETF	227.72	227.97	226.95	227.24	4086601.0
2021-03-10 16:00:00	IWM	ETF	227.22	228.03	226.98	228.02	1595588.0
2021-03-10 17:00:00	IWM	ETF	227.68	228.0	227.68	227.94	29215.0
2021-03-10 18:00:00	IWM	ETF	227.98	228.14	227.22	227.28	42972.0
2021-03-10 19:00:00	IWM	ETF	227.37	227.53	226.98	227.1	37042.0
2021-03-10 04:00:00	DIA	ETF	319.0	319.89	319.0	319.89	10593.0
2021-03-10 05:00:00	DIA	ETF	319.8	319.89	319.33	319.33	5550.0

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

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