PREVIEW / etf_1hour / 2021-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-09.parquet
  size:    434 KB
  rows:    15,416

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-11-09 04:00:00	SPY	ETF	468.62	469.09	468.62	469.02	9466.0
2021-11-09 05:00:00	SPY	ETF	469.01	469.28	469.01	469.12	18553.0
2021-11-09 06:00:00	SPY	ETF	469.08	469.26	468.99	469.05	23041.0
2021-11-09 07:00:00	SPY	ETF	469.07	469.14	468.27	468.4	117936.0
2021-11-09 08:00:00	SPY	ETF	469.0404	469.25	467.9	469.07	311594.0
2021-11-09 09:00:00	SPY	ETF	469.13	469.57	466.46	466.95	6244335.0
2021-11-09 10:00:00	SPY	ETF	466.95	467.98	466.15	467.26	9093269.0
2021-11-09 11:00:00	SPY	ETF	467.26	467.64	466.31	466.59	4163397.0
2021-11-09 12:00:00	SPY	ETF	466.56	467.19	465.88	466.66	4852081.0
2021-11-09 13:00:00	SPY	ETF	466.66	467.13	465.94	466.17	2884688.0
2021-11-09 14:00:00	SPY	ETF	466.1682	467.1697	466.04	467.14	3020185.0
2021-11-09 15:00:00	SPY	ETF	467.14	467.495	466.53	467.39	6667744.0
2021-11-09 16:00:00	SPY	ETF	467.39	467.44	466.94	467.01	1999658.0
2021-11-09 17:00:00	SPY	ETF	466.89	467.14	466.89	467.06	37905.0
2021-11-09 18:00:00	SPY	ETF	467.03	467.03	466.66	466.73	93021.0
2021-11-09 19:00:00	SPY	ETF	466.76	466.99	466.42	466.48	92803.0
2021-11-09 04:00:00	QQQ	ETF	398.0	398.61	398.0	398.61	292300.0
2021-11-09 05:00:00	QQQ	ETF	398.55	398.84	398.55	398.8	52809.0
2021-11-09 06:00:00	QQQ	ETF	398.78	399.08	398.68	398.76	40148.0
2021-11-09 07:00:00	QQQ	ETF	398.7	398.91	398.21	398.45	175340.0
2021-11-09 08:00:00	QQQ	ETF	398.67	399.47	397.3	399.18	297977.0
2021-11-09 09:00:00	QQQ	ETF	399.16	399.57	394.84	395.54	7421491.0
2021-11-09 10:00:00	QQQ	ETF	395.52	397.0	394.67	396.13	10535302.0
2021-11-09 11:00:00	QQQ	ETF	396.13	396.76	395.16	395.785	5164801.0
2021-11-09 12:00:00	QQQ	ETF	395.76	395.97	394.55	395.11	4915687.0
2021-11-09 13:00:00	QQQ	ETF	395.14	395.65	393.92	394.14	3325423.0
2021-11-09 14:00:00	QQQ	ETF	394.14	395.71	394.0	395.3301	2790616.0
2021-11-09 15:00:00	QQQ	ETF	395.33	395.53	394.53	395.29	4474211.0
2021-11-09 16:00:00	QQQ	ETF	395.29	395.41	394.75	394.85	647923.0
2021-11-09 17:00:00	QQQ	ETF	394.89	395.32	394.69	394.72	122897.0
2021-11-09 18:00:00	QQQ	ETF	394.84	394.85	394.41	394.58	37677.0
2021-11-09 19:00:00	QQQ	ETF	394.56	394.86	394.3	394.38	111204.0
2021-11-09 04:00:00	IWM	ETF	242.42	242.52	242.14	242.5	28877.0
2021-11-09 05:00:00	IWM	ETF	242.5	242.59	242.29	242.35	13329.0
2021-11-09 06:00:00	IWM	ETF	242.35	242.46	241.96	242.29	25308.0
2021-11-09 07:00:00	IWM	ETF	242.27	242.37	241.66	241.7	31591.0
2021-11-09 08:00:00	IWM	ETF	242.2896	242.32	241.57	241.97	118329.0
2021-11-09 09:00:00	IWM	ETF	241.94	242.53	239.54	239.84	3672867.0
2021-11-09 10:00:00	IWM	ETF	239.84	241.55	239.56	240.96	4656345.0
2021-11-09 11:00:00	IWM	ETF	241.0	241.51	240.24	240.68	3003445.0
2021-11-09 12:00:00	IWM	ETF	240.65	241.28	240.29	240.95	2288544.0
2021-11-09 13:00:00	IWM	ETF	240.95	241.645	240.53	240.61	1484347.0
2021-11-09 14:00:00	IWM	ETF	240.6	241.44	240.5	241.32	1602731.0
2021-11-09 15:00:00	IWM	ETF	241.32	241.43	240.64	241.15	2601051.0
2021-11-09 16:00:00	IWM	ETF	241.15	241.17	240.75	240.78	1796633.0
2021-11-09 17:00:00	IWM	ETF	240.6	241.15	240.6	240.83	74601.0
2021-11-09 18:00:00	IWM	ETF	240.88	241.15	240.57	240.58	17147.0
2021-11-09 19:00:00	IWM	ETF	240.64	240.86	240.32	240.43	20495.0
2021-11-09 05:00:00	DIA	ETF	364.29	364.3	364.25	364.25	743.0
2021-11-09 06:00:00	DIA	ETF	364.09	364.09	364.09	364.09	300.0

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

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