PREVIEW / etf_1hour / 2013-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-10.parquet
  size:    214 KB
  rows:    6,761

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-10 04:00:00	SPY	ETF	168.06	168.32	168.06	168.27	28222.0
2013-09-10 05:00:00	SPY	ETF	168.26	168.33	168.18	168.33	40050.0
2013-09-10 06:00:00	SPY	ETF	168.33	168.41	168.3	168.34	21150.0
2013-09-10 07:00:00	SPY	ETF	168.3	168.7	168.3	168.6	680949.0
2013-09-10 08:00:00	SPY	ETF	168.57	168.64	168.38	168.5	1297089.0
2013-09-10 09:00:00	SPY	ETF	168.49	168.69	168.26	168.54	12985400.0
2013-09-10 10:00:00	SPY	ETF	168.55	168.88	168.48	168.73	17082445.0
2013-09-10 11:00:00	SPY	ETF	168.735	168.8	168.27	168.45	14219594.0
2013-09-10 12:00:00	SPY	ETF	168.445	168.69	168.43	168.66	7099708.0
2013-09-10 13:00:00	SPY	ETF	168.655	168.78	168.49	168.7	8942860.0
2013-09-10 14:00:00	SPY	ETF	168.7	168.77	168.51	168.73	9329611.0
2013-09-10 15:00:00	SPY	ETF	168.725	168.9	168.62	168.89	21042572.0
2013-09-10 16:00:00	SPY	ETF	168.88	168.88	168.5475	168.82	3543448.0
2013-09-10 17:00:00	SPY	ETF	168.83	168.85	167.6413	168.77	2946022.0
2013-09-10 18:00:00	SPY	ETF	168.78	168.84	168.75	168.76	377323.0
2013-09-10 19:00:00	SPY	ETF	168.75	168.75	168.68	168.7	169557.0
2013-09-10 04:00:00	QQQ	ETF	78.05	78.18	78.05	78.14	18765.0
2013-09-10 05:00:00	QQQ	ETF	78.12	78.17	78.1	78.17	5000.0
2013-09-10 06:00:00	QQQ	ETF	78.17	78.2	78.17	78.2	14460.0
2013-09-10 07:00:00	QQQ	ETF	78.18	78.31	78.15	78.27	118985.0
2013-09-10 08:00:00	QQQ	ETF	78.26	78.28	78.18	78.2	203536.0
2013-09-10 09:00:00	QQQ	ETF	78.2	78.29	78.07	78.16	5740194.0
2013-09-10 10:00:00	QQQ	ETF	78.16	78.3099	78.07	78.19	4620016.0
2013-09-10 11:00:00	QQQ	ETF	78.2	78.32	78.109	78.16	2315507.0
2013-09-10 12:00:00	QQQ	ETF	78.16	78.19	78.02	78.18	1761913.0
2013-09-10 13:00:00	QQQ	ETF	78.17	78.275	78.06	78.232	2391069.0
2013-09-10 14:00:00	QQQ	ETF	78.2399	78.281	77.92	78.15	2900997.0
2013-09-10 15:00:00	QQQ	ETF	78.15	78.25	78.06	78.209	3418479.0
2013-09-10 16:00:00	QQQ	ETF	78.2	78.24	78.16	78.2	622512.0
2013-09-10 17:00:00	QQQ	ETF	78.2	78.23	77.8357	78.23	3167051.0
2013-09-10 18:00:00	QQQ	ETF	78.21	78.21	78.15	78.16	8862.0
2013-09-10 19:00:00	QQQ	ETF	78.16	78.16	78.12	78.13	5750.0
2013-09-10 07:00:00	IWM	ETF	104.45	104.76	104.45	104.65	183200.0
2013-09-10 08:00:00	IWM	ETF	104.65	104.75	104.51	104.52	319754.0
2013-09-10 09:00:00	IWM	ETF	104.52	104.69	103.97	104.5	4504824.0
2013-09-10 10:00:00	IWM	ETF	104.52	104.84	104.47	104.7	4606495.0
2013-09-10 11:00:00	IWM	ETF	104.7	104.78	104.34	104.48	3194165.0
2013-09-10 12:00:00	IWM	ETF	104.48	104.68	104.42	104.65	1216393.0
2013-09-10 13:00:00	IWM	ETF	104.66	104.78	104.49	104.715	2214600.0
2013-09-10 14:00:00	IWM	ETF	104.73	104.8	104.61	104.74	2530167.0
2013-09-10 15:00:00	IWM	ETF	104.745	104.98	104.63	104.96	4372347.0
2013-09-10 16:00:00	IWM	ETF	104.96	104.98	104.84	104.94	1155394.0
2013-09-10 17:00:00	IWM	ETF	104.94	104.95	104.5763	104.5763	160118.0
2013-09-10 18:00:00	IWM	ETF	105.0	105.0	104.97	104.97	9700.0
2013-09-10 04:00:00	DIA	ETF	151.0	151.11	151.0	151.11	5375.0
2013-09-10 07:00:00	DIA	ETF	151.1	151.3	151.09	151.3	11450.0
2013-09-10 08:00:00	DIA	ETF	151.17	151.28	151.04	151.11	61325.0
2013-09-10 09:00:00	DIA	ETF	151.15	151.52	151.1	151.3	1147205.0
2013-09-10 10:00:00	DIA	ETF	151.3	151.71	151.3	151.622	1212346.0
2013-09-10 11:00:00	DIA	ETF	151.63	151.66	151.22	151.38	729465.0

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

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