PREVIEW / etf_1hour / 2021-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-17.parquet
  size:    443 KB
  rows:    15,813

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-17 04:00:00	SPY	ETF	464.91	464.91	462.5	464.08	89044.0
2021-12-17 05:00:00	SPY	ETF	464.21	464.31	462.8	463.32	56450.0
2021-12-17 06:00:00	SPY	ETF	463.33	463.84	463.04	463.79	40129.0
2021-12-17 07:00:00	SPY	ETF	463.81	463.92	461.46	461.98	486357.0
2021-12-17 08:00:00	SPY	ETF	463.83	465.05	461.5	462.34	525191.0
2021-12-17 09:00:00	SPY	ETF	462.35	462.47	459.31	460.43	12111907.0
2021-12-17 10:00:00	SPY	ETF	460.45	463.96	458.06	463.25	15723038.0
2021-12-17 11:00:00	SPY	ETF	463.29	464.74	460.32	461.38	12022398.0
2021-12-17 12:00:00	SPY	ETF	461.37	462.65	459.83	461.76	7449684.0
2021-12-17 13:00:00	SPY	ETF	461.74	463.72	461.03	463.59	5788066.0
2021-12-17 14:00:00	SPY	ETF	463.6	463.69	461.77	462.2701	6723305.0
2021-12-17 15:00:00	SPY	ETF	462.28	463.26	459.52	459.9	20287988.0
2021-12-17 16:00:00	SPY	ETF	459.9	461.2	459.72	460.96	6474744.0
2021-12-17 17:00:00	SPY	ETF	460.99	461.29	459.87	461.2	611208.0
2021-12-17 18:00:00	SPY	ETF	461.21	461.57	461.05	461.55	80926.0
2021-12-17 19:00:00	SPY	ETF	461.55	461.56	461.2	461.56	33372.0
2021-12-17 04:00:00	QQQ	ETF	385.41	385.41	382.41	384.53	139969.0
2021-12-17 05:00:00	QQQ	ETF	384.61	384.62	383.04	383.5	85795.0
2021-12-17 06:00:00	QQQ	ETF	383.5	384.52	383.5	384.41	190070.0
2021-12-17 07:00:00	QQQ	ETF	384.5	384.55	382.06	382.74	305442.0
2021-12-17 08:00:00	QQQ	ETF	384.48	387.13	382.11	383.66	918552.0
2021-12-17 09:00:00	QQQ	ETF	383.66	386.39	381.88	384.93	10211817.0
2021-12-17 10:00:00	QQQ	ETF	384.9	388.19	381.77	387.74	12751957.0
2021-12-17 11:00:00	QQQ	ETF	387.75	389.19	384.42	385.795	7504668.0
2021-12-17 12:00:00	QQQ	ETF	385.75	386.9	383.99	385.7687	5051611.0
2021-12-17 13:00:00	QQQ	ETF	385.7331	387.97	385.05	387.8401	3570638.0
2021-12-17 14:00:00	QQQ	ETF	387.87	388.24	386.27	386.94	4514114.0
2021-12-17 15:00:00	QQQ	ETF	386.97	388.105	384.54	384.92	9628069.0
2021-12-17 16:00:00	QQQ	ETF	384.93	386.17	384.85	386.1	2809770.0
2021-12-17 17:00:00	QQQ	ETF	386.11	386.15	385.89	386.09	854994.0
2021-12-17 18:00:00	QQQ	ETF	386.09	386.59	384.91	386.35	307925.0
2021-12-17 19:00:00	QQQ	ETF	386.36	386.91	384.91	386.91	807527.0
2021-12-17 04:00:00	IWM	ETF	213.26	213.44	212.13	213.43	33186.0
2021-12-17 05:00:00	IWM	ETF	213.49	213.49	212.27	212.67	48208.0
2021-12-17 06:00:00	IWM	ETF	212.67	213.24	212.46	212.96	113209.0
2021-12-17 07:00:00	IWM	ETF	213.15	213.17	211.27	211.63	151172.0
2021-12-17 08:00:00	IWM	ETF	211.4999	213.0604	211.31	212.54	458936.0
2021-12-17 09:00:00	IWM	ETF	212.65	212.705	210.3	212.0	5390531.0
2021-12-17 10:00:00	IWM	ETF	212.0	217.35	211.28	216.43	9997047.0
2021-12-17 11:00:00	IWM	ETF	216.44	216.92	214.7025	215.34	6004497.0
2021-12-17 12:00:00	IWM	ETF	215.34	215.91	214.5	215.75	4081557.0
2021-12-17 13:00:00	IWM	ETF	215.745	216.49	215.34	216.46	2421969.0
2021-12-17 14:00:00	IWM	ETF	216.47	216.5	215.71	215.83	2377546.0
2021-12-17 15:00:00	IWM	ETF	215.83	216.38	214.53	215.07	9645487.0
2021-12-17 16:00:00	IWM	ETF	215.07	215.76	214.98	215.53	2235770.0
2021-12-17 17:00:00	IWM	ETF	215.31	215.6	215.14	215.6	536346.0
2021-12-17 18:00:00	IWM	ETF	215.56	215.6	215.14	215.51	330465.0
2021-12-17 19:00:00	IWM	ETF	215.52	215.84	215.14	215.7	154802.0
2021-12-17 04:00:00	DIA	ETF	358.88	359.2	358.31	359.0	11209.0
2021-12-17 05:00:00	DIA	ETF	359.0	359.0	358.23	358.23	4700.0

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

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