PREVIEW / etf_1hour / 2021-12-14

all etf 1-hour files

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

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-14 04:00:00	SPY	ETF	467.48	467.9	464.9	464.9	78723.0
2021-12-14 05:00:00	SPY	ETF	464.89	465.5	464.75	465.27	51639.0
2021-12-14 06:00:00	SPY	ETF	465.3	465.83	465.21	465.35	83685.0
2021-12-14 07:00:00	SPY	ETF	465.44	466.17	465.39	465.61	151477.0
2021-12-14 08:00:00	SPY	ETF	465.9501	468.0	463.48	463.75	911362.0
2021-12-14 09:00:00	SPY	ETF	463.75	466.57	462.92	464.48	8303532.0
2021-12-14 10:00:00	SPY	ETF	464.49	464.76	461.15	461.67	9277764.0
2021-12-14 11:00:00	SPY	ETF	461.65	462.16	460.6999	461.02	8784215.0
2021-12-14 12:00:00	SPY	ETF	461.03	461.2899	460.25	460.66	5974316.0
2021-12-14 13:00:00	SPY	ETF	460.63	461.48	460.44	460.66	4679512.0
2021-12-14 14:00:00	SPY	ETF	460.67	462.665	460.53	462.48	7157067.0
2021-12-14 15:00:00	SPY	ETF	462.46	464.44	462.36	463.39	15521239.0
2021-12-14 16:00:00	SPY	ETF	463.38	463.47	462.94	463.45	4371455.0
2021-12-14 17:00:00	SPY	ETF	463.43	463.43	463.2	463.31	70586.0
2021-12-14 18:00:00	SPY	ETF	463.36	463.68	462.92	463.25	86270.0
2021-12-14 19:00:00	SPY	ETF	463.28	463.89	463.2	463.71	56129.0
2021-12-14 04:00:00	QQQ	ETF	392.74	393.01	389.44	389.53	211366.0
2021-12-14 05:00:00	QQQ	ETF	389.26	390.11	389.19	389.75	107146.0
2021-12-14 06:00:00	QQQ	ETF	389.86	390.21	389.48	389.6	78574.0
2021-12-14 07:00:00	QQQ	ETF	389.66	390.75	389.63	390.2	298991.0
2021-12-14 08:00:00	QQQ	ETF	390.3199	392.92	387.5	388.01	1207378.0
2021-12-14 09:00:00	QQQ	ETF	387.91	390.09	386.65	388.3	8670906.0
2021-12-14 10:00:00	QQQ	ETF	388.33	388.75	384.95	385.5	9814648.0
2021-12-14 11:00:00	QQQ	ETF	385.49	385.84	382.24	384.94	7957819.0
2021-12-14 12:00:00	QQQ	ETF	384.95	385.14	383.78	384.5	4264550.0
2021-12-14 13:00:00	QQQ	ETF	384.49	385.37	384.12	384.36	4094375.0
2021-12-14 14:00:00	QQQ	ETF	384.38	387.07	384.17	386.6101	4602107.0
2021-12-14 15:00:00	QQQ	ETF	386.6	389.38	386.52	388.37	8644169.0
2021-12-14 16:00:00	QQQ	ETF	388.37	388.71	388.0	388.4	2768634.0
2021-12-14 17:00:00	QQQ	ETF	388.4	388.45	388.08	388.26	272473.0
2021-12-14 18:00:00	QQQ	ETF	388.31	388.8	387.97	388.12	106923.0
2021-12-14 19:00:00	QQQ	ETF	388.13	388.68	388.0	388.54	60719.0
2021-12-14 04:00:00	IWM	ETF	217.0	217.47	215.36	215.45	39093.0
2021-12-14 05:00:00	IWM	ETF	215.48	216.08	215.22	215.88	21059.0
2021-12-14 06:00:00	IWM	ETF	215.99	216.28	215.69	216.03	29786.0
2021-12-14 07:00:00	IWM	ETF	215.95	216.43	215.85	216.1	68130.0
2021-12-14 08:00:00	IWM	ETF	216.04	216.4104	214.81	214.99	115742.0
2021-12-14 09:00:00	IWM	ETF	214.89	217.227	214.06	216.54	5599544.0
2021-12-14 10:00:00	IWM	ETF	216.57	217.52	214.98	215.3987	4249100.0
2021-12-14 11:00:00	IWM	ETF	215.39	215.5	214.41	214.49	3025917.0
2021-12-14 12:00:00	IWM	ETF	214.46	214.61	213.88	214.01	1950964.0
2021-12-14 13:00:00	IWM	ETF	214.0	214.54	213.31	213.41	2021314.0
2021-12-14 14:00:00	IWM	ETF	213.39	214.6	213.31	214.405	2922988.0
2021-12-14 15:00:00	IWM	ETF	214.4	215.39	213.611	214.23	4509559.0
2021-12-14 16:00:00	IWM	ETF	214.18	214.61	213.9959	214.57	2095550.0
2021-12-14 17:00:00	IWM	ETF	214.55	214.75	214.18	214.53	1246992.0
2021-12-14 18:00:00	IWM	ETF	214.53	214.64	214.18	214.59	22340.0
2021-12-14 19:00:00	IWM	ETF	214.62	214.96	214.61	214.9	58728.0
2021-12-14 04:00:00	DIA	ETF	357.86	358.22	356.48	356.53	23403.0
2021-12-14 05:00:00	DIA	ETF	356.53	356.65	356.28	356.65	3416.0

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

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