PREVIEW / etf_1hour / 2014-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-09.parquet
  size:    234 KB
  rows:    7,392

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-10-09 04:00:00	SPY	ETF	197.04	197.45	197.04	197.21	9969.0
2014-10-09 05:00:00	SPY	ETF	197.13	197.3	197.13	197.21	53545.0
2014-10-09 06:00:00	SPY	ETF	197.2	197.28	196.85	196.87	204188.0
2014-10-09 07:00:00	SPY	ETF	196.84	196.9	195.9	196.05	1654986.0
2014-10-09 08:00:00	SPY	ETF	196.03	196.84	195.95	196.35	2284431.0
2014-10-09 09:00:00	SPY	ETF	196.34	196.6	195.49	195.72	18625799.0
2014-10-09 10:00:00	SPY	ETF	195.7	196.11	195.06	195.585	22546827.0
2014-10-09 11:00:00	SPY	ETF	195.58	195.84	193.83	194.2	26806927.0
2014-10-09 12:00:00	SPY	ETF	194.2	194.4	193.23	193.81	24595247.0
2014-10-09 13:00:00	SPY	ETF	193.82	194.13	192.82	193.43	27595171.0
2014-10-09 14:00:00	SPY	ETF	193.42	193.42	192.58	192.82	26177982.0
2014-10-09 15:00:00	SPY	ETF	192.82	193.78	192.61	192.68	44785743.0
2014-10-09 16:00:00	SPY	ETF	192.67	193.36	192.1	192.39	10839703.0
2014-10-09 17:00:00	SPY	ETF	192.37	192.44	192.21	192.39	331054.0
2014-10-09 18:00:00	SPY	ETF	192.31	192.51	192.25	192.25	377159.0
2014-10-09 19:00:00	SPY	ETF	192.3	192.45	192.17	192.38	328930.0
2014-10-09 04:00:00	QQQ	ETF	98.5	98.88	98.5	98.8	2150.0
2014-10-09 05:00:00	QQQ	ETF	98.81	98.83	98.78	98.82	18300.0
2014-10-09 06:00:00	QQQ	ETF	98.79	98.81	98.65	98.67	49970.0
2014-10-09 07:00:00	QQQ	ETF	98.65	98.65	98.11	98.21	203650.0
2014-10-09 08:00:00	QQQ	ETF	98.53	98.53	98.15	98.4	380827.0
2014-10-09 09:00:00	QQQ	ETF	98.41	98.57	98.06	98.199	5357011.0
2014-10-09 10:00:00	QQQ	ETF	98.2	98.37	97.87	98.3	5945126.0
2014-10-09 11:00:00	QQQ	ETF	98.3	98.55	97.4701	97.64	8296911.0
2014-10-09 12:00:00	QQQ	ETF	97.64	97.75	97.06	97.295	7878867.0
2014-10-09 13:00:00	QQQ	ETF	97.3	97.47	96.8	97.07	8203739.0
2014-10-09 14:00:00	QQQ	ETF	97.06	97.17	96.71	96.89	9660227.0
2014-10-09 15:00:00	QQQ	ETF	96.88	97.38	96.78	96.85	11552030.0
2014-10-09 16:00:00	QQQ	ETF	96.84	97.18	96.47	96.6	1349782.0
2014-10-09 17:00:00	QQQ	ETF	96.59	98.5715	96.5	96.55	622480.0
2014-10-09 18:00:00	QQQ	ETF	96.54	96.65	96.49	96.49	240790.0
2014-10-09 19:00:00	QQQ	ETF	96.5	96.57	96.35	96.51	270141.0
2014-10-09 04:00:00	IWM	ETF	109.5	109.66	109.5	109.66	12649.0
2014-10-09 06:00:00	IWM	ETF	109.7	109.7	109.5	109.55	1100.0
2014-10-09 07:00:00	IWM	ETF	109.26	109.38	108.88	109.25	330649.0
2014-10-09 08:00:00	IWM	ETF	109.25	109.32	108.84	108.99	721439.0
2014-10-09 09:00:00	IWM	ETF	108.99	109.02	107.5	107.71	6246942.0
2014-10-09 10:00:00	IWM	ETF	107.705	107.93	107.37	107.87	6873403.0
2014-10-09 11:00:00	IWM	ETF	107.87	108.27	106.58	106.77	8715543.0
2014-10-09 12:00:00	IWM	ETF	106.77	106.83	106.18	106.6	5530029.0
2014-10-09 13:00:00	IWM	ETF	106.61	107.14	106.205	106.8501	6446512.0
2014-10-09 14:00:00	IWM	ETF	106.85	106.85	106.23	106.39	5351484.0
2014-10-09 15:00:00	IWM	ETF	106.39	106.84	106.01	106.035	10581146.0
2014-10-09 16:00:00	IWM	ETF	106.03	107.9443	105.7	105.81	1726242.0
2014-10-09 17:00:00	IWM	ETF	105.82	105.82	105.74	105.82	12616.0
2014-10-09 18:00:00	IWM	ETF	105.95	106.0	105.95	106.0	1563.0
2014-10-09 19:00:00	IWM	ETF	105.8	105.84	105.76	105.8	2146.0
2014-10-09 05:00:00	DIA	ETF	169.9	169.9	169.9	169.9	100.0
2014-10-09 07:00:00	DIA	ETF	169.5	169.5	169.0	169.0	600.0
2014-10-09 08:00:00	DIA	ETF	169.25	169.25	169.25	169.25	1400.0

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

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