PREVIEW / etf_1hour / 2016-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-04.parquet
  size:    266 KB
  rows:    8,573

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
2016-01-04 04:00:00	SPY	ETF	201.18	201.39	200.83	200.84	41746.0
2016-01-04 05:00:00	SPY	ETF	200.87	201.13	200.75	201.11	132855.0
2016-01-04 06:00:00	SPY	ETF	201.08	201.12	200.26	200.4	268709.0
2016-01-04 07:00:00	SPY	ETF	200.29	200.65	199.98	200.5	969105.0
2016-01-04 08:00:00	SPY	ETF	200.5	200.86	200.07	200.34	1506458.0
2016-01-04 09:00:00	SPY	ETF	200.35	200.56	199.59	200.22	26612179.0
2016-01-04 10:00:00	SPY	ETF	200.22	200.32	199.11	199.14	35440839.0
2016-01-04 11:00:00	SPY	ETF	199.15	199.59	198.59	199.38	34928599.0
2016-01-04 12:00:00	SPY	ETF	199.39	200.0	199.14	199.7901	21539358.0
2016-01-04 13:00:00	SPY	ETF	199.8	200.28	199.69	199.91	20689251.0
2016-01-04 14:00:00	SPY	ETF	199.91	200.16	199.32	199.6	19237412.0
2016-01-04 15:00:00	SPY	ETF	199.6	201.03	198.99	200.99	44499597.0
2016-01-04 16:00:00	SPY	ETF	200.99	201.51	200.89	201.45	12410266.0
2016-01-04 17:00:00	SPY	ETF	201.46	203.89	201.01	201.46	1291647.0
2016-01-04 18:00:00	SPY	ETF	201.46	201.76	201.43	201.7	328871.0
2016-01-04 19:00:00	SPY	ETF	201.73	201.83	201.61	201.69	468344.0
2016-01-04 04:00:00	QQQ	ETF	110.24	110.26	109.99	110.0	18007.0
2016-01-04 05:00:00	QQQ	ETF	110.07	110.11	109.95	110.11	2200.0
2016-01-04 06:00:00	QQQ	ETF	110.09	110.1	109.6	109.6	12590.0
2016-01-04 07:00:00	QQQ	ETF	109.58	109.69	109.41	109.66	83906.0
2016-01-04 08:00:00	QQQ	ETF	109.66	109.8	109.46	109.46	155215.0
2016-01-04 09:00:00	QQQ	ETF	109.47	109.52	108.83	109.11	8399771.0
2016-01-04 10:00:00	QQQ	ETF	109.11	109.11	108.41	108.45	8083021.0
2016-01-04 11:00:00	QQQ	ETF	108.45	108.8899	108.12	108.76	5708763.0
2016-01-04 12:00:00	QQQ	ETF	108.74	109.0625	108.54	108.98	2992519.0
2016-01-04 13:00:00	QQQ	ETF	108.99	109.2185	108.91	109.0064	3464331.0
2016-01-04 14:00:00	QQQ	ETF	109.0	109.17	108.56	108.75	3081470.0
2016-01-04 15:00:00	QQQ	ETF	108.76	109.6	108.29	109.58	8985299.0
2016-01-04 16:00:00	QQQ	ETF	109.57	109.98	109.5	109.95	1869218.0
2016-01-04 17:00:00	QQQ	ETF	109.9	109.96	109.88	109.94	39691.0
2016-01-04 18:00:00	QQQ	ETF	109.94	110.08	109.82	110.03	29976.0
2016-01-04 19:00:00	QQQ	ETF	110.08	110.08	109.96	109.96	14707.0
2016-01-04 04:00:00	IWM	ETF	111.29	111.29	110.92	110.92	4039.0
2016-01-04 05:00:00	IWM	ETF	110.92	111.08	110.9	110.98	11298.0
2016-01-04 06:00:00	IWM	ETF	111.0	111.02	110.58	110.66	17723.0
2016-01-04 07:00:00	IWM	ETF	110.63	110.75	110.5	110.7	61196.0
2016-01-04 08:00:00	IWM	ETF	110.7	112.51	110.58	110.62	334506.0
2016-01-04 09:00:00	IWM	ETF	110.61	110.83	110.23	110.495	8285178.0
2016-01-04 10:00:00	IWM	ETF	110.49	110.53	109.47	109.55	8106276.0
2016-01-04 11:00:00	IWM	ETF	109.55	109.93	109.08	109.86	7230415.0
2016-01-04 12:00:00	IWM	ETF	109.85	110.04	109.3	109.95	4795627.0
2016-01-04 13:00:00	IWM	ETF	109.95	110.27	109.9	110.036	4665236.0
2016-01-04 14:00:00	IWM	ETF	110.03	110.15	109.73	110.01	3228656.0
2016-01-04 15:00:00	IWM	ETF	110.0	110.11	109.51	110.02	10279916.0
2016-01-04 16:00:00	IWM	ETF	110.02	110.34	109.2248	110.29	4103901.0
2016-01-04 17:00:00	IWM	ETF	110.29	110.41	110.25	110.25	9532.0
2016-01-04 18:00:00	IWM	ETF	110.4	110.49	110.3	110.31	1100.0
2016-01-04 19:00:00	IWM	ETF	110.31	110.45	110.26	110.3	23877.0
2016-01-04 04:00:00	DIA	ETF	172.56	172.56	171.46	171.46	300.0
2016-01-04 05:00:00	DIA	ETF	171.4	171.4	171.3	171.3	400.0

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

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