PREVIEW / etf_1hour / 2021-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-30.parquet
  size:    418 KB
  rows:    14,588

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-30 04:00:00	SPY	ETF	450.48	450.61	450.41	450.46	5204.0
2021-08-30 05:00:00	SPY	ETF	450.53	450.6	450.44	450.5	2304.0
2021-08-30 06:00:00	SPY	ETF	450.54	450.75	450.52	450.53	72751.0
2021-08-30 07:00:00	SPY	ETF	450.57	450.64	450.51	450.59	37859.0
2021-08-30 08:00:00	SPY	ETF	450.53	450.87	450.51	450.81	128991.0
2021-08-30 09:00:00	SPY	ETF	450.8	451.48	450.71	451.44	3990319.0
2021-08-30 10:00:00	SPY	ETF	451.45	452.815	451.2599	452.795	5928112.0
2021-08-30 11:00:00	SPY	ETF	452.79	453.07	452.6	452.907	4454658.0
2021-08-30 12:00:00	SPY	ETF	452.9	452.96	452.36	452.72	2684997.0
2021-08-30 13:00:00	SPY	ETF	452.72	452.95	452.603	452.94	2220202.0
2021-08-30 14:00:00	SPY	ETF	452.94	453.07	452.625	452.895	3316298.0
2021-08-30 15:00:00	SPY	ETF	452.89	452.99	452.09	452.22	9861658.0
2021-08-30 16:00:00	SPY	ETF	452.21	452.69	452.06	452.63	3262787.0
2021-08-30 17:00:00	SPY	ETF	452.68	452.68	452.23	452.61	501463.0
2021-08-30 18:00:00	SPY	ETF	452.61	452.73	452.23	452.64	43336.0
2021-08-30 19:00:00	SPY	ETF	452.64	452.64	452.29	452.35	83115.0
2021-08-30 04:00:00	QQQ	ETF	376.3	376.7	376.3	376.63	36418.0
2021-08-30 05:00:00	QQQ	ETF	376.64	376.72	376.56	376.59	10760.0
2021-08-30 06:00:00	QQQ	ETF	376.63	376.81	376.59	376.63	27488.0
2021-08-30 07:00:00	QQQ	ETF	376.64	376.64	376.48	376.58	26404.0
2021-08-30 08:00:00	QQQ	ETF	376.5599	376.72	376.322	376.68	75676.0
2021-08-30 09:00:00	QQQ	ETF	376.6899	378.64	376.58	378.61	3221065.0
2021-08-30 10:00:00	QQQ	ETF	378.65	380.035	378.39	379.95	4537970.0
2021-08-30 11:00:00	QQQ	ETF	379.95	380.28	379.36	380.15	2852369.0
2021-08-30 12:00:00	QQQ	ETF	380.14	380.21	379.53	380.0	2251062.0
2021-08-30 13:00:00	QQQ	ETF	380.01	380.65	379.89	380.65	1524119.0
2021-08-30 14:00:00	QQQ	ETF	380.655	380.76	380.442	380.735	1730087.0
2021-08-30 15:00:00	QQQ	ETF	380.75	380.75	380.2	380.32	4397540.0
2021-08-30 16:00:00	QQQ	ETF	380.34	380.6	380.24	380.5	987882.0
2021-08-30 17:00:00	QQQ	ETF	380.48	380.48	380.26	380.45	46426.0
2021-08-30 18:00:00	QQQ	ETF	380.45	380.6	380.39	380.49	54545.0
2021-08-30 19:00:00	QQQ	ETF	380.49	380.5	380.27	380.32	50008.0
2021-08-30 04:00:00	IWM	ETF	226.76	226.98	226.75	226.96	6756.0
2021-08-30 05:00:00	IWM	ETF	226.86	226.97	226.85	226.88	5560.0
2021-08-30 06:00:00	IWM	ETF	226.95	227.13	226.91	226.99	6772.0
2021-08-30 07:00:00	IWM	ETF	226.96	227.22	226.9	227.22	26358.0
2021-08-30 08:00:00	IWM	ETF	227.0199	227.53	227.0199	227.23	99037.0
2021-08-30 09:00:00	IWM	ETF	227.15	227.47	224.98	226.21	3502063.0
2021-08-30 10:00:00	IWM	ETF	226.2	226.345	225.3978	225.96	3115821.0
2021-08-30 11:00:00	IWM	ETF	225.96	226.02	225.37	225.94	1884229.0
2021-08-30 12:00:00	IWM	ETF	225.95	226.0599	225.68	225.82	1436187.0
2021-08-30 13:00:00	IWM	ETF	225.82	225.975	225.61	225.85	1084682.0
2021-08-30 14:00:00	IWM	ETF	225.865	225.9594	225.24	225.79	1123411.0
2021-08-30 15:00:00	IWM	ETF	225.79	226.02	225.05	225.48	3785164.0
2021-08-30 16:00:00	IWM	ETF	225.49	225.67	225.18	225.61	886565.0
2021-08-30 17:00:00	IWM	ETF	225.43	225.68	225.43	225.55	22909.0
2021-08-30 18:00:00	IWM	ETF	225.59	225.81	225.59	225.81	14169.0
2021-08-30 19:00:00	IWM	ETF	225.82	225.85	225.5	225.56	34928.0
2021-08-30 04:00:00	DIA	ETF	354.88	354.89	354.71	354.71	900.0
2021-08-30 05:00:00	DIA	ETF	354.76	354.76	354.76	354.76	300.0

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

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