PREVIEW / etf_1hour / 2021-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-06.parquet
  size:    428 KB
  rows:    14,911

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-06 04:00:00	SPY	ETF	368.66	370.64	368.04	370.13	142523.0
2021-01-06 05:00:00	SPY	ETF	370.37	371.0	369.89	370.47	129394.0
2021-01-06 06:00:00	SPY	ETF	370.43	370.61	369.3	370.45	150797.0
2021-01-06 07:00:00	SPY	ETF	370.43	371.41	369.85	369.95	955443.0
2021-01-06 08:00:00	SPY	ETF	369.92	371.41	368.86	369.46	913889.0
2021-01-06 09:00:00	SPY	ETF	369.41	372.41	369.12	372.23	9443561.0
2021-01-06 10:00:00	SPY	ETF	372.2463	375.75	371.96	375.1031	12922944.0
2021-01-06 11:00:00	SPY	ETF	375.11	376.16	375.02	375.4	7962897.0
2021-01-06 12:00:00	SPY	ETF	375.42	376.58	375.38	376.44	6873269.0
2021-01-06 13:00:00	SPY	ETF	376.445	376.98	376.085	376.4899	5905344.0
2021-01-06 14:00:00	SPY	ETF	376.48	376.9	373.0	374.475	19891164.0
2021-01-06 15:00:00	SPY	ETF	374.47	375.18	372.83	373.53	29353862.0
2021-01-06 16:00:00	SPY	ETF	373.43	374.97	372.6	374.35	7027845.0
2021-01-06 17:00:00	SPY	ETF	374.26	375.0	373.55	374.75	4015045.0
2021-01-06 18:00:00	SPY	ETF	374.73	374.84	374.15	374.47	1003021.0
2021-01-06 19:00:00	SPY	ETF	374.4	375.01	373.8	375.0	409723.0
2021-01-06 04:00:00	QQQ	ETF	305.22	306.99	305.19	306.72	189440.0
2021-01-06 05:00:00	QQQ	ETF	306.76	306.76	305.39	305.83	283996.0
2021-01-06 06:00:00	QQQ	ETF	305.79	306.74	304.83	306.57	252932.0
2021-01-06 07:00:00	QQQ	ETF	306.62	308.06	306.57	307.06	816503.0
2021-01-06 08:00:00	QQQ	ETF	306.99	308.51	304.84	306.53	1064668.0
2021-01-06 09:00:00	QQQ	ETF	306.42	308.81	305.98	308.0	7586320.0
2021-01-06 10:00:00	QQQ	ETF	308.01	311.22	307.4802	310.38	6099062.0
2021-01-06 11:00:00	QQQ	ETF	310.4	311.66	310.2	310.83	3878957.0
2021-01-06 12:00:00	QQQ	ETF	310.865	311.88	310.79	311.17	2827170.0
2021-01-06 13:00:00	QQQ	ETF	311.175	311.82	310.645	311.24	2487013.0
2021-01-06 14:00:00	QQQ	ETF	311.25	311.59	308.0	309.12	6230174.0
2021-01-06 15:00:00	QQQ	ETF	309.1	309.54	307.01	307.57	8006861.0
2021-01-06 16:00:00	QQQ	ETF	307.5	311.7988	306.88	308.45	1225187.0
2021-01-06 17:00:00	QQQ	ETF	308.55	308.7	308.24	308.55	40847.0
2021-01-06 18:00:00	QQQ	ETF	308.55	308.95	308.25	308.95	98600.0
2021-01-06 19:00:00	QQQ	ETF	308.91	309.49	308.5	309.49	84341.0
2021-01-06 04:00:00	IWM	ETF	198.0	200.12	197.36	200.02	69322.0
2021-01-06 05:00:00	IWM	ETF	200.22	202.45	200.22	201.59	124602.0
2021-01-06 06:00:00	IWM	ETF	201.66	201.66	200.7	201.51	58170.0
2021-01-06 07:00:00	IWM	ETF	201.38	202.62	201.1	201.56	528147.0
2021-01-06 08:00:00	IWM	ETF	201.46	202.5904	196.87	200.11	517192.0
2021-01-06 09:00:00	IWM	ETF	200.11	201.11	199.11	200.99	4992381.0
2021-01-06 10:00:00	IWM	ETF	201.005	202.98	200.73	202.905	5303063.0
2021-01-06 11:00:00	IWM	ETF	202.91	204.69	202.87	204.53	5317893.0
2021-01-06 12:00:00	IWM	ETF	204.53	206.09	204.51	205.78	4627266.0
2021-01-06 13:00:00	IWM	ETF	205.78	206.715	205.46	206.18	3738279.0
2021-01-06 14:00:00	IWM	ETF	206.185	206.78	201.748	203.79	7373117.0
2021-01-06 15:00:00	IWM	ETF	203.79	204.66	202.82	204.52	9571809.0
2021-01-06 16:00:00	IWM	ETF	204.53	205.42	203.7	204.54	1862776.0
2021-01-06 17:00:00	IWM	ETF	204.79	205.51	204.46	205.12	222163.0
2021-01-06 18:00:00	IWM	ETF	205.21	205.21	204.53	204.96	132615.0
2021-01-06 19:00:00	IWM	ETF	204.83	205.28	204.21	205.21	52461.0
2021-01-06 04:00:00	DIA	ETF	302.89	304.6	302.85	304.21	9479.0
2021-01-06 05:00:00	DIA	ETF	304.5	305.09	304.26	304.83	16650.0

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

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