PREVIEW / etf_1hour / 2021-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-19.parquet
  size:    433 KB
  rows:    15,092

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-08-19 04:00:00	SPY	ETF	437.88	437.88	434.92	435.16	295282.0
2021-08-19 05:00:00	SPY	ETF	435.2	436.75	434.5	436.5	66598.0
2021-08-19 06:00:00	SPY	ETF	436.63	437.02	435.7	435.73	379718.0
2021-08-19 07:00:00	SPY	ETF	435.7	436.1	435.18	435.23	606721.0
2021-08-19 08:00:00	SPY	ETF	435.23	439.07	434.86	435.29	587678.0
2021-08-19 09:00:00	SPY	ETF	435.25	438.87	435.25	438.53	13155850.0
2021-08-19 10:00:00	SPY	ETF	438.53	439.99	437.5	439.505	14127222.0
2021-08-19 11:00:00	SPY	ETF	439.51	441.06	438.82	440.725	9077221.0
2021-08-19 12:00:00	SPY	ETF	440.725	441.14	439.975	440.88	5623736.0
2021-08-19 13:00:00	SPY	ETF	440.89	440.935	438.92	438.92	6607358.0
2021-08-19 14:00:00	SPY	ETF	438.92	439.73	437.46	439.64	12027918.0
2021-08-19 15:00:00	SPY	ETF	439.64	441.0599	439.25	439.84	14966261.0
2021-08-19 16:00:00	SPY	ETF	439.83	440.4	439.8	439.95	3073024.0
2021-08-19 17:00:00	SPY	ETF	440.02	440.03	439.8	439.87	87972.0
2021-08-19 18:00:00	SPY	ETF	439.89	439.96	439.57	439.62	154199.0
2021-08-19 19:00:00	SPY	ETF	439.65	439.69	438.94	439.12	157329.0
2021-08-19 04:00:00	QQQ	ETF	360.96	360.96	358.67	359.11	119171.0
2021-08-19 05:00:00	QQQ	ETF	359.19	360.54	358.76	360.39	109524.0
2021-08-19 06:00:00	QQQ	ETF	360.52	360.78	359.75	359.83	220531.0
2021-08-19 07:00:00	QQQ	ETF	359.8	360.09	359.41	359.46	280989.0
2021-08-19 08:00:00	QQQ	ETF	360.6904	362.11	359.23	359.38	534143.0
2021-08-19 09:00:00	QQQ	ETF	359.37	361.7001	359.37	360.9	6195094.0
2021-08-19 10:00:00	QQQ	ETF	360.9	363.27	360.86	363.21	5475049.0
2021-08-19 11:00:00	QQQ	ETF	363.22	365.44	362.95	365.23	5240326.0
2021-08-19 12:00:00	QQQ	ETF	365.24	365.68	364.54	365.4099	3031244.0
2021-08-19 13:00:00	QQQ	ETF	365.41	365.4101	363.945	363.96	2647669.0
2021-08-19 14:00:00	QQQ	ETF	363.94	364.3	362.23	364.14	5146524.0
2021-08-19 15:00:00	QQQ	ETF	364.13	365.22	363.59	363.97	7084765.0
2021-08-19 16:00:00	QQQ	ETF	363.99	364.45	362.1577	364.33	886657.0
2021-08-19 17:00:00	QQQ	ETF	364.34	364.6	363.96	364.14	130230.0
2021-08-19 18:00:00	QQQ	ETF	364.23	364.3	363.869	363.95	175761.0
2021-08-19 19:00:00	QQQ	ETF	363.99	364.0	363.56	363.66	49700.0
2021-08-19 04:00:00	IWM	ETF	213.0	213.0	210.4	210.51	101039.0
2021-08-19 05:00:00	IWM	ETF	210.32	211.66	209.88	211.5	75655.0
2021-08-19 06:00:00	IWM	ETF	211.58	212.0	210.99	211.08	119959.0
2021-08-19 07:00:00	IWM	ETF	211.08	211.33	210.6	210.69	235894.0
2021-08-19 08:00:00	IWM	ETF	210.7	214.0	210.43	211.63	379372.0
2021-08-19 09:00:00	IWM	ETF	211.63	213.78	211.63	212.96	5934436.0
2021-08-19 10:00:00	IWM	ETF	213.0	214.07	211.61	212.63	5300128.0
2021-08-19 11:00:00	IWM	ETF	212.65	213.24	211.36	213.08	4454247.0
2021-08-19 12:00:00	IWM	ETF	213.07	213.37	212.38	213.35	2991358.0
2021-08-19 13:00:00	IWM	ETF	213.35	213.37	211.45	211.47	2655557.0
2021-08-19 14:00:00	IWM	ETF	211.47	212.01	210.6825	211.78	4569611.0
2021-08-19 15:00:00	IWM	ETF	211.775	212.59	211.51	211.93	4895889.0
2021-08-19 16:00:00	IWM	ETF	211.94	212.23	211.85	211.95	511483.0
2021-08-19 17:00:00	IWM	ETF	212.01	212.15	211.89	212.05	200972.0
2021-08-19 18:00:00	IWM	ETF	211.97	212.17	211.87	211.88	21099.0
2021-08-19 19:00:00	IWM	ETF	211.93	212.0	211.37	211.52	19158.0
2021-08-19 04:00:00	DIA	ETF	347.35	347.44	346.55	346.69	2357.0
2021-08-19 05:00:00	DIA	ETF	346.22	347.31	346.19	347.31	1500.0

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

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