PREVIEW / etf_1hour / 2021-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-15.parquet
  size:    444 KB
  rows:    15,792

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
2021-12-15 04:00:00	SPY	ETF	463.66	463.85	462.61	463.12	35238.0
2021-12-15 05:00:00	SPY	ETF	463.01	463.55	462.96	463.55	99382.0
2021-12-15 06:00:00	SPY	ETF	463.63	463.63	462.69	463.06	86555.0
2021-12-15 07:00:00	SPY	ETF	463.06	463.68	463.06	463.24	128346.0
2021-12-15 08:00:00	SPY	ETF	463.4899	463.97	462.7504	463.25	282642.0
2021-12-15 09:00:00	SPY	ETF	463.23	463.73	461.39	461.675	5426968.0
2021-12-15 10:00:00	SPY	ETF	461.71	462.97	461.16	462.13	6234320.0
2021-12-15 11:00:00	SPY	ETF	462.13	462.4	460.7922	461.42	5323670.0
2021-12-15 12:00:00	SPY	ETF	461.4	462.28	460.95	462.16	3525716.0
2021-12-15 13:00:00	SPY	ETF	462.17	462.8	461.82	462.64	3810338.0
2021-12-15 14:00:00	SPY	ETF	462.61	465.88	460.74	464.8	20460906.0
2021-12-15 15:00:00	SPY	ETF	464.8	470.86	464.72	470.58	27536364.0
2021-12-15 16:00:00	SPY	ETF	470.58	471.11	470.06	470.82	10029633.0
2021-12-15 17:00:00	SPY	ETF	470.8	470.99	470.77	470.86	137811.0
2021-12-15 18:00:00	SPY	ETF	470.85	471.7	470.6	471.24	189691.0
2021-12-15 19:00:00	SPY	ETF	471.3	471.3	470.6	470.91	207142.0
2021-12-15 04:00:00	QQQ	ETF	388.53	388.67	386.5	387.27	44911.0
2021-12-15 05:00:00	QQQ	ETF	387.1	387.63	386.9	387.61	21955.0
2021-12-15 06:00:00	QQQ	ETF	387.68	387.68	386.81	387.41	31960.0
2021-12-15 07:00:00	QQQ	ETF	387.39	388.27	387.39	387.8	141273.0
2021-12-15 08:00:00	QQQ	ETF	387.69	389.31	386.83	387.84	289869.0
2021-12-15 09:00:00	QQQ	ETF	387.82	388.44	385.9	386.32	5622669.0
2021-12-15 10:00:00	QQQ	ETF	386.32	388.0	385.511	386.51	5104929.0
2021-12-15 11:00:00	QQQ	ETF	386.5	386.72	384.42	384.68	4486024.0
2021-12-15 12:00:00	QQQ	ETF	384.66	385.44	383.88	385.23	3494930.0
2021-12-15 13:00:00	QQQ	ETF	385.24	386.45	384.98	386.38	2679160.0
2021-12-15 14:00:00	QQQ	ETF	386.34	391.14	384.11	390.05	16981709.0
2021-12-15 15:00:00	QQQ	ETF	390.06	397.4198	389.9301	397.05	12844373.0
2021-12-15 16:00:00	QQQ	ETF	397.02	397.47	396.7	397.1	2366362.0
2021-12-15 17:00:00	QQQ	ETF	397.11	397.45	397.05	397.34	103248.0
2021-12-15 18:00:00	QQQ	ETF	397.25	398.38	397.21	398.07	179751.0
2021-12-15 19:00:00	QQQ	ETF	398.0	398.0	397.51	397.71	271734.0
2021-12-15 04:00:00	IWM	ETF	214.61	214.66	214.05	214.18	9074.0
2021-12-15 05:00:00	IWM	ETF	214.18	214.41	214.03	214.3	18813.0
2021-12-15 06:00:00	IWM	ETF	214.4	214.4	213.65	213.98	84630.0
2021-12-15 07:00:00	IWM	ETF	213.94	214.46	213.94	214.13	35274.0
2021-12-15 08:00:00	IWM	ETF	214.27	214.59	213.97	214.25	73404.0
2021-12-15 09:00:00	IWM	ETF	214.35	214.4801	212.07	212.28	3009911.0
2021-12-15 10:00:00	IWM	ETF	212.27	212.72	211.305	211.6	4796144.0
2021-12-15 11:00:00	IWM	ETF	211.59	212.27	211.08	212.08	3828811.0
2021-12-15 12:00:00	IWM	ETF	212.08	212.53	211.4	212.38	2379266.0
2021-12-15 13:00:00	IWM	ETF	212.38	213.05	212.13	212.96	2685250.0
2021-12-15 14:00:00	IWM	ETF	212.95	215.7	211.68	214.11	9399285.0
2021-12-15 15:00:00	IWM	ETF	214.11	218.16	214.07	217.715	12700121.0
2021-12-15 16:00:00	IWM	ETF	217.58	218.11	217.58	217.96	2057287.0
2021-12-15 17:00:00	IWM	ETF	218.05	218.24	217.9	218.17	61742.0
2021-12-15 18:00:00	IWM	ETF	218.06	218.85	217.58	218.55	76534.0
2021-12-15 19:00:00	IWM	ETF	218.52	218.7	218.21	218.41	39929.0
2021-12-15 04:00:00	DIA	ETF	356.4	356.4	356.06	356.2	4900.0
2021-12-15 05:00:00	DIA	ETF	356.48	356.59	356.44	356.59	6400.0

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

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