PREVIEW / etf_1hour / 2021-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-09.parquet
  size:    409 KB
  rows:    14,235

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-07-09 04:00:00	SPY	ETF	431.3	432.17	431.3	432.06	48121.0
2021-07-09 05:00:00	SPY	ETF	432.13	432.59	431.88	431.9	36071.0
2021-07-09 06:00:00	SPY	ETF	431.84	432.28	431.46	432.15	99031.0
2021-07-09 07:00:00	SPY	ETF	432.16	433.06	432.15	432.9	182770.0
2021-07-09 08:00:00	SPY	ETF	432.5701	433.0301	431.0	432.66	317072.0
2021-07-09 09:00:00	SPY	ETF	432.67	433.64	432.31	433.5802	6322805.0
2021-07-09 10:00:00	SPY	ETF	433.58	434.44	433.58	434.08	8389684.0
2021-07-09 11:00:00	SPY	ETF	434.09	435.22	434.09	434.72	6488918.0
2021-07-09 12:00:00	SPY	ETF	434.7399	435.09	434.58	434.8311	4129204.0
2021-07-09 13:00:00	SPY	ETF	434.83	435.005	434.61	434.97	3151306.0
2021-07-09 14:00:00	SPY	ETF	434.96	435.66	434.96	435.57	3925070.0
2021-07-09 15:00:00	SPY	ETF	435.58	435.84	435.29	435.49	16726345.0
2021-07-09 16:00:00	SPY	ETF	435.49	435.65	435.3	435.62	4682405.0
2021-07-09 17:00:00	SPY	ETF	435.63	435.65	435.52	435.6	1419500.0
2021-07-09 18:00:00	SPY	ETF	435.56	435.62	435.56	435.59	26705.0
2021-07-09 19:00:00	SPY	ETF	435.59	435.65	435.57	435.65	34175.0
2021-07-09 04:00:00	QQQ	ETF	358.77	359.3	358.76	358.82	73550.0
2021-07-09 05:00:00	QQQ	ETF	359.0	359.22	358.18	358.36	54059.0
2021-07-09 06:00:00	QQQ	ETF	358.23	358.3	357.57	358.09	318548.0
2021-07-09 07:00:00	QQQ	ETF	358.14	359.0	358.14	358.94	228159.0
2021-07-09 08:00:00	QQQ	ETF	359.0	359.47	357.75	358.43	487154.0
2021-07-09 09:00:00	QQQ	ETF	358.41	358.94	357.57	358.64	5338356.0
2021-07-09 10:00:00	QQQ	ETF	358.64	360.15	358.36	360.12	4680791.0
2021-07-09 11:00:00	QQQ	ETF	360.12	361.01	360.02	360.6899	3072342.0
2021-07-09 12:00:00	QQQ	ETF	360.7	361.5	360.69	361.19	2923374.0
2021-07-09 13:00:00	QQQ	ETF	361.19	361.2	360.67	360.9431	2117739.0
2021-07-09 14:00:00	QQQ	ETF	360.95	361.3	360.64	361.22	1672799.0
2021-07-09 15:00:00	QQQ	ETF	361.23	361.43	360.76	361.0	5238431.0
2021-07-09 16:00:00	QQQ	ETF	361.0	361.08	360.83	361.08	1554855.0
2021-07-09 17:00:00	QQQ	ETF	361.1	361.17	361.04	361.1	39861.0
2021-07-09 18:00:00	QQQ	ETF	361.08	361.1	361.0	361.07	5371.0
2021-07-09 19:00:00	QQQ	ETF	361.02	361.2	361.02	361.06	10632.0
2021-07-09 04:00:00	IWM	ETF	222.81	223.74	222.81	223.57	90260.0
2021-07-09 05:00:00	IWM	ETF	223.61	224.32	223.61	223.76	28866.0
2021-07-09 06:00:00	IWM	ETF	223.72	224.01	223.45	223.84	35480.0
2021-07-09 07:00:00	IWM	ETF	223.84	224.93	223.82	224.72	178255.0
2021-07-09 08:00:00	IWM	ETF	223.9104	224.93	221.57	224.43	149683.0
2021-07-09 09:00:00	IWM	ETF	224.46	225.22	223.34	225.21	3705910.0
2021-07-09 10:00:00	IWM	ETF	225.215	225.765	224.81	224.95	3694895.0
2021-07-09 11:00:00	IWM	ETF	224.96	225.78	224.89	225.58	1557457.0
2021-07-09 12:00:00	IWM	ETF	225.6	226.1	225.37	225.85	2028124.0
2021-07-09 13:00:00	IWM	ETF	225.85	225.95	225.5967	225.78	1545246.0
2021-07-09 14:00:00	IWM	ETF	225.77	226.15	225.745	226.05	1923168.0
2021-07-09 15:00:00	IWM	ETF	226.06	226.45	225.96	226.32	3668573.0
2021-07-09 16:00:00	IWM	ETF	226.38	226.7	226.25	226.4	927414.0
2021-07-09 17:00:00	IWM	ETF	226.2	226.51	226.2	226.5	21999.0
2021-07-09 18:00:00	IWM	ETF	226.49	226.57	226.49	226.51	4554.0
2021-07-09 19:00:00	IWM	ETF	226.55	226.7	226.5	226.7	14281.0
2021-07-09 04:00:00	DIA	ETF	345.39	345.39	345.38	345.38	200.0
2021-07-09 05:00:00	DIA	ETF	345.72	346.15	345.7	345.75	5574.0

> showing 50 of 14,235 rows — these rows as CSV

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