PREVIEW / etf_1hour / 2021-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-22.parquet
  size:    446 KB
  rows:    15,957

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-11-22 04:00:00	SPY	ETF	470.03	470.72	470.03	470.48	12243.0
2021-11-22 05:00:00	SPY	ETF	470.56	470.82	470.42	470.55	7685.0
2021-11-22 06:00:00	SPY	ETF	470.66	471.16	470.32	470.44	58587.0
2021-11-22 07:00:00	SPY	ETF	470.33	470.61	470.12	470.27	137073.0
2021-11-22 08:00:00	SPY	ETF	470.27	470.7296	469.241	470.53	236098.0
2021-11-22 09:00:00	SPY	ETF	470.52	472.82	470.38	472.69	7163000.0
2021-11-22 10:00:00	SPY	ETF	472.71	473.54	472.65	472.79	7104977.0
2021-11-22 11:00:00	SPY	ETF	472.78	472.885	469.25	470.09	8013451.0
2021-11-22 12:00:00	SPY	ETF	470.09	471.17	469.64	470.685	7124745.0
2021-11-22 13:00:00	SPY	ETF	470.695	471.19	470.33	470.72	3239865.0
2021-11-22 14:00:00	SPY	ETF	470.725	471.88	470.58	471.7727	4224424.0
2021-11-22 15:00:00	SPY	ETF	471.79	472.4	467.35	467.52	16414757.0
2021-11-22 16:00:00	SPY	ETF	467.52	470.4101	466.95	467.94	4531686.0
2021-11-22 17:00:00	SPY	ETF	467.96	468.02	467.86	467.94	102749.0
2021-11-22 18:00:00	SPY	ETF	467.95	468.27	467.57	468.05	125370.0
2021-11-22 19:00:00	SPY	ETF	468.0	468.36	467.8	468.11	58389.0
2021-11-22 04:00:00	QQQ	ETF	404.75	405.82	404.75	405.69	70411.0
2021-11-22 05:00:00	QQQ	ETF	405.62	405.73	405.31	405.46	45442.0
2021-11-22 06:00:00	QQQ	ETF	405.38	405.78	405.38	405.68	60862.0
2021-11-22 07:00:00	QQQ	ETF	405.64	405.8	405.34	405.48	189244.0
2021-11-22 08:00:00	QQQ	ETF	405.48	405.96	404.292	405.89	175170.0
2021-11-22 09:00:00	QQQ	ETF	405.91	408.0	405.46	407.59	5586793.0
2021-11-22 10:00:00	QQQ	ETF	407.6	408.71	406.82	407.05	5732100.0
2021-11-22 11:00:00	QQQ	ETF	407.04	407.1998	401.12	402.321	10557648.0
2021-11-22 12:00:00	QQQ	ETF	402.32	403.68	401.34	402.9	7345503.0
2021-11-22 13:00:00	QQQ	ETF	402.89	403.44	402.07	402.4915	3374536.0
2021-11-22 14:00:00	QQQ	ETF	402.51	404.12	402.43	403.9301	3227375.0
2021-11-22 15:00:00	QQQ	ETF	403.96	404.625	399.19	399.34	8657716.0
2021-11-22 16:00:00	QQQ	ETF	399.34	399.95	398.91	399.74	1557891.0
2021-11-22 17:00:00	QQQ	ETF	399.65	399.76	399.3	399.53	102366.0
2021-11-22 18:00:00	QQQ	ETF	399.54	400.0504	399.53	399.7	214051.0
2021-11-22 19:00:00	QQQ	ETF	399.66	400.01	399.39	399.85	113200.0
2021-11-22 04:00:00	IWM	ETF	234.0	234.26	233.96	234.18	26583.0
2021-11-22 05:00:00	IWM	ETF	234.15	234.5	234.15	234.5	6320.0
2021-11-22 06:00:00	IWM	ETF	234.54	235.2	234.09	234.11	46955.0
2021-11-22 07:00:00	IWM	ETF	234.02	234.4	233.92	234.24	112999.0
2021-11-22 08:00:00	IWM	ETF	234.18	234.9496	233.4	234.15	82801.0
2021-11-22 09:00:00	IWM	ETF	234.11	235.42	232.63	234.64	3960537.0
2021-11-22 10:00:00	IWM	ETF	234.64	235.74	234.64	234.89	4009987.0
2021-11-22 11:00:00	IWM	ETF	234.88	235.2	231.7	232.47	4165867.0
2021-11-22 12:00:00	IWM	ETF	232.48	233.07	231.88	232.74	2887750.0
2021-11-22 13:00:00	IWM	ETF	232.75	233.115	232.36	232.85	1538314.0
2021-11-22 14:00:00	IWM	ETF	232.865	234.01	232.73	233.81	1600119.0
2021-11-22 15:00:00	IWM	ETF	233.82	234.29	231.62	231.73	4212462.0
2021-11-22 16:00:00	IWM	ETF	231.73	232.07	231.15	232.03	1770520.0
2021-11-22 17:00:00	IWM	ETF	231.87	232.05	231.73	231.86	67992.0
2021-11-22 18:00:00	IWM	ETF	231.96	232.31	231.73	232.21	39274.0
2021-11-22 19:00:00	IWM	ETF	232.08	232.34	231.96	231.96	43636.0
2021-11-22 04:00:00	DIA	ETF	357.16	357.18	357.07	357.18	400.0
2021-11-22 05:00:00	DIA	ETF	357.38	357.38	357.17	357.25	8875.0

> showing 50 of 15,957 rows — these rows as CSV

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