PREVIEW / etf_1hour / 2021-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-08.parquet
  size:    438 KB
  rows:    15,566

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-08 04:00:00	SPY	ETF	469.59	469.71	469.0	469.15	28357.0
2021-12-08 05:00:00	SPY	ETF	469.24	469.25	468.2	468.23	44090.0
2021-12-08 06:00:00	SPY	ETF	468.13	470.98	467.8	469.91	347438.0
2021-12-08 07:00:00	SPY	ETF	469.99	470.58	468.84	469.17	382145.0
2021-12-08 08:00:00	SPY	ETF	470.03	470.8096	468.1296	468.88	408798.0
2021-12-08 09:00:00	SPY	ETF	468.85	469.285	467.5	468.14	6405435.0
2021-12-08 10:00:00	SPY	ETF	468.14	468.79	466.97	467.08	7904589.0
2021-12-08 11:00:00	SPY	ETF	467.08	468.3	466.83	468.1282	4595399.0
2021-12-08 12:00:00	SPY	ETF	468.11	468.51	467.47	468.27	3264878.0
2021-12-08 13:00:00	SPY	ETF	468.27	469.0	468.14	468.65	3073202.0
2021-12-08 14:00:00	SPY	ETF	468.64	469.17	468.22	469.11	4142305.0
2021-12-08 15:00:00	SPY	ETF	469.11	470.0	468.892	469.5401	12483285.0
2021-12-08 16:00:00	SPY	ETF	469.55	469.8	469.35	469.4	2977098.0
2021-12-08 17:00:00	SPY	ETF	469.32	469.52	469.32	469.5	23371.0
2021-12-08 18:00:00	SPY	ETF	469.49	469.64	469.19	469.28	71778.0
2021-12-08 19:00:00	SPY	ETF	469.4	469.4	469.1	469.2201	44752.0
2021-12-08 04:00:00	QQQ	ETF	399.84	400.0	398.83	399.18	59256.0
2021-12-08 05:00:00	QQQ	ETF	399.15	399.31	398.57	398.82	29554.0
2021-12-08 06:00:00	QQQ	ETF	398.76	400.6	398.55	399.2	210124.0
2021-12-08 07:00:00	QQQ	ETF	399.15	399.7	398.4	398.92	216155.0
2021-12-08 08:00:00	QQQ	ETF	399.24	399.9904	397.86	398.21	331427.0
2021-12-08 09:00:00	QQQ	ETF	398.2	398.77	396.22	397.06	6580721.0
2021-12-08 10:00:00	QQQ	ETF	397.02	398.15	396.295	396.96	5638564.0
2021-12-08 11:00:00	QQQ	ETF	396.96	398.39	396.3314	398.065	3290890.0
2021-12-08 12:00:00	QQQ	ETF	398.02	398.39	397.17	397.91	2197762.0
2021-12-08 13:00:00	QQQ	ETF	397.92	399.35	397.75	398.8002	2642420.0
2021-12-08 14:00:00	QQQ	ETF	398.79	399.14	397.88	399.085	3733907.0
2021-12-08 15:00:00	QQQ	ETF	399.085	399.82	398.56	399.62	4549682.0
2021-12-08 16:00:00	QQQ	ETF	399.6	399.61	399.22	399.409	1160343.0
2021-12-08 17:00:00	QQQ	ETF	399.51	399.57	399.36	399.49	8897.0
2021-12-08 18:00:00	QQQ	ETF	399.46	399.75	399.23	399.35	65153.0
2021-12-08 19:00:00	QQQ	ETF	399.4	399.45	399.2	399.4	75097.0
2021-12-08 04:00:00	IWM	ETF	225.0	225.0	224.39	224.64	16170.0
2021-12-08 05:00:00	IWM	ETF	224.61	224.86	223.61	223.61	10619.0
2021-12-08 06:00:00	IWM	ETF	223.53	226.59	223.1	226.0	436502.0
2021-12-08 07:00:00	IWM	ETF	226.09	226.55	224.78	225.33	394800.0
2021-12-08 08:00:00	IWM	ETF	223.8696	226.55	223.6096	224.99	221727.0
2021-12-08 09:00:00	IWM	ETF	225.03	225.6	223.06	224.22	5700093.0
2021-12-08 10:00:00	IWM	ETF	224.21	225.48	223.755	224.86	5047491.0
2021-12-08 11:00:00	IWM	ETF	224.87	226.535	224.84	226.05	2876912.0
2021-12-08 12:00:00	IWM	ETF	226.03	226.33	225.65	225.73	2156161.0
2021-12-08 13:00:00	IWM	ETF	225.75	226.34	225.59	225.64	1823779.0
2021-12-08 14:00:00	IWM	ETF	225.6484	226.2078	225.29	226.0	2118633.0
2021-12-08 15:00:00	IWM	ETF	225.98	226.27	225.56	225.64	3507170.0
2021-12-08 16:00:00	IWM	ETF	225.63	225.89	225.4	225.51	2234378.0
2021-12-08 17:00:00	IWM	ETF	225.43	225.62	225.3	225.62	37914.0
2021-12-08 18:00:00	IWM	ETF	225.57	225.63	225.28	225.45	22808.0
2021-12-08 19:00:00	IWM	ETF	225.49	225.53	225.2	225.3	22440.0
2021-12-08 04:00:00	DIA	ETF	358.48	358.48	358.15	358.15	1300.0
2021-12-08 05:00:00	DIA	ETF	358.15	358.15	358.15	358.15	100.0

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

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