PREVIEW / etf_1hour / 2019-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-15.parquet
  size:    313 KB
  rows:    10,488

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-15 04:00:00	SPY	ETF	290.01	290.11	290.0	290.11	950.0
2019-04-15 05:00:00	SPY	ETF	290.19	290.37	290.18	290.36	5114.0
2019-04-15 06:00:00	SPY	ETF	290.36	290.36	290.26	290.3	1544.0
2019-04-15 07:00:00	SPY	ETF	290.34	290.46	290.24	290.3	65220.0
2019-04-15 08:00:00	SPY	ETF	290.2699	290.4199	290.0	290.18	352708.0
2019-04-15 09:00:00	SPY	ETF	290.21	290.37	289.65	289.81	4350514.0
2019-04-15 10:00:00	SPY	ETF	289.81	289.95	289.075	289.39	9767828.0
2019-04-15 11:00:00	SPY	ETF	289.395	289.7	289.29	289.405	5615196.0
2019-04-15 12:00:00	SPY	ETF	289.405	289.495	289.14	289.43	3030880.0
2019-04-15 13:00:00	SPY	ETF	289.435	289.9	289.42	289.855	4984319.0
2019-04-15 14:00:00	SPY	ETF	289.8583	289.94	289.6885	289.905	3829171.0
2019-04-15 15:00:00	SPY	ETF	289.9	290.1	289.73	289.99	8704230.0
2019-04-15 16:00:00	SPY	ETF	289.99	290.08	289.91	290.04	7519194.0
2019-04-15 17:00:00	SPY	ETF	290.05	290.06	289.99	290.01	80190.0
2019-04-15 18:00:00	SPY	ETF	290.01	290.11	290.01	290.07	69976.0
2019-04-15 19:00:00	SPY	ETF	290.04	290.05	290.0	290.0	13166.0
2019-04-15 04:00:00	QQQ	ETF	185.68	185.74	185.64	185.74	29645.0
2019-04-15 05:00:00	QQQ	ETF	185.77	185.97	185.77	185.97	17395.0
2019-04-15 06:00:00	QQQ	ETF	185.86	185.9	185.79	185.79	4600.0
2019-04-15 07:00:00	QQQ	ETF	185.85	185.89	185.75	185.83	45846.0
2019-04-15 08:00:00	QQQ	ETF	185.84	185.95	185.74	185.79	105089.0
2019-04-15 09:00:00	QQQ	ETF	185.78	186.07	185.6	185.7	2160771.0
2019-04-15 10:00:00	QQQ	ETF	185.7	185.71	184.62	184.99	3424831.0
2019-04-15 11:00:00	QQQ	ETF	184.995	185.35	184.94	185.2201	1905417.0
2019-04-15 12:00:00	QQQ	ETF	185.22	185.29	184.96	185.22	1023651.0
2019-04-15 13:00:00	QQQ	ETF	185.2192	185.58	185.21	185.52	1182348.0
2019-04-15 14:00:00	QQQ	ETF	185.52	185.8777	185.48	185.87	2127890.0
2019-04-15 15:00:00	QQQ	ETF	185.86	186.06	185.71	185.88	3132553.0
2019-04-15 16:00:00	QQQ	ETF	185.88	185.91	185.75	185.85	695647.0
2019-04-15 17:00:00	QQQ	ETF	185.9	185.95	185.84	185.88	6395.0
2019-04-15 18:00:00	QQQ	ETF	185.88	185.95	185.86	185.89	10752.0
2019-04-15 19:00:00	QQQ	ETF	185.86	185.89	185.84	185.88	24740.0
2019-04-15 06:00:00	IWM	ETF	157.79	157.79	157.78	157.78	1222.0
2019-04-15 07:00:00	IWM	ETF	157.91	157.93	157.87	157.87	7832.0
2019-04-15 08:00:00	IWM	ETF	157.9301	157.9301	157.71	157.82	46656.0
2019-04-15 09:00:00	IWM	ETF	157.79	158.1	157.3727	157.48	1363792.0
2019-04-15 10:00:00	IWM	ETF	157.48	157.69	156.72	157.0	1625321.0
2019-04-15 11:00:00	IWM	ETF	157.01	157.58	156.975	157.13	1437513.0
2019-04-15 12:00:00	IWM	ETF	157.14	157.18	156.5	156.6775	1338061.0
2019-04-15 13:00:00	IWM	ETF	156.67	157.08	156.66	156.91	738515.0
2019-04-15 14:00:00	IWM	ETF	156.92	157.04	156.82	157.0138	753837.0
2019-04-15 15:00:00	IWM	ETF	157.02	157.17	156.84	157.12	1824766.0
2019-04-15 16:00:00	IWM	ETF	157.14	157.22	157.03	157.12	517363.0
2019-04-15 17:00:00	IWM	ETF	157.15	157.15	157.15	157.15	100.0
2019-04-15 18:00:00	IWM	ETF	157.2	157.2	157.2	157.2	1800.0
2019-04-15 19:00:00	IWM	ETF	157.18	157.18	157.17	157.17	1100.0
2019-04-15 05:00:00	DIA	ETF	264.35	264.42	264.35	264.42	700.0
2019-04-15 07:00:00	DIA	ETF	264.55	264.64	264.1	264.1	6271.0
2019-04-15 08:00:00	DIA	ETF	264.16	264.4999	263.81	263.97	12252.0
2019-04-15 09:00:00	DIA	ETF	264.03	264.19	263.41	263.66	421411.0

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

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