PREVIEW / etf_1hour / 2017-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-22.parquet
  size:    275 KB
  rows:    8,986

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
2017-02-22 04:00:00	SPY	ETF	236.27	236.35	236.12	236.17	17050.0
2017-02-22 05:00:00	SPY	ETF	236.17	236.23	235.81	235.85	14285.0
2017-02-22 06:00:00	SPY	ETF	235.92	236.05	235.78	235.78	31025.0
2017-02-22 07:00:00	SPY	ETF	235.77	235.88	235.76	235.83	87851.0
2017-02-22 08:00:00	SPY	ETF	235.83	236.03	235.78	236.0	274429.0
2017-02-22 09:00:00	SPY	ETF	236.0	236.16	235.83	235.99	5804685.0
2017-02-22 10:00:00	SPY	ETF	235.99	236.54	235.97	236.28	8391128.0
2017-02-22 11:00:00	SPY	ETF	236.275	236.31	236.04	236.11	6425720.0
2017-02-22 12:00:00	SPY	ETF	236.11	236.37	236.07	236.36	3874415.0
2017-02-22 13:00:00	SPY	ETF	236.36	236.49	236.33	236.43	3684112.0
2017-02-22 14:00:00	SPY	ETF	236.44	236.48	235.97	236.175	8746948.0
2017-02-22 15:00:00	SPY	ETF	236.19	236.42	236.12	236.3	15804735.0
2017-02-22 16:00:00	SPY	ETF	236.3	236.46	236.22	236.46	7957298.0
2017-02-22 17:00:00	SPY	ETF	236.42	236.45	236.28	236.38	182485.0
2017-02-22 18:00:00	SPY	ETF	236.4	236.45	236.26	236.32	108159.0
2017-02-22 19:00:00	SPY	ETF	236.3	236.34	236.17	236.21	40631.0
2017-02-22 04:00:00	QQQ	ETF	130.35	130.36	130.3	130.3	758.0
2017-02-22 05:00:00	QQQ	ETF	130.3	130.3	130.19	130.2	11546.0
2017-02-22 06:00:00	QQQ	ETF	130.17	130.25	130.17	130.25	10270.0
2017-02-22 07:00:00	QQQ	ETF	130.16	130.21	130.16	130.21	10000.0
2017-02-22 08:00:00	QQQ	ETF	130.2	130.31	130.19	130.29	217114.0
2017-02-22 09:00:00	QQQ	ETF	130.3	130.42	130.111	130.2	1492833.0
2017-02-22 10:00:00	QQQ	ETF	130.21	130.4734	130.17	130.36	2204356.0
2017-02-22 11:00:00	QQQ	ETF	130.365	130.45	130.23	130.35	1237414.0
2017-02-22 12:00:00	QQQ	ETF	130.35	130.52	130.34	130.5169	848015.0
2017-02-22 13:00:00	QQQ	ETF	130.52	130.5567	130.47	130.52	745539.0
2017-02-22 14:00:00	QQQ	ETF	130.52	130.59	130.345	130.37	1452471.0
2017-02-22 15:00:00	QQQ	ETF	130.37	130.55	130.34	130.49	1868742.0
2017-02-22 16:00:00	QQQ	ETF	130.49	130.54	130.37	130.54	355829.0
2017-02-22 17:00:00	QQQ	ETF	130.5	130.53	130.49	130.49	5597.0
2017-02-22 18:00:00	QQQ	ETF	130.5	130.52	130.45	130.5	6910.0
2017-02-22 19:00:00	QQQ	ETF	130.47	130.49	130.41	130.41	5417.0
2017-02-22 05:00:00	IWM	ETF	139.88	139.88	139.88	139.88	2500.0
2017-02-22 06:00:00	IWM	ETF	139.86	139.86	139.56	139.56	21923.0
2017-02-22 07:00:00	IWM	ETF	139.65	139.66	139.59	139.62	7512.0
2017-02-22 08:00:00	IWM	ETF	139.65	139.93	139.65	139.88	55515.0
2017-02-22 09:00:00	IWM	ETF	139.88	140.02	139.55	139.715	1542287.0
2017-02-22 10:00:00	IWM	ETF	139.73	140.02	139.67	139.79	2127026.0
2017-02-22 11:00:00	IWM	ETF	139.79	139.81	139.36	139.36	2130692.0
2017-02-22 12:00:00	IWM	ETF	139.35	139.635	139.2901	139.63	1162768.0
2017-02-22 13:00:00	IWM	ETF	139.63	139.79	139.591	139.6454	707252.0
2017-02-22 14:00:00	IWM	ETF	139.64	139.73	139.25	139.31	1246355.0
2017-02-22 15:00:00	IWM	ETF	139.31	139.64	139.25	139.6	2391855.0
2017-02-22 16:00:00	IWM	ETF	139.58	139.68	139.54	139.66	474422.0
2017-02-22 17:00:00	IWM	ETF	139.59	139.66	139.57	139.6	2621.0
2017-02-22 18:00:00	IWM	ETF	139.6	139.61	139.57	139.57	4459.0
2017-02-22 19:00:00	IWM	ETF	139.57	139.57	139.5	139.5	5378.0
2017-02-22 08:00:00	DIA	ETF	206.75	206.81	206.73	206.8	700.0
2017-02-22 09:00:00	DIA	ETF	206.69	207.01	206.64	206.96	299119.0
2017-02-22 10:00:00	DIA	ETF	206.99	207.4	206.93	207.22	403089.0

> showing 50 of 8,986 rows — these rows as CSV

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