PREVIEW / etf_1hour / 2020-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-24.parquet
  size:    362 KB
  rows:    12,422

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-07-24 04:00:00	SPY	ETF	320.67	321.6	320.53	321.6	128079.0
2020-07-24 05:00:00	SPY	ETF	321.68	322.09	321.34	322.0	53692.0
2020-07-24 06:00:00	SPY	ETF	321.98	322.52	321.67	321.93	270282.0
2020-07-24 07:00:00	SPY	ETF	322.03	322.49	320.93	321.5	392371.0
2020-07-24 08:00:00	SPY	ETF	322.2501	322.49	320.6	321.6	294931.0
2020-07-24 09:00:00	SPY	ETF	321.59	321.75	319.49	320.6	10418994.0
2020-07-24 10:00:00	SPY	ETF	320.605	321.84	320.18	321.78	10634000.0
2020-07-24 11:00:00	SPY	ETF	321.78	321.99	320.83	321.33	5970701.0
2020-07-24 12:00:00	SPY	ETF	321.33	321.41	320.01	320.245	5499433.0
2020-07-24 13:00:00	SPY	ETF	320.25	320.69	319.246	320.535	6274166.0
2020-07-24 14:00:00	SPY	ETF	320.54	321.4	320.41	320.785	5563234.0
2020-07-24 15:00:00	SPY	ETF	320.78	321.45	319.67	320.86	14181582.0
2020-07-24 16:00:00	SPY	ETF	320.86	321.13	320.325	320.42	12396300.0
2020-07-24 17:00:00	SPY	ETF	320.41	320.88	320.35	320.35	131334.0
2020-07-24 18:00:00	SPY	ETF	320.35	320.47	320.31	320.31	9301.0
2020-07-24 19:00:00	SPY	ETF	320.31	320.36	319.99	320.2	31735.0
2020-07-24 04:00:00	QQQ	ETF	254.32	254.7	254.02	254.57	103747.0
2020-07-24 05:00:00	QQQ	ETF	254.66	255.36	254.38	255.36	72344.0
2020-07-24 06:00:00	QQQ	ETF	255.31	255.79	254.86	255.41	234986.0
2020-07-24 07:00:00	QQQ	ETF	255.46	256.16	254.04	254.851	640730.0
2020-07-24 08:00:00	QQQ	ETF	256.0801	256.27	253.7	254.84	753778.0
2020-07-24 09:00:00	QQQ	ETF	254.84	255.05	251.32	253.33	10525029.0
2020-07-24 10:00:00	QQQ	ETF	253.32	256.275	253.12	256.21	8737337.0
2020-07-24 11:00:00	QQQ	ETF	256.22	256.93	255.5	256.4099	5355604.0
2020-07-24 12:00:00	QQQ	ETF	256.42	256.44	254.25	254.48	4632984.0
2020-07-24 13:00:00	QQQ	ETF	254.52	255.82	253.33	255.53	3988286.0
2020-07-24 14:00:00	QQQ	ETF	255.53	256.4697	255.095	255.63	4256979.0
2020-07-24 15:00:00	QQQ	ETF	255.61	256.31	254.45	255.44	6745394.0
2020-07-24 16:00:00	QQQ	ETF	255.44	255.68	255.12	255.29	1449565.0
2020-07-24 17:00:00	QQQ	ETF	255.24	255.42	255.2	255.24	22963.0
2020-07-24 18:00:00	QQQ	ETF	255.2	255.25	254.9	254.9	13576.0
2020-07-24 19:00:00	QQQ	ETF	254.9	255.15	254.8	255.08	32571.0
2020-07-24 04:00:00	IWM	ETF	147.49	147.99	147.49	147.9	25495.0
2020-07-24 05:00:00	IWM	ETF	147.81	148.06	147.81	148.06	9124.0
2020-07-24 06:00:00	IWM	ETF	148.07	148.23	147.9	148.05	20348.0
2020-07-24 07:00:00	IWM	ETF	148.07	148.25	147.75	147.93	24987.0
2020-07-24 08:00:00	IWM	ETF	148.04	148.26	147.47	148.04	59428.0
2020-07-24 09:00:00	IWM	ETF	148.08	148.1	146.21	146.59	2177348.0
2020-07-24 10:00:00	IWM	ETF	146.585	147.53	146.51	147.45	2536470.0
2020-07-24 11:00:00	IWM	ETF	147.44	147.56	146.51	146.67	1786090.0
2020-07-24 12:00:00	IWM	ETF	146.7	146.81	146.15	146.34	1603249.0
2020-07-24 13:00:00	IWM	ETF	146.34	146.46	145.56	146.295	1888379.0
2020-07-24 14:00:00	IWM	ETF	146.3	146.68	146.1201	146.33	1186555.0
2020-07-24 15:00:00	IWM	ETF	146.33	146.53	145.63	146.04	4325233.0
2020-07-24 16:00:00	IWM	ETF	146.05	146.15	145.73	145.88	572656.0
2020-07-24 17:00:00	IWM	ETF	145.62	146.03	145.62	145.99	11930.0
2020-07-24 18:00:00	IWM	ETF	145.99	146.08	145.99	146.08	1103.0
2020-07-24 19:00:00	IWM	ETF	145.91	146.1	145.9	146.09	800.0
2020-07-24 04:00:00	DIA	ETF	264.7	265.4	264.7	265.4	3799.0
2020-07-24 05:00:00	DIA	ETF	265.52	266.0	265.52	266.0	1950.0

> showing 50 of 12,422 rows — these rows as CSV

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