PREVIEW / etf_1hour / 2018-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-22.parquet
  size:    296 KB
  rows:    9,780

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
2018-06-22 04:00:00	SPY	ETF	275.07	275.55	275.07	275.48	59398.0
2018-06-22 05:00:00	SPY	ETF	275.49	275.61	275.38	275.38	35665.0
2018-06-22 06:00:00	SPY	ETF	275.31	275.51	275.3	275.44	30543.0
2018-06-22 07:00:00	SPY	ETF	275.44	275.58	275.28	275.58	253995.0
2018-06-22 08:00:00	SPY	ETF	275.56	275.75	274.24	275.6	513601.0
2018-06-22 09:00:00	SPY	ETF	275.6	275.785	274.99	275.18	6012987.0
2018-06-22 10:00:00	SPY	ETF	275.175	275.61	274.68	275.21	9280442.0
2018-06-22 11:00:00	SPY	ETF	275.21	275.52	274.92	275.3185	4567851.0
2018-06-22 12:00:00	SPY	ETF	275.32	275.61	275.21	275.35	2728350.0
2018-06-22 13:00:00	SPY	ETF	275.36	275.64	275.34	275.5473	3214361.0
2018-06-22 14:00:00	SPY	ETF	275.55	275.68	275.155	275.48	4066705.0
2018-06-22 15:00:00	SPY	ETF	275.48	275.505	274.49	274.71	12949368.0
2018-06-22 16:00:00	SPY	ETF	274.71	275.13	274.65	274.67	9337354.0
2018-06-22 17:00:00	SPY	ETF	274.67	274.8	274.45	274.45	1011195.0
2018-06-22 18:00:00	SPY	ETF	274.49	274.62	274.46	274.54	39154.0
2018-06-22 19:00:00	SPY	ETF	274.54	274.61	274.5	274.5	21745.0
2018-06-22 04:00:00	QQQ	ETF	176.0	176.29	175.72	176.26	5123.0
2018-06-22 05:00:00	QQQ	ETF	176.29	176.41	176.24	176.28	21700.0
2018-06-22 06:00:00	QQQ	ETF	176.21	176.33	176.19	176.3	17400.0
2018-06-22 07:00:00	QQQ	ETF	176.27	176.32	176.14	176.31	81722.0
2018-06-22 08:00:00	QQQ	ETF	176.15	176.5	176.15	176.35	183206.0
2018-06-22 09:00:00	QQQ	ETF	176.35	176.38	175.07	175.21	4272159.0
2018-06-22 10:00:00	QQQ	ETF	175.205	175.6	174.69	175.22	5798348.0
2018-06-22 11:00:00	QQQ	ETF	175.22	175.5854	175.045	175.42	2138965.0
2018-06-22 12:00:00	QQQ	ETF	175.425	175.715	175.37	175.5949	1493590.0
2018-06-22 13:00:00	QQQ	ETF	175.59	175.92	175.59	175.83	2396090.0
2018-06-22 14:00:00	QQQ	ETF	175.82	175.88	175.46	175.74	3230221.0
2018-06-22 15:00:00	QQQ	ETF	175.74	175.77	175.01	175.14	6051191.0
2018-06-22 16:00:00	QQQ	ETF	175.14	175.43	175.13	175.18	1255682.0
2018-06-22 17:00:00	QQQ	ETF	175.2	175.2	175.1	175.14	16809.0
2018-06-22 18:00:00	QQQ	ETF	175.17	175.18	175.02	175.03	3574.0
2018-06-22 19:00:00	QQQ	ETF	175.03	175.13	175.02	175.05	4794.0
2018-06-22 04:00:00	IWM	ETF	168.64	168.89	168.64	168.89	14620.0
2018-06-22 05:00:00	IWM	ETF	168.88	168.91	168.87	168.87	3806.0
2018-06-22 06:00:00	IWM	ETF	168.79	168.85	168.73	168.85	2005.0
2018-06-22 07:00:00	IWM	ETF	168.83	168.89	168.76	168.89	24060.0
2018-06-22 08:00:00	IWM	ETF	168.87	169.0	168.78	168.89	125982.0
2018-06-22 09:00:00	IWM	ETF	168.89	169.2	168.18	168.52	2740251.0
2018-06-22 10:00:00	IWM	ETF	168.53	168.87	168.07	168.47	3033895.0
2018-06-22 11:00:00	IWM	ETF	168.47	168.62	168.24	168.28	2458396.0
2018-06-22 12:00:00	IWM	ETF	168.29	168.51	167.88	167.9825	1853430.0
2018-06-22 13:00:00	IWM	ETF	167.97	168.5	167.96	168.35	2002524.0
2018-06-22 14:00:00	IWM	ETF	168.35	168.36	167.33	167.38	3733089.0
2018-06-22 15:00:00	IWM	ETF	167.38	168.11	167.31	167.76	10646806.0
2018-06-22 16:00:00	IWM	ETF	167.76	168.25	167.73	167.97	2566276.0
2018-06-22 17:00:00	IWM	ETF	168.02	168.03	167.92	167.98	50800.0
2018-06-22 18:00:00	IWM	ETF	167.82	167.9	167.82	167.83	1251.0
2018-06-22 19:00:00	IWM	ETF	167.85	167.9	167.83	167.83	1269.0
2018-06-22 04:00:00	DIA	ETF	245.15	245.75	245.15	245.75	1400.0
2018-06-22 05:00:00	DIA	ETF	245.8	245.81	245.59	245.59	2151.0

> showing 50 of 9,780 rows — these rows as CSV

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