PREVIEW / etf_1hour / 2022-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-18.parquet
  size:    476 KB
  rows:    17,133

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
2022-01-18 04:00:00	SPY	ETF	461.45	461.45	458.47	459.36	111958.0
2022-01-18 05:00:00	SPY	ETF	459.35	460.1	459.11	459.59	53973.0
2022-01-18 06:00:00	SPY	ETF	459.49	459.9	459.0	459.59	57245.0
2022-01-18 07:00:00	SPY	ETF	459.74	460.8	459.69	460.699	387980.0
2022-01-18 08:00:00	SPY	ETF	459.99	462.93	458.9796	460.49	509308.0
2022-01-18 09:00:00	SPY	ETF	460.49	460.58	457.14	458.12	11341584.0
2022-01-18 10:00:00	SPY	ETF	458.1	459.55	457.24	457.5	10617726.0
2022-01-18 11:00:00	SPY	ETF	457.52	458.7277	456.58	458.07	8341187.0
2022-01-18 12:00:00	SPY	ETF	458.09	458.28	455.7199	455.8001	7800205.0
2022-01-18 13:00:00	SPY	ETF	455.81	457.32	455.46	457.15	8790889.0
2022-01-18 14:00:00	SPY	ETF	457.14	458.9	456.72	458.425	7314032.0
2022-01-18 15:00:00	SPY	ETF	458.42	458.65	455.31	456.51	21070469.0
2022-01-18 16:00:00	SPY	ETF	456.51	457.07	456.01	456.98	3737793.0
2022-01-18 17:00:00	SPY	ETF	456.98	457.02	456.94	457.01	74026.0
2022-01-18 18:00:00	SPY	ETF	457.02	457.29	456.15	456.16	82202.0
2022-01-18 19:00:00	SPY	ETF	456.18	456.56	455.53	455.82	86670.0
2022-01-18 04:00:00	QQQ	ETF	380.49	380.49	372.23	373.21	262539.0
2022-01-18 05:00:00	QQQ	ETF	373.26	373.97	373.05	373.4	96386.0
2022-01-18 06:00:00	QQQ	ETF	373.3	373.73	372.75	373.45	88057.0
2022-01-18 07:00:00	QQQ	ETF	373.49	374.85	373.49	374.64	406624.0
2022-01-18 08:00:00	QQQ	ETF	373.87	376.79	372.3896	374.62	811776.0
2022-01-18 09:00:00	QQQ	ETF	374.59	374.93	372.31	373.75	8505552.0
2022-01-18 10:00:00	QQQ	ETF	373.73	376.22	372.98	373.31	10070770.0
2022-01-18 11:00:00	QQQ	ETF	373.32	374.48	371.85	374.0117	6725828.0
2022-01-18 12:00:00	QQQ	ETF	374.02	374.2999	371.69	371.82	5575412.0
2022-01-18 13:00:00	QQQ	ETF	371.84	372.3597	371.11	372.1	5934843.0
2022-01-18 14:00:00	QQQ	ETF	372.07	373.62	371.52	373.11	5251633.0
2022-01-18 15:00:00	QQQ	ETF	373.14	373.35	369.7704	370.8	12652860.0
2022-01-18 16:00:00	QQQ	ETF	370.81	371.49	370.41	371.4	2722971.0
2022-01-18 17:00:00	QQQ	ETF	371.4	371.52	370.55	371.31	87200.0
2022-01-18 18:00:00	QQQ	ETF	371.35	371.6	370.33	370.37	133893.0
2022-01-18 19:00:00	QQQ	ETF	370.37	370.71	369.5	369.84	241791.0
2022-01-18 04:00:00	IWM	ETF	212.25	212.39	211.09	211.64	42141.0
2022-01-18 05:00:00	IWM	ETF	211.85	212.23	211.61	211.97	18764.0
2022-01-18 06:00:00	IWM	ETF	211.87	212.09	211.61	211.88	45872.0
2022-01-18 07:00:00	IWM	ETF	211.84	212.57	211.84	212.53	94342.0
2022-01-18 08:00:00	IWM	ETF	212.0	213.77	211.7596	212.6	120562.0
2022-01-18 09:00:00	IWM	ETF	212.64	212.72	210.6775	211.14	4117593.0
2022-01-18 10:00:00	IWM	ETF	211.12	212.05	209.88	210.21	5664558.0
2022-01-18 11:00:00	IWM	ETF	210.22	210.47	208.92	209.95	5171933.0
2022-01-18 12:00:00	IWM	ETF	209.96	210.05	208.5	208.58	3671106.0
2022-01-18 13:00:00	IWM	ETF	208.57	209.27	208.025	209.21	4471012.0
2022-01-18 14:00:00	IWM	ETF	209.18	210.72	209.045	210.1916	3745810.0
2022-01-18 15:00:00	IWM	ETF	210.21	210.37	207.53	207.79	8298399.0
2022-01-18 16:00:00	IWM	ETF	207.79	208.27	207.6	208.25	2762901.0
2022-01-18 17:00:00	IWM	ETF	208.06	208.29	207.83	208.0	27270.0
2022-01-18 18:00:00	IWM	ETF	208.09	208.44	207.63	207.63	34477.0
2022-01-18 19:00:00	IWM	ETF	207.71	208.08	207.3	207.49	51655.0
2022-01-18 04:00:00	DIA	ETF	357.15	357.15	355.85	355.85	3462.0
2022-01-18 05:00:00	DIA	ETF	356.7	356.81	356.47	356.48	1600.0

> showing 50 of 17,133 rows — these rows as CSV

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