PREVIEW / etf_1hour / 2020-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-17.parquet
  size:    400 KB
  rows:    13,687

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
2020-12-17 04:00:00	SPY	ETF	371.59	372.43	371.59	372.03	28223.0
2020-12-17 05:00:00	SPY	ETF	372.05	372.24	372.01	372.06	12909.0
2020-12-17 06:00:00	SPY	ETF	372.11	372.29	371.95	372.05	21415.0
2020-12-17 07:00:00	SPY	ETF	372.08	372.11	371.77	371.92	82610.0
2020-12-17 08:00:00	SPY	ETF	371.94	372.22	370.51	371.65	236992.0
2020-12-17 09:00:00	SPY	ETF	371.73	372.46	371.52	371.71	6358832.0
2020-12-17 10:00:00	SPY	ETF	371.72	372.05	371.35	371.575	7782312.0
2020-12-17 11:00:00	SPY	ETF	371.58	371.9	371.05	371.644	6261380.0
2020-12-17 12:00:00	SPY	ETF	371.64	371.82	371.19	371.685	3909427.0
2020-12-17 13:00:00	SPY	ETF	371.68	372.135	371.67	372.135	7087255.0
2020-12-17 14:00:00	SPY	ETF	372.13	372.22	371.96	372.095	7151577.0
2020-12-17 15:00:00	SPY	ETF	372.095	372.27	371.52	372.21	12441960.0
2020-12-17 16:00:00	SPY	ETF	372.23	372.48	372.01	372.25	9728093.0
2020-12-17 17:00:00	SPY	ETF	372.5	372.5	372.15	372.34	502545.0
2020-12-17 18:00:00	SPY	ETF	372.27	372.32	372.06	372.24	49316.0
2020-12-17 19:00:00	SPY	ETF	372.21	372.27	371.75	371.78	93654.0
2020-12-17 04:00:00	QQQ	ETF	310.3	310.82	310.3	310.42	40351.0
2020-12-17 05:00:00	QQQ	ETF	310.48	310.64	310.45	310.53	14198.0
2020-12-17 06:00:00	QQQ	ETF	310.47	310.61	310.33	310.36	17611.0
2020-12-17 07:00:00	QQQ	ETF	310.34	310.57	310.27	310.51	74495.0
2020-12-17 08:00:00	QQQ	ETF	310.5299	310.88	308.98	310.52	311608.0
2020-12-17 09:00:00	QQQ	ETF	310.5502	311.24	310.42	310.69	2755154.0
2020-12-17 10:00:00	QQQ	ETF	310.7	310.81	309.75	309.82	2816868.0
2020-12-17 11:00:00	QQQ	ETF	309.84	310.42	309.39	310.085	2094299.0
2020-12-17 12:00:00	QQQ	ETF	310.08	310.57	309.77	310.449	1271334.0
2020-12-17 13:00:00	QQQ	ETF	310.45	310.73	310.13	310.6301	1077787.0
2020-12-17 14:00:00	QQQ	ETF	310.63	310.74	310.19	310.51	1150410.0
2020-12-17 15:00:00	QQQ	ETF	310.53	311.1	309.9501	311.0	3282651.0
2020-12-17 16:00:00	QQQ	ETF	310.99	311.37	310.86	311.04	1147965.0
2020-12-17 17:00:00	QQQ	ETF	311.0	311.12	310.76	310.95	53446.0
2020-12-17 18:00:00	QQQ	ETF	310.92	311.06	310.85	311.03	41172.0
2020-12-17 19:00:00	QQQ	ETF	310.98	311.0	310.57	310.62	25648.0
2020-12-17 04:00:00	IWM	ETF	195.0	195.58	195.0	195.22	20344.0
2020-12-17 05:00:00	IWM	ETF	195.29	195.52	195.28	195.32	10427.0
2020-12-17 06:00:00	IWM	ETF	195.4	195.5	195.35	195.38	10408.0
2020-12-17 07:00:00	IWM	ETF	195.34	195.34	194.92	194.96	45980.0
2020-12-17 08:00:00	IWM	ETF	195.2699	195.4	193.98	194.56	861487.0
2020-12-17 09:00:00	IWM	ETF	194.62	195.02	194.155	194.22	2243740.0
2020-12-17 10:00:00	IWM	ETF	194.21	195.3	194.055	194.73	2021535.0
2020-12-17 11:00:00	IWM	ETF	194.7	195.25	194.43	195.065	1446168.0
2020-12-17 12:00:00	IWM	ETF	195.06	195.79	194.69	195.735	1307444.0
2020-12-17 13:00:00	IWM	ETF	195.72	195.79	195.44	195.73	1716348.0
2020-12-17 14:00:00	IWM	ETF	195.72	196.01	195.53	195.61	1808372.0
2020-12-17 15:00:00	IWM	ETF	195.62	196.38	195.24	196.31	4125352.0
2020-12-17 16:00:00	IWM	ETF	196.29	196.6	195.81	196.1	2289115.0
2020-12-17 17:00:00	IWM	ETF	196.36	196.4	196.21	196.21	17614.0
2020-12-17 18:00:00	IWM	ETF	196.15	196.4	196.07	196.1	32645.0
2020-12-17 19:00:00	IWM	ETF	196.09	196.15	195.97	196.02	8121.0
2020-12-17 04:00:00	DIA	ETF	303.37	303.79	303.37	303.44	7711.0
2020-12-17 05:00:00	DIA	ETF	303.42	303.43	303.36	303.37	1700.0

> showing 50 of 13,687 rows — these rows as CSV

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