PREVIEW / etf_1hour / 2019-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-26.parquet
  size:    320 KB
  rows:    10,631

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
2019-04-26 04:00:00	SPY	ETF	291.55	291.69	291.53	291.58	5568.0
2019-04-26 05:00:00	SPY	ETF	291.57	291.7	291.5	291.68	1258.0
2019-04-26 06:00:00	SPY	ETF	291.8	291.92	291.72	291.89	8029.0
2019-04-26 07:00:00	SPY	ETF	291.85	291.94	291.54	291.56	145765.0
2019-04-26 08:00:00	SPY	ETF	291.8301	292.51	291.37	292.15	892324.0
2019-04-26 09:00:00	SPY	ETF	292.18	292.56	291.3	291.51	6073633.0
2019-04-26 10:00:00	SPY	ETF	291.515	292.27	291.2401	292.04	5785235.0
2019-04-26 11:00:00	SPY	ETF	292.04	292.75	291.83	292.49	5861079.0
2019-04-26 12:00:00	SPY	ETF	292.5	292.7	292.38	292.48	2516691.0
2019-04-26 13:00:00	SPY	ETF	292.48	292.51	292.26	292.45	2617867.0
2019-04-26 14:00:00	SPY	ETF	292.45	292.705	292.13	292.64	5335516.0
2019-04-26 15:00:00	SPY	ETF	292.65	293.49	292.645	293.44	11265165.0
2019-04-26 16:00:00	SPY	ETF	293.43	293.54	292.4809	293.21	8435564.0
2019-04-26 17:00:00	SPY	ETF	293.26	293.42	293.06	293.3	763265.0
2019-04-26 18:00:00	SPY	ETF	293.29	293.35	293.27	293.32	13158.0
2019-04-26 19:00:00	SPY	ETF	293.33	293.36	293.27	293.3	13747.0
2019-04-26 04:00:00	QQQ	ETF	189.84	189.87	189.72	189.82	4444.0
2019-04-26 05:00:00	QQQ	ETF	189.76	189.83	189.64	189.8	4300.0
2019-04-26 06:00:00	QQQ	ETF	189.85	189.98	189.85	189.89	13965.0
2019-04-26 07:00:00	QQQ	ETF	189.89	189.97	189.62	189.67	28926.0
2019-04-26 08:00:00	QQQ	ETF	189.64	190.47	189.55	190.34	427739.0
2019-04-26 09:00:00	QQQ	ETF	190.36	190.63	188.74	188.94	5142153.0
2019-04-26 10:00:00	QQQ	ETF	188.95	189.72	188.59	189.62	3446713.0
2019-04-26 11:00:00	QQQ	ETF	189.62	190.092	189.46	189.83	2267904.0
2019-04-26 12:00:00	QQQ	ETF	189.8201	190.1	189.77	189.89	1987425.0
2019-04-26 13:00:00	QQQ	ETF	189.8999	189.91	189.57	189.83	1528222.0
2019-04-26 14:00:00	QQQ	ETF	189.84	190.2	189.64	190.18	1511053.0
2019-04-26 15:00:00	QQQ	ETF	190.2	190.69	190.16	190.66	4471996.0
2019-04-26 16:00:00	QQQ	ETF	190.67	190.75	190.56	190.56	1144689.0
2019-04-26 17:00:00	QQQ	ETF	190.65	190.68	190.54	190.55	64353.0
2019-04-26 18:00:00	QQQ	ETF	190.55	190.55	190.55	190.55	200.0
2019-04-26 19:00:00	QQQ	ETF	190.55	190.69	190.55	190.62	5138.0
2019-04-26 07:00:00	IWM	ETF	156.73	156.73	156.65	156.65	1600.0
2019-04-26 08:00:00	IWM	ETF	156.69	157.15	156.45	156.99	98257.0
2019-04-26 09:00:00	IWM	ETF	156.95	157.15	156.395	156.9	2535679.0
2019-04-26 10:00:00	IWM	ETF	156.9	157.61	156.73	157.38	2735066.0
2019-04-26 11:00:00	IWM	ETF	157.39	158.01	157.2007	157.68	1726549.0
2019-04-26 12:00:00	IWM	ETF	157.68	158.15	157.66	157.98	1402403.0
2019-04-26 13:00:00	IWM	ETF	157.96	158.13	157.7585	158.03	808247.0
2019-04-26 14:00:00	IWM	ETF	158.05	158.22	157.83	158.17	941330.0
2019-04-26 15:00:00	IWM	ETF	158.1785	158.49	158.14	158.29	4223347.0
2019-04-26 16:00:00	IWM	ETF	158.3	158.36	158.13	158.13	692730.0
2019-04-26 17:00:00	IWM	ETF	158.14	158.1401	158.14	158.1401	308.0
2019-04-26 18:00:00	IWM	ETF	158.15	158.15	158.15	158.15	200.0
2019-04-26 19:00:00	IWM	ETF	158.2	158.2	158.2	158.2	127.0
2019-04-26 07:00:00	DIA	ETF	264.18	264.18	263.87	263.87	1200.0
2019-04-26 08:00:00	DIA	ETF	264.1501	264.61	263.55	264.29	7829.0
2019-04-26 09:00:00	DIA	ETF	264.39	264.76	263.86	264.07	274032.0
2019-04-26 10:00:00	DIA	ETF	264.09	264.6	263.87	264.3699	305798.0
2019-04-26 11:00:00	DIA	ETF	264.31	264.9	264.17	264.81	154992.0

> showing 50 of 10,631 rows — these rows as CSV

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