PREVIEW / etf_1hour / 2021-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-25.parquet
  size:    406 KB
  rows:    14,136

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-06-25 04:00:00	SPY	ETF	425.3	425.43	425.04	425.42	13898.0
2021-06-25 05:00:00	SPY	ETF	425.29	425.65	425.27	425.59	15740.0
2021-06-25 06:00:00	SPY	ETF	425.54	425.66	425.37	425.66	15421.0
2021-06-25 07:00:00	SPY	ETF	425.61	425.69	425.23	425.31	52959.0
2021-06-25 08:00:00	SPY	ETF	425.31	425.99	425.12	425.82	195614.0
2021-06-25 09:00:00	SPY	ETF	425.83	426.11	425.55	425.84	4767912.0
2021-06-25 10:00:00	SPY	ETF	425.84	426.48	425.6101	425.9	4838721.0
2021-06-25 11:00:00	SPY	ETF	425.9	426.36	425.85	426.3	2804381.0
2021-06-25 12:00:00	SPY	ETF	426.2902	426.38	426.08	426.2816	2029469.0
2021-06-25 13:00:00	SPY	ETF	426.29	426.32	425.9511	426.25	2933762.0
2021-06-25 14:00:00	SPY	ETF	426.26	426.62	426.14	426.54	4183029.0
2021-06-25 15:00:00	SPY	ETF	426.55	427.0943	426.41	426.56	17130943.0
2021-06-25 16:00:00	SPY	ETF	426.56	426.9	426.42	426.86	3783509.0
2021-06-25 17:00:00	SPY	ETF	426.71	426.99	426.55	426.87	66146.0
2021-06-25 18:00:00	SPY	ETF	426.86	426.99	426.7	426.85	32997.0
2021-06-25 19:00:00	SPY	ETF	426.76	426.89	426.69	426.88	34158.0
2021-06-25 04:00:00	QQQ	ETF	350.01	350.3	349.92	350.25	19573.0
2021-06-25 05:00:00	QQQ	ETF	350.27	350.7	350.13	350.58	42440.0
2021-06-25 06:00:00	QQQ	ETF	350.54	350.58	350.27	350.57	26793.0
2021-06-25 07:00:00	QQQ	ETF	350.51	350.54	350.0	350.07	61262.0
2021-06-25 08:00:00	QQQ	ETF	350.2899	350.84	349.85	350.38	422274.0
2021-06-25 09:00:00	QQQ	ETF	350.4	350.72	349.24	349.53	3632147.0
2021-06-25 10:00:00	QQQ	ETF	349.53	350.29	348.84	349.57	4760780.0
2021-06-25 11:00:00	QQQ	ETF	349.58	350.105	349.32	349.8795	2293651.0
2021-06-25 12:00:00	QQQ	ETF	349.86	349.89	349.05	349.45	1574632.0
2021-06-25 13:00:00	QQQ	ETF	349.4501	349.57	348.9523	349.25	1757802.0
2021-06-25 14:00:00	QQQ	ETF	349.26	349.83	349.07	349.7899	1923262.0
2021-06-25 15:00:00	QQQ	ETF	349.78	349.9402	349.01	349.47	5183990.0
2021-06-25 16:00:00	QQQ	ETF	349.46	349.6	349.05	349.29	1104609.0
2021-06-25 17:00:00	QQQ	ETF	349.29	349.46	349.22	349.26	84437.0
2021-06-25 18:00:00	QQQ	ETF	349.28	349.37	349.28	349.37	32628.0
2021-06-25 19:00:00	QQQ	ETF	349.34	349.45	349.33	349.45	19216.0
2021-06-25 04:00:00	IWM	ETF	232.03	232.09	231.86	232.09	5497.0
2021-06-25 05:00:00	IWM	ETF	231.96	232.17	231.88	232.1	6550.0
2021-06-25 06:00:00	IWM	ETF	232.01	232.31	232.01	232.31	7849.0
2021-06-25 07:00:00	IWM	ETF	232.28	232.29	231.98	232.03	17820.0
2021-06-25 08:00:00	IWM	ETF	232.25	232.55	232.0	232.46	84866.0
2021-06-25 09:00:00	IWM	ETF	232.46	233.0	231.87	232.145	2333118.0
2021-06-25 10:00:00	IWM	ETF	232.14	233.0	231.77	232.31	2335406.0
2021-06-25 11:00:00	IWM	ETF	232.305	232.875	232.305	232.81	954812.0
2021-06-25 12:00:00	IWM	ETF	232.81	233.05	232.4	232.765	1005787.0
2021-06-25 13:00:00	IWM	ETF	232.76	232.765	232.35	232.59	882623.0
2021-06-25 14:00:00	IWM	ETF	232.59	233.24	232.48	233.21	1701698.0
2021-06-25 15:00:00	IWM	ETF	233.215	233.41	231.75	231.76	6057047.0
2021-06-25 16:00:00	IWM	ETF	231.77	233.0675	231.37	232.27	2583658.0
2021-06-25 17:00:00	IWM	ETF	232.03	232.34	231.9	232.15	56913.0
2021-06-25 18:00:00	IWM	ETF	232.18	232.3	232.17	232.28	4385.0
2021-06-25 19:00:00	IWM	ETF	232.28	232.48	232.28	232.3	14922.0
2021-06-25 04:00:00	DIA	ETF	342.81	342.82	342.65	342.7	600.0
2021-06-25 05:00:00	DIA	ETF	342.7	343.06	342.7	343.06	500.0

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

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