PREVIEW / etf_1hour / 2022-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-18.parquet
  size:    442 KB
  rows:    15,637

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-18 04:00:00	SPY	ETF	425.67	426.41	425.41	426.38	34593.0
2022-08-18 05:00:00	SPY	ETF	426.43	427.3	426.4	427.28	27369.0
2022-08-18 06:00:00	SPY	ETF	427.35	427.78	427.05	427.18	45185.0
2022-08-18 07:00:00	SPY	ETF	427.13	427.67	426.95	427.67	177367.0
2022-08-18 08:00:00	SPY	ETF	425.55	428.35	425.42	427.32	854076.0
2022-08-18 09:00:00	SPY	ETF	427.48	427.54	425.81	426.0201	3618296.0
2022-08-18 10:00:00	SPY	ETF	426.01	427.3598	425.5	426.736	5403493.0
2022-08-18 11:00:00	SPY	ETF	426.74	428.14	426.13	427.6499	4328946.0
2022-08-18 12:00:00	SPY	ETF	427.6406	427.92	425.88	426.39	3704771.0
2022-08-18 13:00:00	SPY	ETF	426.39	427.39	426.19	426.9957	3677654.0
2022-08-18 14:00:00	SPY	ETF	426.99	427.85	426.755	427.6328	2970622.0
2022-08-18 15:00:00	SPY	ETF	427.64	428.61	427.27	427.83	9156663.0
2022-08-18 16:00:00	SPY	ETF	427.83	428.0	427.52	427.88	4021026.0
2022-08-18 17:00:00	SPY	ETF	427.91	427.91	427.74	427.75	52088.0
2022-08-18 18:00:00	SPY	ETF	427.75	427.8	427.43	427.48	58229.0
2022-08-18 19:00:00	SPY	ETF	427.57	427.65	427.41	427.62	89669.0
2022-08-18 04:00:00	QQQ	ETF	327.46	328.12	327.2	328.09	43968.0
2022-08-18 05:00:00	QQQ	ETF	328.08	329.07	328.02	328.86	34980.0
2022-08-18 06:00:00	QQQ	ETF	329.03	329.37	328.55	328.65	37032.0
2022-08-18 07:00:00	QQQ	ETF	328.59	329.38	328.54	329.37	177635.0
2022-08-18 08:00:00	QQQ	ETF	328.5113	330.06	326.9	329.12	454692.0
2022-08-18 09:00:00	QQQ	ETF	329.12	329.13	327.12	327.5001	3736259.0
2022-08-18 10:00:00	QQQ	ETF	327.49	329.4801	326.79	328.9191	4235196.0
2022-08-18 11:00:00	QQQ	ETF	328.92	330.49	328.36	330.0	3554355.0
2022-08-18 12:00:00	QQQ	ETF	330.03	330.31	328.2601	328.94	2917871.0
2022-08-18 13:00:00	QQQ	ETF	328.9299	330.11	328.68	329.6099	2544965.0
2022-08-18 14:00:00	QQQ	ETF	329.62	329.9499	328.98	329.635	3009280.0
2022-08-18 15:00:00	QQQ	ETF	329.64	330.38	328.91	329.32	6864135.0
2022-08-18 16:00:00	QQQ	ETF	329.28	329.64	329.2	329.58	2005818.0
2022-08-18 17:00:00	QQQ	ETF	329.58	329.6	329.3	329.34	14258.0
2022-08-18 18:00:00	QQQ	ETF	329.41	329.43	329.15	329.25	41674.0
2022-08-18 19:00:00	QQQ	ETF	329.25	329.3	329.1	329.3	59592.0
2022-08-18 04:00:00	IWM	ETF	197.32	197.79	197.16	197.79	17344.0
2022-08-18 05:00:00	IWM	ETF	197.83	198.3	197.73	198.29	23085.0
2022-08-18 06:00:00	IWM	ETF	198.3	198.55	198.06	198.12	43739.0
2022-08-18 07:00:00	IWM	ETF	198.07	198.38	198.01	198.38	43466.0
2022-08-18 08:00:00	IWM	ETF	198.16	198.69	197.61	198.28	46643.0
2022-08-18 09:00:00	IWM	ETF	198.29	198.3	197.08	197.44	1549958.0
2022-08-18 10:00:00	IWM	ETF	197.45	198.4	196.9	198.13	1519624.0
2022-08-18 11:00:00	IWM	ETF	198.13	198.695	197.82	198.42	1612753.0
2022-08-18 12:00:00	IWM	ETF	198.43	198.55	197.3469	197.52	877818.0
2022-08-18 13:00:00	IWM	ETF	197.52	198.19	197.43	198.03	719417.0
2022-08-18 14:00:00	IWM	ETF	198.02	198.88	197.985	198.78	1234731.0
2022-08-18 15:00:00	IWM	ETF	198.77	199.25	198.7285	198.94	2688562.0
2022-08-18 16:00:00	IWM	ETF	198.92	199.07	198.5209	198.76	2433151.0
2022-08-18 17:00:00	IWM	ETF	198.75	198.88	198.6	198.62	29351.0
2022-08-18 18:00:00	IWM	ETF	198.69	198.75	198.56	198.66	43158.0
2022-08-18 19:00:00	IWM	ETF	198.61	198.69	198.52	198.65	12957.0
2022-08-18 04:00:00	DIA	ETF	339.65	339.9	339.46	339.9	1700.0
2022-08-18 05:00:00	DIA	ETF	340.39	340.58	340.39	340.42	1500.0

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

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