PREVIEW / etf_1hour / 2022-01-12

all etf 1-hour files

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

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-12 04:00:00	SPY	ETF	469.0	470.36	468.91	470.31	24856.0
2022-01-12 05:00:00	SPY	ETF	470.4	470.49	469.92	470.42	27950.0
2022-01-12 06:00:00	SPY	ETF	470.55	470.65	470.17	470.17	24143.0
2022-01-12 07:00:00	SPY	ETF	470.12	470.57	469.87	470.18	73782.0
2022-01-12 08:00:00	SPY	ETF	470.06	472.25	469.13	472.1	1323694.0
2022-01-12 09:00:00	SPY	ETF	472.12	472.68	470.89	472.6263	6912921.0
2022-01-12 10:00:00	SPY	ETF	472.64	473.2	470.12	470.7425	8869920.0
2022-01-12 11:00:00	SPY	ETF	470.74	471.53	468.94	470.97	7134471.0
2022-01-12 12:00:00	SPY	ETF	470.99	471.87	470.25	471.7	3772599.0
2022-01-12 13:00:00	SPY	ETF	471.71	471.77	470.17	470.36	4279367.0
2022-01-12 14:00:00	SPY	ETF	470.3506	471.19	469.77	470.9199	5018773.0
2022-01-12 15:00:00	SPY	ETF	470.92	471.67	470.13	471.07	11476002.0
2022-01-12 16:00:00	SPY	ETF	471.08	471.57	470.9761	471.13	3254841.0
2022-01-12 17:00:00	SPY	ETF	471.03	471.19	471.01	471.06	63442.0
2022-01-12 18:00:00	SPY	ETF	471.09	471.26	470.85	470.91	85980.0
2022-01-12 19:00:00	SPY	ETF	470.92	471.03	470.59	470.77	71480.0
2022-01-12 04:00:00	QQQ	ETF	385.7	386.59	384.39	386.47	66796.0
2022-01-12 05:00:00	QQQ	ETF	386.56	387.07	386.19	386.97	34337.0
2022-01-12 06:00:00	QQQ	ETF	387.07	387.18	386.4	386.41	52870.0
2022-01-12 07:00:00	QQQ	ETF	386.47	386.98	385.91	386.61	327056.0
2022-01-12 08:00:00	QQQ	ETF	387.12	389.33	385.0	389.22	1819328.0
2022-01-12 09:00:00	QQQ	ETF	389.28	389.75	387.14	389.13	7768137.0
2022-01-12 10:00:00	QQQ	ETF	389.13	390.2	385.97	386.51	9808157.0
2022-01-12 11:00:00	QQQ	ETF	386.49	388.05	385.01	387.51	6468848.0
2022-01-12 12:00:00	QQQ	ETF	387.52	388.79	386.5601	388.6	3424885.0
2022-01-12 13:00:00	QQQ	ETF	388.62	388.69	386.89	387.185	3388357.0
2022-01-12 14:00:00	QQQ	ETF	387.19	387.92	386.52	387.48	2857402.0
2022-01-12 15:00:00	QQQ	ETF	387.48	387.78	386.46	387.42	6811867.0
2022-01-12 16:00:00	QQQ	ETF	387.42	388.0	387.35	387.44	1090466.0
2022-01-12 17:00:00	QQQ	ETF	387.37	387.55	387.27	387.32	50988.0
2022-01-12 18:00:00	QQQ	ETF	387.32	387.45	387.06	387.26	58764.0
2022-01-12 19:00:00	QQQ	ETF	387.32	387.35	386.96	387.04	83984.0
2022-01-12 04:00:00	IWM	ETF	217.2	217.96	217.2	217.89	109849.0
2022-01-12 05:00:00	IWM	ETF	218.01	218.01	217.34	217.65	167489.0
2022-01-12 06:00:00	IWM	ETF	217.65	217.82	217.37	217.49	135899.0
2022-01-12 07:00:00	IWM	ETF	217.46	217.65	217.28	217.49	152572.0
2022-01-12 08:00:00	IWM	ETF	217.52	219.0	217.43	218.83	1032811.0
2022-01-12 09:00:00	IWM	ETF	218.82	219.38	218.32	219.05	2844317.0
2022-01-12 10:00:00	IWM	ETF	219.05	219.14	215.871	216.38	5164251.0
2022-01-12 11:00:00	IWM	ETF	216.38	216.66	214.64	216.095	4264705.0
2022-01-12 12:00:00	IWM	ETF	216.115	217.1	215.66	217.01	1781753.0
2022-01-12 13:00:00	IWM	ETF	217.02	217.39	216.49	216.5701	2515519.0
2022-01-12 14:00:00	IWM	ETF	216.57	216.89	216.06	216.7257	1626227.0
2022-01-12 15:00:00	IWM	ETF	216.75	216.79	215.69	215.92	3787816.0
2022-01-12 16:00:00	IWM	ETF	215.92	216.43	215.92	216.1	1194097.0
2022-01-12 17:00:00	IWM	ETF	216.01	216.25	215.85	215.98	47553.0
2022-01-12 18:00:00	IWM	ETF	215.98	216.19	215.9104	215.95	34659.0
2022-01-12 19:00:00	IWM	ETF	215.91	215.96	215.65	215.65	29947.0
2022-01-12 04:00:00	DIA	ETF	362.32	362.93	362.32	362.93	534.0
2022-01-12 05:00:00	DIA	ETF	362.79	362.87	362.79	362.87	399.0

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

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