PREVIEW / etf_1hour / 2021-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-26.parquet
  size:    415 KB
  rows:    14,589

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-04-26 04:00:00	SPY	ETF	416.8	416.84	416.24	416.28	24505.0
2021-04-26 05:00:00	SPY	ETF	416.31	416.55	416.29	416.29	10477.0
2021-04-26 06:00:00	SPY	ETF	416.09	416.44	416.04	416.22	55855.0
2021-04-26 07:00:00	SPY	ETF	416.26	416.74	416.12	416.71	184634.0
2021-04-26 08:00:00	SPY	ETF	416.3501	417.0	416.12	416.84	253194.0
2021-04-26 09:00:00	SPY	ETF	416.83	417.98	416.82	417.69	4825746.0
2021-04-26 10:00:00	SPY	ETF	417.69	418.17	417.6	417.75	4697956.0
2021-04-26 11:00:00	SPY	ETF	417.75	418.15	417.61	417.6801	2931200.0
2021-04-26 12:00:00	SPY	ETF	417.68	417.81	417.28	417.595	3020632.0
2021-04-26 13:00:00	SPY	ETF	417.595	417.72	417.295	417.7089	2451029.0
2021-04-26 14:00:00	SPY	ETF	417.705	418.11	417.7	418.0901	3546646.0
2021-04-26 15:00:00	SPY	ETF	418.09	418.22	416.97	417.64	12299139.0
2021-04-26 16:00:00	SPY	ETF	417.64	417.9	417.24	417.73	3871505.0
2021-04-26 17:00:00	SPY	ETF	417.66	417.78	417.5583	417.74	431669.0
2021-04-26 18:00:00	SPY	ETF	417.75	417.82	417.59	417.65	52453.0
2021-04-26 19:00:00	SPY	ETF	417.66	418.04	417.58	417.95	49472.0
2021-04-26 04:00:00	QQQ	ETF	339.0	339.23	338.28	338.46	63900.0
2021-04-26 05:00:00	QQQ	ETF	338.43	338.59	338.3	338.45	31365.0
2021-04-26 06:00:00	QQQ	ETF	338.45	338.7	338.26	338.42	49549.0
2021-04-26 07:00:00	QQQ	ETF	338.4	338.78	338.06	338.76	387014.0
2021-04-26 08:00:00	QQQ	ETF	338.4396	339.61	338.02	339.26	331483.0
2021-04-26 09:00:00	QQQ	ETF	339.28	340.09	338.9	339.64	4145310.0
2021-04-26 10:00:00	QQQ	ETF	339.64	340.74	339.64	340.29	3076375.0
2021-04-26 11:00:00	QQQ	ETF	340.3	341.0101	340.3	340.5782	2052743.0
2021-04-26 12:00:00	QQQ	ETF	340.58	341.01	340.185	340.8301	2034772.0
2021-04-26 13:00:00	QQQ	ETF	340.84	341.18	340.465	341.13	1811384.0
2021-04-26 14:00:00	QQQ	ETF	341.12	341.815	341.12	341.8	1945106.0
2021-04-26 15:00:00	QQQ	ETF	341.8	341.92	340.87	341.63	4750454.0
2021-04-26 16:00:00	QQQ	ETF	341.62	342.18	339.69	341.8	1737707.0
2021-04-26 17:00:00	QQQ	ETF	341.75	341.85	341.61	341.7	29611.0
2021-04-26 18:00:00	QQQ	ETF	341.78	341.9	341.64	341.7	44121.0
2021-04-26 19:00:00	QQQ	ETF	341.72	342.03	341.66	341.98	44783.0
2021-04-26 04:00:00	IWM	ETF	226.5	226.84	226.45	226.45	38940.0
2021-04-26 05:00:00	IWM	ETF	226.4	226.88	226.38	226.45	47525.0
2021-04-26 06:00:00	IWM	ETF	226.37	226.44	225.95	226.29	60737.0
2021-04-26 07:00:00	IWM	ETF	226.28	226.75	226.28	226.61	46495.0
2021-04-26 08:00:00	IWM	ETF	226.53	226.87	226.2	226.78	48095.0
2021-04-26 09:00:00	IWM	ETF	226.69	227.97	226.62	227.48	2591340.0
2021-04-26 10:00:00	IWM	ETF	227.5	228.13	226.92	228.0	2586988.0
2021-04-26 11:00:00	IWM	ETF	228.0	228.52	227.84	228.35	1806804.0
2021-04-26 12:00:00	IWM	ETF	228.35	228.49	228.015	228.14	1312940.0
2021-04-26 13:00:00	IWM	ETF	228.15	228.44	227.92	228.14	1182753.0
2021-04-26 14:00:00	IWM	ETF	228.14	228.4698	228.11	228.455	1134868.0
2021-04-26 15:00:00	IWM	ETF	228.455	228.69	227.592	228.05	3564004.0
2021-04-26 16:00:00	IWM	ETF	228.11	228.48	228.03	228.48	1407914.0
2021-04-26 17:00:00	IWM	ETF	228.42	228.5	227.92	228.4	238641.0
2021-04-26 18:00:00	IWM	ETF	228.32	228.45	228.29	228.29	9085.0
2021-04-26 19:00:00	IWM	ETF	228.36	228.66	228.29	228.57	14639.0
2021-04-26 04:00:00	DIA	ETF	340.01	340.5	340.01	340.5	1160.0
2021-04-26 05:00:00	DIA	ETF	340.5	340.5	340.5	340.5	497.0

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

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