PREVIEW / etf_1hour / 2021-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-07.parquet
  size:    419 KB
  rows:    14,570

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-01-07 04:00:00	SPY	ETF	375.77	376.02	374.81	375.31	50312.0
2021-01-07 05:00:00	SPY	ETF	375.19	375.51	374.52	374.52	11944.0
2021-01-07 06:00:00	SPY	ETF	374.56	375.19	374.3	374.6	30255.0
2021-01-07 07:00:00	SPY	ETF	374.58	375.8	374.549	375.57	349361.0
2021-01-07 08:00:00	SPY	ETF	374.81	377.0	374.5496	375.4	506766.0
2021-01-07 09:00:00	SPY	ETF	375.49	377.93	375.49	377.8601	9612904.0
2021-01-07 10:00:00	SPY	ETF	377.88	379.54	377.7522	379.48	12457238.0
2021-01-07 11:00:00	SPY	ETF	379.48	379.86	378.64	378.785	7361191.0
2021-01-07 12:00:00	SPY	ETF	378.79	378.995	378.315	378.9101	4602060.0
2021-01-07 13:00:00	SPY	ETF	378.92	379.1681	378.44	378.971	3508022.0
2021-01-07 14:00:00	SPY	ETF	378.9782	379.3	378.68	379.2989	5324383.0
2021-01-07 15:00:00	SPY	ETF	379.29	379.9	378.83	379.06	14079179.0
2021-01-07 16:00:00	SPY	ETF	379.07	379.39	377.45	379.08	6328811.0
2021-01-07 17:00:00	SPY	ETF	379.11	379.4	379.06	379.39	748072.0
2021-01-07 18:00:00	SPY	ETF	379.35	379.67	373.4526	379.54	283335.0
2021-01-07 19:00:00	SPY	ETF	379.41	379.88	379.25	379.88	112475.0
2021-01-07 04:00:00	QQQ	ETF	309.22	309.9	308.92	309.26	39633.0
2021-01-07 05:00:00	QQQ	ETF	309.07	309.76	308.88	308.88	22025.0
2021-01-07 06:00:00	QQQ	ETF	308.79	309.48	308.7	309.23	49720.0
2021-01-07 07:00:00	QQQ	ETF	309.26	310.15	309.2	309.92	215291.0
2021-01-07 08:00:00	QQQ	ETF	309.7	310.31	308.82	309.83	238254.0
2021-01-07 09:00:00	QQQ	ETF	309.858	312.95	309.858	312.925	5707361.0
2021-01-07 10:00:00	QQQ	ETF	312.95	314.55	312.81	314.43	4099205.0
2021-01-07 11:00:00	QQQ	ETF	314.43	314.9	313.82	314.2082	2659213.0
2021-01-07 12:00:00	QQQ	ETF	314.21	314.44	313.66	314.28	1482347.0
2021-01-07 13:00:00	QQQ	ETF	314.2775	314.86	313.67	314.725	1437616.0
2021-01-07 14:00:00	QQQ	ETF	314.74	314.94	314.49	314.84	1360560.0
2021-01-07 15:00:00	QQQ	ETF	314.84	315.84	314.78	315.04	5261183.0
2021-01-07 16:00:00	QQQ	ETF	315.03	315.8077	314.91	315.06	1397199.0
2021-01-07 17:00:00	QQQ	ETF	314.95	315.2	314.95	315.18	51912.0
2021-01-07 18:00:00	QQQ	ETF	315.12	315.46	314.9	315.35	105151.0
2021-01-07 19:00:00	QQQ	ETF	315.23	315.77	315.23	315.62	107375.0
2021-01-07 04:00:00	IWM	ETF	205.53	205.55	204.78	205.47	24123.0
2021-01-07 05:00:00	IWM	ETF	205.45	205.51	204.44	204.44	10604.0
2021-01-07 06:00:00	IWM	ETF	204.15	204.7	203.79	203.82	29827.0
2021-01-07 07:00:00	IWM	ETF	203.83	205.22	203.75	205.1	71353.0
2021-01-07 08:00:00	IWM	ETF	203.94	206.5	203.8996	205.32	76440.0
2021-01-07 09:00:00	IWM	ETF	205.28	207.17	205.28	207.14	4575576.0
2021-01-07 10:00:00	IWM	ETF	207.18	208.1	206.82	207.51	3677701.0
2021-01-07 11:00:00	IWM	ETF	207.49	207.87	206.705	207.04	2127184.0
2021-01-07 12:00:00	IWM	ETF	207.07	207.79	207.07	207.66	1529324.0
2021-01-07 13:00:00	IWM	ETF	207.66	207.83	207.18	207.58	1385367.0
2021-01-07 14:00:00	IWM	ETF	207.58	207.68	206.97	207.62	1389770.0
2021-01-07 15:00:00	IWM	ETF	207.61	208.52	207.38	208.17	3746611.0
2021-01-07 16:00:00	IWM	ETF	208.17	208.46	208.1	208.33	1401186.0
2021-01-07 17:00:00	IWM	ETF	208.39	208.46	208.17	208.26	20373.0
2021-01-07 18:00:00	IWM	ETF	208.26	208.64	208.17	208.64	31935.0
2021-01-07 19:00:00	IWM	ETF	208.47	209.11	208.4	209.08	23189.0
2021-01-07 04:00:00	DIA	ETF	309.81	309.81	309.41	309.44	1621.0
2021-01-07 05:00:00	DIA	ETF	309.1	309.1	308.75	308.75	200.0

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

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