PREVIEW / etf_1hour / 2013-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-17.parquet
  size:    204 KB
  rows:    6,442

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
2013-09-17 04:00:00	SPY	ETF	170.1	170.24	170.06	170.21	11079.0
2013-09-17 05:00:00	SPY	ETF	170.24	170.24	170.05	170.15	33048.0
2013-09-17 06:00:00	SPY	ETF	170.18	170.21	170.07	170.2	54287.0
2013-09-17 07:00:00	SPY	ETF	170.17	170.36	170.1	170.36	126024.0
2013-09-17 08:00:00	SPY	ETF	170.34	170.51	170.2	170.43	351195.0
2013-09-17 09:00:00	SPY	ETF	170.43	170.89	170.42	170.76	11870495.0
2013-09-17 10:00:00	SPY	ETF	170.755	171.0	170.72	170.86	12813527.0
2013-09-17 11:00:00	SPY	ETF	170.86	170.96	170.8	170.86	8489652.0
2013-09-17 12:00:00	SPY	ETF	170.86	171.06	170.81	171.03	6728881.0
2013-09-17 13:00:00	SPY	ETF	171.03	171.08	170.93	171.045	6394598.0
2013-09-17 14:00:00	SPY	ETF	171.045	171.11	170.95	171.031	6925995.0
2013-09-17 15:00:00	SPY	ETF	171.03	171.07	170.89	171.04	16231196.0
2013-09-17 16:00:00	SPY	ETF	171.05	171.1935	170.297	171.17	10164056.0
2013-09-17 17:00:00	SPY	ETF	171.15	171.22	170.9383	171.18	468485.0
2013-09-17 18:00:00	SPY	ETF	171.18	171.18	171.08	171.12	221114.0
2013-09-17 19:00:00	SPY	ETF	171.12	171.13	171.11	171.13	43272.0
2013-09-17 05:00:00	QQQ	ETF	77.79	77.79	77.74	77.76	13200.0
2013-09-17 06:00:00	QQQ	ETF	77.74	77.74	77.72	77.74	2400.0
2013-09-17 07:00:00	QQQ	ETF	77.72	77.82	77.72	77.82	27145.0
2013-09-17 08:00:00	QQQ	ETF	77.82	77.92	77.81	77.91	81385.0
2013-09-17 09:00:00	QQQ	ETF	77.92	78.2	77.92	78.13	3242290.0
2013-09-17 10:00:00	QQQ	ETF	78.121	78.31	78.105	78.309	3416186.0
2013-09-17 11:00:00	QQQ	ETF	78.31	78.4	78.248	78.3	2135481.0
2013-09-17 12:00:00	QQQ	ETF	78.3	78.42	78.3	78.41	1348679.0
2013-09-17 13:00:00	QQQ	ETF	78.41	78.45	78.3201	78.43	1286130.0
2013-09-17 14:00:00	QQQ	ETF	78.43	78.47	78.36	78.39	1229067.0
2013-09-17 15:00:00	QQQ	ETF	78.39	78.45	78.31	78.37	5291444.0
2013-09-17 16:00:00	QQQ	ETF	78.37	78.4	77.8128	78.39	5166826.0
2013-09-17 17:00:00	QQQ	ETF	78.42	78.42	78.3418	78.42	297503.0
2013-09-17 18:00:00	QQQ	ETF	78.42	78.44	78.38	78.39	2100.0
2013-09-17 19:00:00	QQQ	ETF	78.42	78.44	78.41	78.41	5850.0
2013-09-17 07:00:00	IWM	ETF	104.99	104.99	104.87	104.95	86000.0
2013-09-17 08:00:00	IWM	ETF	104.98	105.09	104.94	105.04	77728.0
2013-09-17 09:00:00	IWM	ETF	105.1	105.33	105.02	105.18	2015214.0
2013-09-17 10:00:00	IWM	ETF	105.18	105.64	105.18	105.57	3268860.0
2013-09-17 11:00:00	IWM	ETF	105.58	105.62	105.41	105.5	1551905.0
2013-09-17 12:00:00	IWM	ETF	105.51	105.62	105.46	105.595	1285697.0
2013-09-17 13:00:00	IWM	ETF	105.6	105.75	105.55	105.702	1502393.0
2013-09-17 14:00:00	IWM	ETF	105.71	105.93	105.68	105.88	2643192.0
2013-09-17 15:00:00	IWM	ETF	105.88	106.06	105.87	106.05	7812183.0
2013-09-17 16:00:00	IWM	ETF	106.06	106.26	106.0	106.26	4109558.0
2013-09-17 17:00:00	IWM	ETF	106.26	106.27	105.6854	106.25	79028.0
2013-09-17 18:00:00	IWM	ETF	106.21	106.21	106.19	106.21	2596.0
2013-09-17 19:00:00	IWM	ETF	106.18	106.21	106.18	106.21	3100.0
2013-09-17 08:00:00	DIA	ETF	154.99	155.09	154.99	155.05	3700.0
2013-09-17 09:00:00	DIA	ETF	155.1	155.45	154.98	155.37	686370.0
2013-09-17 10:00:00	DIA	ETF	155.361	155.48	155.26	155.27	597283.0
2013-09-17 11:00:00	DIA	ETF	155.26	155.3645	155.24	155.32	355976.0
2013-09-17 12:00:00	DIA	ETF	155.33	155.46	155.24	155.4396	349281.0
2013-09-17 13:00:00	DIA	ETF	155.44	155.51	155.31	155.34	302030.0

> showing 50 of 6,442 rows — these rows as CSV

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