PREVIEW / etf_1hour / 2022-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-11.parquet
  size:    452 KB
  rows:    16,111

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-11 04:00:00	SPY	ETF	465.99	467.91	465.97	467.55	74796.0
2022-01-11 05:00:00	SPY	ETF	467.59	468.06	467.34	467.45	30807.0
2022-01-11 06:00:00	SPY	ETF	467.47	467.47	466.84	466.96	44408.0
2022-01-11 07:00:00	SPY	ETF	466.81	467.19	466.24	466.24	127124.0
2022-01-11 08:00:00	SPY	ETF	467.0399	467.8896	464.93	465.45	483590.0
2022-01-11 09:00:00	SPY	ETF	465.37	465.48	462.05	462.86	9384045.0
2022-01-11 10:00:00	SPY	ETF	462.86	464.97	462.35	463.43	10609674.0
2022-01-11 11:00:00	SPY	ETF	463.44	468.06	463.34	467.55	9539952.0
2022-01-11 12:00:00	SPY	ETF	467.55	468.01	466.66	467.76	4398714.0
2022-01-11 13:00:00	SPY	ETF	467.76	468.57	466.99	468.47	3826719.0
2022-01-11 14:00:00	SPY	ETF	468.46	469.39	467.7	468.885	4573766.0
2022-01-11 15:00:00	SPY	ETF	468.88	469.85	468.54	469.74	13000888.0
2022-01-11 16:00:00	SPY	ETF	469.72	469.97	469.1374	469.82	2470516.0
2022-01-11 17:00:00	SPY	ETF	469.66	469.79	469.6	469.75	81423.0
2022-01-11 18:00:00	SPY	ETF	469.7	469.98	469.55	469.65	97903.0
2022-01-11 19:00:00	SPY	ETF	469.62	470.17	469.6	469.93	65800.0
2022-01-11 04:00:00	QQQ	ETF	380.76	383.3	380.44	383.0	124873.0
2022-01-11 05:00:00	QQQ	ETF	382.94	383.43	382.68	382.91	32350.0
2022-01-11 06:00:00	QQQ	ETF	382.9	382.9	382.03	382.14	85873.0
2022-01-11 07:00:00	QQQ	ETF	382.11	382.53	381.32	381.4	223652.0
2022-01-11 08:00:00	QQQ	ETF	382.49	383.2796	379.64	380.22	553270.0
2022-01-11 09:00:00	QQQ	ETF	380.05	380.12	377.2182	379.0	10295016.0
2022-01-11 10:00:00	QQQ	ETF	379.02	381.53	377.93	379.38	12786703.0
2022-01-11 11:00:00	QQQ	ETF	379.4	385.67	379.229	385.5399	10560526.0
2022-01-11 12:00:00	QQQ	ETF	385.56	385.79	383.68	384.34	5237798.0
2022-01-11 13:00:00	QQQ	ETF	384.35	385.35	383.36	385.1799	4630423.0
2022-01-11 14:00:00	QQQ	ETF	385.13	385.9589	384.18	385.325	4252065.0
2022-01-11 15:00:00	QQQ	ETF	385.34	385.9899	384.6301	385.9	6533453.0
2022-01-11 16:00:00	QQQ	ETF	385.89	386.04	380.11	385.7	994662.0
2022-01-11 17:00:00	QQQ	ETF	385.7	385.82	385.45	385.7	83843.0
2022-01-11 18:00:00	QQQ	ETF	385.7	386.05	385.42	385.52	80335.0
2022-01-11 19:00:00	QQQ	ETF	385.58	386.14	385.55	385.86	54988.0
2022-01-11 04:00:00	IWM	ETF	215.53	216.39	215.5	216.13	239021.0
2022-01-11 05:00:00	IWM	ETF	216.14	216.39	215.89	215.96	179950.0
2022-01-11 06:00:00	IWM	ETF	216.06	216.26	215.79	215.96	162912.0
2022-01-11 07:00:00	IWM	ETF	215.92	216.09	215.54	215.56	159323.0
2022-01-11 08:00:00	IWM	ETF	215.73	216.0596	215.1	215.29	299323.0
2022-01-11 09:00:00	IWM	ETF	215.36	215.69	212.96	214.11	5736048.0
2022-01-11 10:00:00	IWM	ETF	214.13	215.46	213.32	213.74	4984417.0
2022-01-11 11:00:00	IWM	ETF	213.76	216.53	213.66	216.53	3794628.0
2022-01-11 12:00:00	IWM	ETF	216.53	216.74	215.84	216.68	2155568.0
2022-01-11 13:00:00	IWM	ETF	216.69	217.525	216.23	217.47	1843232.0
2022-01-11 14:00:00	IWM	ETF	217.46	217.61	216.97	217.31	1898056.0
2022-01-11 15:00:00	IWM	ETF	217.31	217.83	217.075	217.58	3680216.0
2022-01-11 16:00:00	IWM	ETF	217.61	217.75	217.41	217.48	1226798.0
2022-01-11 17:00:00	IWM	ETF	217.58	217.61	217.43	217.61	237464.0
2022-01-11 18:00:00	IWM	ETF	217.52	217.66	217.41	217.44	20158.0
2022-01-11 19:00:00	IWM	ETF	217.55	217.89	217.55	217.69	59479.0
2022-01-11 04:00:00	DIA	ETF	361.33	362.06	361.33	361.98	3595.0
2022-01-11 05:00:00	DIA	ETF	361.99	361.99	361.99	361.99	200.0

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

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