PREVIEW / etf_1hour / 2022-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-13.parquet
  size:    459 KB
  rows:    16,237

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-13 04:00:00	SPY	ETF	470.82	470.93	470.44	470.83	8300.0
2022-01-13 05:00:00	SPY	ETF	471.0	471.45	470.93	471.2	24683.0
2022-01-13 06:00:00	SPY	ETF	471.27	471.59	470.79	470.79	21856.0
2022-01-13 07:00:00	SPY	ETF	470.79	471.43	470.79	471.29	63826.0
2022-01-13 08:00:00	SPY	ETF	470.9504	472.14	470.0	471.99	362204.0
2022-01-13 09:00:00	SPY	ETF	471.98	472.88	471.75	472.36	4347362.0
2022-01-13 10:00:00	SPY	ETF	472.34	472.53	469.18	469.9499	7968019.0
2022-01-13 11:00:00	SPY	ETF	469.91	471.355	469.44	470.91	6337571.0
2022-01-13 12:00:00	SPY	ETF	470.9	470.905	466.91	467.6201	9195804.0
2022-01-13 13:00:00	SPY	ETF	467.61	468.86	466.97	468.6596	6360148.0
2022-01-13 14:00:00	SPY	ETF	468.66	469.2067	466.78	467.34	6445064.0
2022-01-13 15:00:00	SPY	ETF	467.34	467.38	463.44	464.54	21180641.0
2022-01-13 16:00:00	SPY	ETF	464.54	467.392	463.9	464.53	5485937.0
2022-01-13 17:00:00	SPY	ETF	464.33	464.58	464.33	464.58	80714.0
2022-01-13 18:00:00	SPY	ETF	464.59	464.98	464.53	464.65	178329.0
2022-01-13 19:00:00	SPY	ETF	464.75	464.92	463.71	464.68	124190.0
2022-01-13 04:00:00	QQQ	ETF	387.34	387.34	386.71	387.16	26722.0
2022-01-13 05:00:00	QQQ	ETF	387.39	388.04	387.35	387.57	48011.0
2022-01-13 06:00:00	QQQ	ETF	387.71	387.85	386.99	387.01	36826.0
2022-01-13 07:00:00	QQQ	ETF	387.0	387.85	387.0	387.67	141973.0
2022-01-13 08:00:00	QQQ	ETF	387.68	388.8	386.45	388.52	793655.0
2022-01-13 09:00:00	QQQ	ETF	388.52	389.47	387.88	388.48	5446363.0
2022-01-13 10:00:00	QQQ	ETF	388.47	388.67	383.29	384.19	10618271.0
2022-01-13 11:00:00	QQQ	ETF	384.18	385.81	383.35	385.0662	6381091.0
2022-01-13 12:00:00	QQQ	ETF	385.06	385.06	380.07	381.1	10104320.0
2022-01-13 13:00:00	QQQ	ETF	381.1	382.47	380.39	382.09	6281801.0
2022-01-13 14:00:00	QQQ	ETF	382.12	382.96	380.08	380.815	5727518.0
2022-01-13 15:00:00	QQQ	ETF	380.85	380.86	376.7	377.65	14151666.0
2022-01-13 16:00:00	QQQ	ETF	377.65	378.8389	377.03	377.71	1869219.0
2022-01-13 17:00:00	QQQ	ETF	377.79	377.87	377.56	377.79	272117.0
2022-01-13 18:00:00	QQQ	ETF	377.85	378.07	377.51	377.66	181509.0
2022-01-13 19:00:00	QQQ	ETF	377.61	377.89	376.61	377.61	228800.0
2022-01-13 04:00:00	IWM	ETF	215.66	215.85	215.45	215.84	14970.0
2022-01-13 05:00:00	IWM	ETF	215.84	216.17	215.74	216.1	24776.0
2022-01-13 06:00:00	IWM	ETF	216.2	216.29	215.89	215.89	17434.0
2022-01-13 07:00:00	IWM	ETF	216.03	216.09	215.8	215.9	79551.0
2022-01-13 08:00:00	IWM	ETF	215.9	216.75	215.6	216.61	271774.0
2022-01-13 09:00:00	IWM	ETF	216.61	218.19	216.48	217.81	2972526.0
2022-01-13 10:00:00	IWM	ETF	217.82	217.96	215.28	215.78	3817005.0
2022-01-13 11:00:00	IWM	ETF	215.76	217.67	215.61	217.14	2444388.0
2022-01-13 12:00:00	IWM	ETF	217.13	217.13	215.0	215.64	3365946.0
2022-01-13 13:00:00	IWM	ETF	215.64	216.46	215.29	216.39	1743713.0
2022-01-13 14:00:00	IWM	ETF	216.38	216.73	215.53	216.24	2018523.0
2022-01-13 15:00:00	IWM	ETF	216.24	216.24	213.38	214.02	5927076.0
2022-01-13 16:00:00	IWM	ETF	214.01	214.29	213.61	214.11	1695761.0
2022-01-13 17:00:00	IWM	ETF	214.33	214.33	214.01	214.02	1000766.0
2022-01-13 18:00:00	IWM	ETF	214.17	214.4	214.05	214.05	45470.0
2022-01-13 19:00:00	IWM	ETF	214.15	214.15	213.57	213.81	120327.0
2022-01-13 04:00:00	DIA	ETF	362.52	362.52	362.52	362.52	171.0
2022-01-13 06:00:00	DIA	ETF	363.37	363.37	363.19	363.19	1900.0

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

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