PREVIEW / etf_1hour / 2022-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-06.parquet
  size:    453 KB
  rows:    16,354

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-01-06 04:00:00	SPY	ETF	468.46	468.49	467.55	468.17	43725.0
2022-01-06 05:00:00	SPY	ETF	468.29	469.46	468.09	468.78	64326.0
2022-01-06 06:00:00	SPY	ETF	468.78	469.17	468.06	468.29	72844.0
2022-01-06 07:00:00	SPY	ETF	468.24	468.93	467.87	468.28	184400.0
2022-01-06 08:00:00	SPY	ETF	468.28	469.0504	466.4	468.52	495681.0
2022-01-06 09:00:00	SPY	ETF	468.49	470.395	466.81	467.05	9514768.0
2022-01-06 10:00:00	SPY	ETF	467.04	469.72	465.43	468.72	14239634.0
2022-01-06 11:00:00	SPY	ETF	468.74	469.985	468.03	469.22	7648370.0
2022-01-06 12:00:00	SPY	ETF	469.22	470.82	468.69	469.56	5986188.0
2022-01-06 13:00:00	SPY	ETF	469.56	469.975	468.4	469.07	4499835.0
2022-01-06 14:00:00	SPY	ETF	469.07	469.68	468.28	469.42	5679218.0
2022-01-06 15:00:00	SPY	ETF	469.39	470.175	467.09	467.93	14093606.0
2022-01-06 16:00:00	SPY	ETF	467.93	468.71	467.8	468.58	2928215.0
2022-01-06 17:00:00	SPY	ETF	468.51	468.67	468.51	468.65	32643.0
2022-01-06 18:00:00	SPY	ETF	468.68	469.18	467.94	469.18	95564.0
2022-01-06 19:00:00	SPY	ETF	469.06	469.69	469.06	469.59	64090.0
2022-01-06 04:00:00	QQQ	ETF	384.15	384.15	382.78	383.4	75814.0
2022-01-06 05:00:00	QQQ	ETF	383.53	384.18	383.19	383.19	106854.0
2022-01-06 06:00:00	QQQ	ETF	383.44	383.63	382.21	382.48	129324.0
2022-01-06 07:00:00	QQQ	ETF	382.41	383.16	381.73	382.22	287620.0
2022-01-06 08:00:00	QQQ	ETF	382.1801	384.578	380.97	382.5	588451.0
2022-01-06 09:00:00	QQQ	ETF	382.3	386.26	381.94	383.07	10209352.0
2022-01-06 10:00:00	QQQ	ETF	383.05	386.7676	380.13	386.03	16805360.0
2022-01-06 11:00:00	QQQ	ETF	386.03	387.35	384.32	385.81	7808039.0
2022-01-06 12:00:00	QQQ	ETF	385.87	387.12	384.83	385.56	4327644.0
2022-01-06 13:00:00	QQQ	ETF	385.58	385.96	384.29	385.59	3681159.0
2022-01-06 14:00:00	QQQ	ETF	385.58	386.33	384.59	385.47	3802162.0
2022-01-06 15:00:00	QQQ	ETF	385.4782	386.65	383.06	384.03	7214415.0
2022-01-06 16:00:00	QQQ	ETF	384.03	384.91	383.9	384.9	1206550.0
2022-01-06 17:00:00	QQQ	ETF	384.92	385.0	384.71	384.9	35859.0
2022-01-06 18:00:00	QQQ	ETF	384.99	385.5	384.99	385.5	132374.0
2022-01-06 19:00:00	QQQ	ETF	385.5	386.2	385.47	386.2	127947.0
2022-01-06 04:00:00	IWM	ETF	217.24	217.39	216.82	217.34	43239.0
2022-01-06 05:00:00	IWM	ETF	217.34	218.27	217.29	218.06	49786.0
2022-01-06 06:00:00	IWM	ETF	218.15	218.21	217.51	217.79	120000.0
2022-01-06 07:00:00	IWM	ETF	217.91	218.07	217.59	218.02	74578.0
2022-01-06 08:00:00	IWM	ETF	218.04	218.31	216.05	218.0	203738.0
2022-01-06 09:00:00	IWM	ETF	218.01	219.88	217.01	217.19	5934961.0
2022-01-06 10:00:00	IWM	ETF	217.18	219.17	215.82	218.61	7260636.0
2022-01-06 11:00:00	IWM	ETF	218.64	220.03	218.25	219.87	3884240.0
2022-01-06 12:00:00	IWM	ETF	219.88	220.42	219.64	219.99	2691676.0
2022-01-06 13:00:00	IWM	ETF	219.98	220.07	218.67	219.43	2136681.0
2022-01-06 14:00:00	IWM	ETF	219.42	220.0	218.95	219.91	2212152.0
2022-01-06 15:00:00	IWM	ETF	219.9	220.01	218.17	218.615	4344828.0
2022-01-06 16:00:00	IWM	ETF	218.61	219.13	218.39	219.07	1550791.0
2022-01-06 17:00:00	IWM	ETF	218.82	219.2	218.82	219.2	19923.0
2022-01-06 18:00:00	IWM	ETF	219.2	219.49	218.6	219.4496	61666.0
2022-01-06 19:00:00	IWM	ETF	219.4	219.77	219.37	219.74	32585.0
2022-01-06 04:00:00	DIA	ETF	364.2	364.4	364.08	364.08	6068.0
2022-01-06 05:00:00	DIA	ETF	364.72	364.91	364.72	364.91	2000.0

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

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