PREVIEW / etf_1hour / 2021-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-26.parquet
  size:    408 KB
  rows:    14,150

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-08-26 04:00:00	SPY	ETF	448.16	448.71	448.16	448.51	11456.0
2021-08-26 05:00:00	SPY	ETF	448.36	448.51	448.21	448.51	9684.0
2021-08-26 06:00:00	SPY	ETF	448.63	448.7	448.44	448.61	5017.0
2021-08-26 07:00:00	SPY	ETF	448.6	448.91	448.53	448.83	77658.0
2021-08-26 08:00:00	SPY	ETF	448.6104	448.94	448.15	448.46	291423.0
2021-08-26 09:00:00	SPY	ETF	448.47	448.86	448.19	448.2	4329943.0
2021-08-26 10:00:00	SPY	ETF	448.18	448.61	446.49	446.92	11001725.0
2021-08-26 11:00:00	SPY	ETF	446.91	447.91	446.18	447.5015	7369062.0
2021-08-26 12:00:00	SPY	ETF	447.5	448.09	447.495	447.72	3190263.0
2021-08-26 13:00:00	SPY	ETF	447.71	447.91	447.16	447.49	3134950.0
2021-08-26 14:00:00	SPY	ETF	447.49	447.495	446.66	446.74	5546281.0
2021-08-26 15:00:00	SPY	ETF	446.72	446.97	446.16	446.27	12519810.0
2021-08-26 16:00:00	SPY	ETF	446.28	446.73	446.26	446.64	1954161.0
2021-08-26 17:00:00	SPY	ETF	446.6	446.76	446.52	446.67	33413.0
2021-08-26 18:00:00	SPY	ETF	446.69	446.85	446.26	446.66	155279.0
2021-08-26 19:00:00	SPY	ETF	446.62	446.62	446.15	446.32	75853.0
2021-08-26 04:00:00	QQQ	ETF	374.54	374.54	373.81	373.81	16844.0
2021-08-26 05:00:00	QQQ	ETF	373.71	373.74	373.5	373.71	17549.0
2021-08-26 06:00:00	QQQ	ETF	373.75	374.05	373.74	373.92	24238.0
2021-08-26 07:00:00	QQQ	ETF	373.95	374.34	373.91	374.0	35646.0
2021-08-26 08:00:00	QQQ	ETF	373.99	375.081	373.18	373.76	266963.0
2021-08-26 09:00:00	QQQ	ETF	373.79	374.57	373.64	373.93	2918969.0
2021-08-26 10:00:00	QQQ	ETF	373.9	374.62	372.29	372.95	6088030.0
2021-08-26 11:00:00	QQQ	ETF	372.96	373.78	371.97	373.5201	4342915.0
2021-08-26 12:00:00	QQQ	ETF	373.52	374.28	373.51	373.85	1814882.0
2021-08-26 13:00:00	QQQ	ETF	373.85	373.95	373.24	373.67	1491731.0
2021-08-26 14:00:00	QQQ	ETF	373.695	373.74	372.855	372.92	1924509.0
2021-08-26 15:00:00	QQQ	ETF	372.88	373.06	372.21	372.4	4689012.0
2021-08-26 16:00:00	QQQ	ETF	372.4	372.75	372.15	372.72	610061.0
2021-08-26 17:00:00	QQQ	ETF	372.79	372.84	372.4	372.42	38198.0
2021-08-26 18:00:00	QQQ	ETF	372.6	372.85	372.59	372.71	50074.0
2021-08-26 19:00:00	QQQ	ETF	372.66	372.68	372.4	372.5	26803.0
2021-08-26 04:00:00	IWM	ETF	222.44	222.66	222.35	222.46	14428.0
2021-08-26 05:00:00	IWM	ETF	222.34	222.34	222.23	222.29	900.0
2021-08-26 06:00:00	IWM	ETF	222.46	222.51	222.16	222.36	16713.0
2021-08-26 07:00:00	IWM	ETF	222.3	222.61	222.13	222.56	91935.0
2021-08-26 08:00:00	IWM	ETF	222.3	222.73	222.07	222.32	95068.0
2021-08-26 09:00:00	IWM	ETF	222.34	222.6454	221.49	222.54	2744674.0
2021-08-26 10:00:00	IWM	ETF	222.54	223.16	220.51	220.8	4821280.0
2021-08-26 11:00:00	IWM	ETF	220.78	221.75	220.11	221.475	2721786.0
2021-08-26 12:00:00	IWM	ETF	221.48	221.85	221.23	221.505	1172592.0
2021-08-26 13:00:00	IWM	ETF	221.5	221.575	220.89	221.36	1095044.0
2021-08-26 14:00:00	IWM	ETF	221.36	221.47	220.22	220.3	1601877.0
2021-08-26 15:00:00	IWM	ETF	220.3	220.68	219.74	220.24	4091200.0
2021-08-26 16:00:00	IWM	ETF	220.24	220.4	220.12	220.2	758267.0
2021-08-26 17:00:00	IWM	ETF	220.16	220.26	220.13	220.13	2597.0
2021-08-26 18:00:00	IWM	ETF	220.17	220.35	220.14	220.19	8813.0
2021-08-26 19:00:00	IWM	ETF	220.09	220.12	219.81	219.91	23672.0
2021-08-26 04:00:00	DIA	ETF	354.16	354.16	354.16	354.16	250.0
2021-08-26 05:00:00	DIA	ETF	353.95	354.08	353.95	354.08	200.0

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

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