PREVIEW / etf_1hour / 2018-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-16.parquet
  size:    286 KB
  rows:    9,426

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-03-16 04:00:00	SPY	ETF	273.88	274.51	273.88	274.46	54833.0
2018-03-16 05:00:00	SPY	ETF	274.47	274.6	274.41	274.48	52468.0
2018-03-16 06:00:00	SPY	ETF	274.44	274.59	274.26	274.58	24191.0
2018-03-16 07:00:00	SPY	ETF	274.57	274.62	274.22	274.23	183735.0
2018-03-16 08:00:00	SPY	ETF	274.23	275.0	273.9	274.65	447899.0
2018-03-16 09:00:00	SPY	ETF	274.62	275.08	274.3	274.82	7265037.0
2018-03-16 10:00:00	SPY	ETF	274.83	275.25	274.57	275.13	21471523.0
2018-03-16 11:00:00	SPY	ETF	275.12	275.39	274.58	274.65	12507355.0
2018-03-16 12:00:00	SPY	ETF	274.65	275.13	274.51	275.0	7155980.0
2018-03-16 13:00:00	SPY	ETF	275.005	275.12	274.25	274.41	5989244.0
2018-03-16 14:00:00	SPY	ETF	274.41	274.695	274.16	274.6	6584372.0
2018-03-16 15:00:00	SPY	ETF	274.605	274.99	274.19	274.19	17232224.0
2018-03-16 16:00:00	SPY	ETF	274.2	274.62	274.14	274.36	15803571.0
2018-03-16 17:00:00	SPY	ETF	274.36	274.4	274.01	274.12	3444968.0
2018-03-16 18:00:00	SPY	ETF	274.13	274.4	274.06	274.34	58832.0
2018-03-16 19:00:00	SPY	ETF	274.37	275.4	273.99	274.9	468216.0
2018-03-16 04:00:00	QQQ	ETF	171.46	171.78	171.41	171.78	20277.0
2018-03-16 05:00:00	QQQ	ETF	171.78	171.83	171.73	171.81	56932.0
2018-03-16 06:00:00	QQQ	ETF	171.85	171.85	171.74	171.84	8550.0
2018-03-16 07:00:00	QQQ	ETF	171.88	171.9	171.63	171.65	57014.0
2018-03-16 08:00:00	QQQ	ETF	171.8	171.98	171.58	171.91	107153.0
2018-03-16 09:00:00	QQQ	ETF	171.83	172.2	171.62	172.025	2774465.0
2018-03-16 10:00:00	QQQ	ETF	172.03	172.19	171.69	171.96	2727545.0
2018-03-16 11:00:00	QQQ	ETF	171.95	172.075	170.935	171.02	2951358.0
2018-03-16 12:00:00	QQQ	ETF	171.0199	171.47	170.99	171.45	2128154.0
2018-03-16 13:00:00	QQQ	ETF	171.44	171.5338	171.03	171.14	1403185.0
2018-03-16 14:00:00	QQQ	ETF	171.16	171.35	171.03	171.19	1227609.0
2018-03-16 15:00:00	QQQ	ETF	171.19	171.52	171.02	171.05	5510793.0
2018-03-16 16:00:00	QQQ	ETF	171.05	171.24	171.01	171.18	3921949.0
2018-03-16 17:00:00	QQQ	ETF	171.23	171.3	170.96	171.05	1288706.0
2018-03-16 18:00:00	QQQ	ETF	171.09	171.15	171.02	171.1	7411.0
2018-03-16 19:00:00	QQQ	ETF	171.12	171.42	170.96	171.26	29796.0
2018-03-16 04:00:00	IWM	ETF	156.86	156.95	156.86	156.86	5992.0
2018-03-16 05:00:00	IWM	ETF	157.25	157.25	157.25	157.25	300.0
2018-03-16 06:00:00	IWM	ETF	157.21	157.21	157.03	157.15	4600.0
2018-03-16 07:00:00	IWM	ETF	157.01	157.08	156.92	156.93	8936.0
2018-03-16 08:00:00	IWM	ETF	156.92	157.32	156.89	157.24	41915.0
2018-03-16 09:00:00	IWM	ETF	157.33	157.33	156.75	156.9664	1430348.0
2018-03-16 10:00:00	IWM	ETF	156.96	158.07	156.86	157.83	1941859.0
2018-03-16 11:00:00	IWM	ETF	157.82	158.2301	157.53	157.85	1917172.0
2018-03-16 12:00:00	IWM	ETF	157.86	158.27	157.68	158.12	1177555.0
2018-03-16 13:00:00	IWM	ETF	158.13	158.1999	157.4715	157.64	1712611.0
2018-03-16 14:00:00	IWM	ETF	157.64	157.81	157.44	157.76	1127891.0
2018-03-16 15:00:00	IWM	ETF	157.76	158.11	157.64	157.75	4192574.0
2018-03-16 16:00:00	IWM	ETF	157.76	157.98	157.74	157.86	2641624.0
2018-03-16 17:00:00	IWM	ETF	157.81	157.95	157.7	157.75	1284319.0
2018-03-16 18:00:00	IWM	ETF	157.75	157.8	157.71	157.8	1100.0
2018-03-16 19:00:00	IWM	ETF	157.8	158.11	157.8	158.1	12237.0
2018-03-16 04:00:00	DIA	ETF	248.31	248.31	248.18	248.24	934.0
2018-03-16 06:00:00	DIA	ETF	249.5	250.5	248.53	248.53	3024.0

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

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