PREVIEW / etf_1hour / 2014-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-19.parquet
  size:    239 KB
  rows:    7,595

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
2014-12-19 04:00:00	SPY	ETF	206.69	206.91	206.49	206.85	40146.0
2014-12-19 05:00:00	SPY	ETF	206.9	206.9	206.42	206.56	139185.0
2014-12-19 06:00:00	SPY	ETF	206.58	206.72	206.25	206.52	103924.0
2014-12-19 07:00:00	SPY	ETF	206.48	206.79	206.41	206.69	387043.0
2014-12-19 08:00:00	SPY	ETF	206.91	206.91	205.91	206.13	3693831.0
2014-12-19 09:00:00	SPY	ETF	206.12	206.65	205.62	206.23	37342313.0
2014-12-19 10:00:00	SPY	ETF	206.23	206.65	205.95	206.31	29070796.0
2014-12-19 11:00:00	SPY	ETF	206.3	206.4346	206.05	206.11	29541731.0
2014-12-19 12:00:00	SPY	ETF	206.11	206.18	205.7	205.96	18790493.0
2014-12-19 13:00:00	SPY	ETF	205.95	206.26	205.86	206.23	12076304.0
2014-12-19 14:00:00	SPY	ETF	206.225	207.16	206.17	207.13	22359375.0
2014-12-19 15:00:00	SPY	ETF	207.13	207.33	206.52	206.53	50571795.0
2014-12-19 16:00:00	SPY	ETF	206.54	206.59	205.6327	206.39	18101687.0
2014-12-19 17:00:00	SPY	ETF	206.576	206.576	206.3	206.31	11773444.0
2014-12-19 18:00:00	SPY	ETF	206.32	206.43	206.2	206.38	106396.0
2014-12-19 19:00:00	SPY	ETF	206.39	206.43	206.35	206.42	27275.0
2014-12-19 04:00:00	QQQ	ETF	104.33	104.55	104.33	104.55	7402.0
2014-12-19 05:00:00	QQQ	ETF	104.45	104.45	104.29	104.29	4100.0
2014-12-19 06:00:00	QQQ	ETF	104.37	104.37	104.2	104.33	149450.0
2014-12-19 07:00:00	QQQ	ETF	104.28	104.36	104.27	104.34	44100.0
2014-12-19 08:00:00	QQQ	ETF	104.36	104.38	104.07	104.13	213989.0
2014-12-19 09:00:00	QQQ	ETF	104.1	104.23	103.71	104.1099	9910093.0
2014-12-19 10:00:00	QQQ	ETF	104.11	104.415	103.99	104.33	6959232.0
2014-12-19 11:00:00	QQQ	ETF	104.32	104.48	104.22	104.25	4392627.0
2014-12-19 12:00:00	QQQ	ETF	104.25	104.33	104.01	104.21	4172688.0
2014-12-19 13:00:00	QQQ	ETF	104.21	104.32	104.11	104.226	3927190.0
2014-12-19 14:00:00	QQQ	ETF	104.23	104.65	104.225	104.63	4174663.0
2014-12-19 15:00:00	QQQ	ETF	104.6351	104.74	104.23	104.23	9662599.0
2014-12-19 16:00:00	QQQ	ETF	104.24	104.3624	104.16	104.18	1779244.0
2014-12-19 17:00:00	QQQ	ETF	104.17	104.32	104.13	104.22	214798.0
2014-12-19 18:00:00	QQQ	ETF	104.21	104.26	104.19	104.26	4879.0
2014-12-19 19:00:00	QQQ	ETF	104.28	104.3	104.17	104.17	2931.0
2014-12-19 06:00:00	IWM	ETF	119.05	119.05	118.97	118.97	200.0
2014-12-19 07:00:00	IWM	ETF	119.11	119.11	119.09	119.09	3912.0
2014-12-19 08:00:00	IWM	ETF	119.09	119.22	118.63	118.77	385580.0
2014-12-19 09:00:00	IWM	ETF	118.75	118.9	118.14	118.815	5149041.0
2014-12-19 10:00:00	IWM	ETF	118.83	118.9	118.2	118.53	4877735.0
2014-12-19 11:00:00	IWM	ETF	118.52	118.74	118.36	118.68	3134472.0
2014-12-19 12:00:00	IWM	ETF	118.67	118.8169	118.39	118.68	3003302.0
2014-12-19 13:00:00	IWM	ETF	118.68	118.95	118.61	118.901	3519593.0
2014-12-19 14:00:00	IWM	ETF	118.9	119.29	118.865	119.25	3715130.0
2014-12-19 15:00:00	IWM	ETF	119.25	119.48	118.91	118.93	8306574.0
2014-12-19 16:00:00	IWM	ETF	118.93	119.16	118.82	118.98	1313079.0
2014-12-19 17:00:00	IWM	ETF	119.0	119.0	118.9	118.98	671616.0
2014-12-19 18:00:00	IWM	ETF	118.96	118.96	118.9	118.95	1000.0
2014-12-19 04:00:00	DIA	ETF	178.12	178.4	178.12	178.4	200.0
2014-12-19 05:00:00	DIA	ETF	177.97	178.0	177.97	178.0	5500.0
2014-12-19 06:00:00	DIA	ETF	178.1	178.2	177.79	177.8	113498.0
2014-12-19 07:00:00	DIA	ETF	178.24	178.24	178.23	178.23	9300.0
2014-12-19 08:00:00	DIA	ETF	178.15	178.24	177.75	177.85	22143.0

> showing 50 of 7,595 rows — these rows as CSV

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