PREVIEW / etf_1hour / 2019-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-12.parquet
  size:    322 KB
  rows:    10,715

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-12 04:00:00	SPY	ETF	288.6	289.5	288.6	289.5	34323.0
2019-04-12 05:00:00	SPY	ETF	289.57	289.58	289.22	289.31	19447.0
2019-04-12 06:00:00	SPY	ETF	289.32	289.6	289.32	289.54	55877.0
2019-04-12 07:00:00	SPY	ETF	289.5	289.85	289.5	289.65	185316.0
2019-04-12 08:00:00	SPY	ETF	289.67	290.19	288.38	290.0	477320.0
2019-04-12 09:00:00	SPY	ETF	290.0	290.47	289.85	290.31	8821546.0
2019-04-12 10:00:00	SPY	ETF	290.32	290.375	289.37	289.57	11268989.0
2019-04-12 11:00:00	SPY	ETF	289.59	289.64	289.26	289.57	5703960.0
2019-04-12 12:00:00	SPY	ETF	289.56	289.96	289.45	289.955	3542293.0
2019-04-12 13:00:00	SPY	ETF	289.955	290.09	289.82	289.8285	4239618.0
2019-04-12 14:00:00	SPY	ETF	289.8299	290.08	289.75	289.77	4734011.0
2019-04-12 15:00:00	SPY	ETF	289.77	290.2	289.74	290.19	15125840.0
2019-04-12 16:00:00	SPY	ETF	290.18	290.25	290.06	290.17	14311548.0
2019-04-12 17:00:00	SPY	ETF	290.17	290.25	290.0	290.2	98321.0
2019-04-12 18:00:00	SPY	ETF	290.18	290.29	290.18	290.24	43011.0
2019-04-12 19:00:00	SPY	ETF	290.26	290.28	290.16	290.22	24239.0
2019-04-12 04:00:00	QQQ	ETF	185.24	185.98	185.24	185.9	42509.0
2019-04-12 05:00:00	QQQ	ETF	185.89	185.91	185.75	185.77	29405.0
2019-04-12 06:00:00	QQQ	ETF	185.77	185.92	185.68	185.81	23956.0
2019-04-12 07:00:00	QQQ	ETF	185.78	186.05	185.73	185.83	192157.0
2019-04-12 08:00:00	QQQ	ETF	185.85	186.21	185.25	185.94	231650.0
2019-04-12 09:00:00	QQQ	ETF	185.94	185.99	185.53	185.76	3387613.0
2019-04-12 10:00:00	QQQ	ETF	185.8	185.92	185.38	185.5	3411347.0
2019-04-12 11:00:00	QQQ	ETF	185.505	185.52	185.0601	185.4675	2163115.0
2019-04-12 12:00:00	QQQ	ETF	185.46	185.63	185.36	185.62	1339876.0
2019-04-12 13:00:00	QQQ	ETF	185.62	185.72	185.49	185.53	1363987.0
2019-04-12 14:00:00	QQQ	ETF	185.53	185.81	185.49	185.7	1983191.0
2019-04-12 15:00:00	QQQ	ETF	185.695	185.85	185.61	185.84	4842543.0
2019-04-12 16:00:00	QQQ	ETF	185.84	185.91	185.1429	185.91	991671.0
2019-04-12 17:00:00	QQQ	ETF	185.86	185.93	185.83	185.83	5707.0
2019-04-12 18:00:00	QQQ	ETF	185.83	185.83	185.83	185.83	831.0
2019-04-12 19:00:00	QQQ	ETF	185.89	185.9	185.84	185.89	1750.0
2019-04-12 04:00:00	IWM	ETF	157.42	157.65	157.42	157.65	3900.0
2019-04-12 05:00:00	IWM	ETF	157.59	157.59	157.59	157.59	500.0
2019-04-12 06:00:00	IWM	ETF	157.6	157.7	157.6	157.66	8340.0
2019-04-12 07:00:00	IWM	ETF	157.75	157.95	157.75	157.87	36832.0
2019-04-12 08:00:00	IWM	ETF	157.51	158.15	156.97	158.03	38048.0
2019-04-12 09:00:00	IWM	ETF	158.09	158.14	157.66	158.08	2299695.0
2019-04-12 10:00:00	IWM	ETF	158.0912	158.16	157.23	157.32	2368106.0
2019-04-12 11:00:00	IWM	ETF	157.33	157.5	157.11	157.3738	1584513.0
2019-04-12 12:00:00	IWM	ETF	157.37	157.665	157.32	157.59	954703.0
2019-04-12 13:00:00	IWM	ETF	157.585	157.7	157.475	157.49	598500.0
2019-04-12 14:00:00	IWM	ETF	157.49	157.6321	157.24	157.33	526977.0
2019-04-12 15:00:00	IWM	ETF	157.33	157.75	157.26	157.68	3264441.0
2019-04-12 16:00:00	IWM	ETF	157.68	157.75	157.61	157.69	1226553.0
2019-04-12 17:00:00	IWM	ETF	157.68	157.71	157.67	157.71	600.0
2019-04-12 19:00:00	IWM	ETF	157.65	157.68	157.65	157.68	1150.0
2019-04-12 04:00:00	DIA	ETF	262.94	262.94	262.94	262.94	100.0
2019-04-12 05:00:00	DIA	ETF	262.84	262.96	262.84	262.96	625.0
2019-04-12 06:00:00	DIA	ETF	262.9	263.1	262.9	263.1	13438.0

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

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