PREVIEW / etf_1hour / 2015-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-11.parquet
  size:    256 KB
  rows:    8,157

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
2015-12-11 04:00:00	SPY	ETF	205.5	205.84	205.27	205.75	20598.0
2015-12-11 05:00:00	SPY	ETF	205.8	205.82	204.18	204.48	100331.0
2015-12-11 06:00:00	SPY	ETF	204.36	204.6	204.0	204.22	130631.0
2015-12-11 07:00:00	SPY	ETF	204.27	204.52	203.65	203.79	958474.0
2015-12-11 08:00:00	SPY	ETF	203.8	205.82	203.7	204.27	1731321.0
2015-12-11 09:00:00	SPY	ETF	204.28	204.32	202.75	203.019	28689811.0
2015-12-11 10:00:00	SPY	ETF	203.0	204.14	202.83	203.069	33429473.0
2015-12-11 11:00:00	SPY	ETF	203.05	203.55	202.63	202.825	18618257.0
2015-12-11 12:00:00	SPY	ETF	202.84	202.93	202.0	202.43	20934683.0
2015-12-11 13:00:00	SPY	ETF	202.44	202.89	202.15	202.5326	15101366.0
2015-12-11 14:00:00	SPY	ETF	202.53	203.11	202.46	202.46	18655859.0
2015-12-11 15:00:00	SPY	ETF	202.47	203.3002	201.51	201.85	52958294.0
2015-12-11 16:00:00	SPY	ETF	201.86	202.09	201.27	201.5	15541053.0
2015-12-11 17:00:00	SPY	ETF	201.57	201.8926	201.32	201.4	2440680.0
2015-12-11 18:00:00	SPY	ETF	201.39	201.42	201.21	201.32	110069.0
2015-12-11 19:00:00	SPY	ETF	201.32	201.37	201.2	201.22	36689.0
2015-12-11 04:00:00	QQQ	ETF	113.26	113.3	113.22	113.22	8050.0
2015-12-11 05:00:00	QQQ	ETF	113.35	113.35	112.6	112.6	30100.0
2015-12-11 06:00:00	QQQ	ETF	112.72	112.73	112.36	112.57	46100.0
2015-12-11 07:00:00	QQQ	ETF	112.63	112.73	112.22	112.22	68078.0
2015-12-11 08:00:00	QQQ	ETF	112.26	113.5	112.21	112.57	432229.0
2015-12-11 09:00:00	QQQ	ETF	112.57	112.57	111.7005	111.88	7820571.0
2015-12-11 10:00:00	QQQ	ETF	111.89	112.6	111.65	111.74	8401044.0
2015-12-11 11:00:00	QQQ	ETF	111.75	111.93	111.39	111.42	5655815.0
2015-12-11 12:00:00	QQQ	ETF	111.43	111.5	110.9184	111.21	6800135.0
2015-12-11 13:00:00	QQQ	ETF	111.21	111.52	111.09	111.4	3848328.0
2015-12-11 14:00:00	QQQ	ETF	111.39	111.68	111.25	111.255	4187843.0
2015-12-11 15:00:00	QQQ	ETF	111.2575	113.3968	110.72	110.81	13510528.0
2015-12-11 16:00:00	QQQ	ETF	110.8	110.99	110.67	110.83	1224507.0
2015-12-11 17:00:00	QQQ	ETF	110.84	110.84	110.69	110.69	459065.0
2015-12-11 18:00:00	QQQ	ETF	110.69	110.69	110.6	110.67	8346.0
2015-12-11 19:00:00	QQQ	ETF	110.67	110.68	110.6	110.6	6681.0
2015-12-11 05:00:00	IWM	ETF	113.9	113.9	113.54	113.54	22200.0
2015-12-11 06:00:00	IWM	ETF	113.47	113.47	113.09	113.09	8100.0
2015-12-11 07:00:00	IWM	ETF	113.5	113.5	113.12	113.15	69719.0
2015-12-11 08:00:00	IWM	ETF	113.16	113.54	113.16	113.45	214292.0
2015-12-11 09:00:00	IWM	ETF	113.45	113.45	112.75	112.87	4536913.0
2015-12-11 10:00:00	IWM	ETF	112.88	113.32	112.65	112.67	8421376.0
2015-12-11 11:00:00	IWM	ETF	112.67	112.98	112.51	112.62	4561174.0
2015-12-11 12:00:00	IWM	ETF	112.63	112.695	111.84	112.06	7628690.0
2015-12-11 13:00:00	IWM	ETF	112.07	112.43	111.76	112.175	4932827.0
2015-12-11 14:00:00	IWM	ETF	112.17	112.58	112.15	112.17	4395920.0
2015-12-11 15:00:00	IWM	ETF	112.17	112.22	111.53	111.88	11424824.0
2015-12-11 16:00:00	IWM	ETF	111.89	112.11	111.67	111.79	1841492.0
2015-12-11 17:00:00	IWM	ETF	111.8	111.94	111.66	111.94	253663.0
2015-12-11 18:00:00	IWM	ETF	111.65	111.66	111.5	111.5	4669.0
2015-12-11 19:00:00	IWM	ETF	111.62	111.67	111.62	111.67	560.0
2015-12-11 05:00:00	DIA	ETF	175.12	175.12	175.06	175.06	800.0
2015-12-11 06:00:00	DIA	ETF	174.37	174.4	174.37	174.4	400.0
2015-12-11 07:00:00	DIA	ETF	174.54	174.54	173.75	173.85	2800.0

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

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