PREVIEW / etf_1hour / 2022-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-16.parquet
  size:    453 KB
  rows:    16,255

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
2022-08-16 04:00:00	SPY	ETF	428.49	428.82	428.15	428.51	17377.0
2022-08-16 05:00:00	SPY	ETF	428.44	428.44	427.82	428.12	19974.0
2022-08-16 06:00:00	SPY	ETF	428.11	428.17	427.72	427.92	32599.0
2022-08-16 07:00:00	SPY	ETF	427.87	428.64	427.72	428.5	213399.0
2022-08-16 08:00:00	SPY	ETF	427.87	428.74	427.4	427.75	309693.0
2022-08-16 09:00:00	SPY	ETF	427.76	428.78	427.55	428.42	4019581.0
2022-08-16 10:00:00	SPY	ETF	428.41	428.4937	426.88	427.5	5411872.0
2022-08-16 11:00:00	SPY	ETF	427.5	430.36	427.43	430.18	5776707.0
2022-08-16 12:00:00	SPY	ETF	430.18	430.525	429.64	429.81	2963514.0
2022-08-16 13:00:00	SPY	ETF	429.815	431.08	429.66	430.9999	2861173.0
2022-08-16 14:00:00	SPY	ETF	430.99	431.73	428.14	429.1	7374436.0
2022-08-16 15:00:00	SPY	ETF	429.09	430.43	428.35	429.66	11892329.0
2022-08-16 16:00:00	SPY	ETF	429.67	429.99	429.19	429.94	2893830.0
2022-08-16 17:00:00	SPY	ETF	429.89	429.97	429.7	429.85	551932.0
2022-08-16 18:00:00	SPY	ETF	429.87	429.87	429.46	429.6	79362.0
2022-08-16 19:00:00	SPY	ETF	429.6	429.8	429.35	429.7	53367.0
2022-08-16 04:00:00	QQQ	ETF	332.38	333.1	332.25	332.79	18538.0
2022-08-16 05:00:00	QQQ	ETF	332.6	332.6	332.15	332.28	28995.0
2022-08-16 06:00:00	QQQ	ETF	332.28	332.48	332.03	332.31	30554.0
2022-08-16 07:00:00	QQQ	ETF	332.39	332.89	332.17	332.59	138285.0
2022-08-16 08:00:00	QQQ	ETF	332.42	333.309	331.76	332.17	356308.0
2022-08-16 09:00:00	QQQ	ETF	332.15	332.47	330.63	331.3376	4088664.0
2022-08-16 10:00:00	QQQ	ETF	331.33	331.37	329.16	329.99	4967273.0
2022-08-16 11:00:00	QQQ	ETF	329.97	333.0	329.89	332.825	3856803.0
2022-08-16 12:00:00	QQQ	ETF	332.838	333.06	331.79	332.23	3110632.0
2022-08-16 13:00:00	QQQ	ETF	332.26	333.5	332.15	333.4	2350477.0
2022-08-16 14:00:00	QQQ	ETF	333.43	334.4209	330.58	331.54	5475523.0
2022-08-16 15:00:00	QQQ	ETF	331.52	333.11	330.83	332.31	5963479.0
2022-08-16 16:00:00	QQQ	ETF	332.3	332.54	331.99	332.52	847886.0
2022-08-16 17:00:00	QQQ	ETF	332.57	332.58	332.28	332.35	29623.0
2022-08-16 18:00:00	QQQ	ETF	332.37	332.41	332.08	332.15	69082.0
2022-08-16 19:00:00	QQQ	ETF	332.15	332.35	331.99	332.31	41231.0
2022-08-16 04:00:00	IWM	ETF	201.01	201.3	200.87	201.03	11091.0
2022-08-16 05:00:00	IWM	ETF	200.98	200.98	200.63	200.83	8862.0
2022-08-16 06:00:00	IWM	ETF	200.79	200.87	200.6	200.69	15884.0
2022-08-16 07:00:00	IWM	ETF	200.69	201.3	200.57	200.99	78077.0
2022-08-16 08:00:00	IWM	ETF	200.79	201.01	200.33	200.53	53771.0
2022-08-16 09:00:00	IWM	ETF	200.57	200.72	199.53	199.9899	1669874.0
2022-08-16 10:00:00	IWM	ETF	199.98	200.07	199.025	199.35	1803849.0
2022-08-16 11:00:00	IWM	ETF	199.34	201.07	199.23	200.99	1538112.0
2022-08-16 12:00:00	IWM	ETF	200.9901	201.37	200.85	200.96	1283742.0
2022-08-16 13:00:00	IWM	ETF	200.97	201.7	200.92	201.66	949844.0
2022-08-16 14:00:00	IWM	ETF	201.65	201.99	200.25	200.75	1758523.0
2022-08-16 15:00:00	IWM	ETF	200.7	201.085	200.29	200.99	2717088.0
2022-08-16 16:00:00	IWM	ETF	200.98	201.25	200.7	201.23	1083343.0
2022-08-16 17:00:00	IWM	ETF	201.19	201.28	200.99	201.26	1437118.0
2022-08-16 18:00:00	IWM	ETF	201.16	201.19	200.94	201.02	27855.0
2022-08-16 19:00:00	IWM	ETF	201.0	201.13	200.83	201.1	37997.0
2022-08-16 04:00:00	DIA	ETF	339.28	339.28	339.28	339.28	300.0
2022-08-16 07:00:00	DIA	ETF	338.63	339.3	338.6	339.3	1960.0

> showing 50 of 16,255 rows — these rows as CSV

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