PREVIEW / etf_1hour / 2013-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-13.parquet
  size:    202 KB
  rows:    6,369

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-13 04:00:00	SPY	ETF	169.03	169.03	168.77	168.83	67800.0
2013-09-13 05:00:00	SPY	ETF	168.86	168.94	168.86	168.87	6196.0
2013-09-13 06:00:00	SPY	ETF	168.89	168.92	168.85	168.92	3660.0
2013-09-13 07:00:00	SPY	ETF	168.94	169.13	168.88	169.07	291955.0
2013-09-13 08:00:00	SPY	ETF	169.06	169.41	168.92	169.2	530132.0
2013-09-13 09:00:00	SPY	ETF	169.19	169.46	168.58	169.27	11979051.0
2013-09-13 10:00:00	SPY	ETF	169.26	169.27	168.74	169.13	12541626.0
2013-09-13 11:00:00	SPY	ETF	169.13	169.37	169.08	169.28	7112184.0
2013-09-13 12:00:00	SPY	ETF	169.29	169.4	169.16	169.19	7466557.0
2013-09-13 13:00:00	SPY	ETF	169.182	169.34	169.182	169.34	4625695.0
2013-09-13 14:00:00	SPY	ETF	169.34	169.43	169.26	169.2705	6609093.0
2013-09-13 15:00:00	SPY	ETF	169.27	169.38	169.11	169.34	12900074.0
2013-09-13 16:00:00	SPY	ETF	169.35	169.59	168.8798	169.52	7706930.0
2013-09-13 17:00:00	SPY	ETF	169.52	169.59	169.2279	169.59	544263.0
2013-09-13 18:00:00	SPY	ETF	169.52	169.57	169.48	169.5	12690.0
2013-09-13 19:00:00	SPY	ETF	169.49	169.53	169.47	169.53	14215.0
2013-09-13 04:00:00	QQQ	ETF	78.08	78.08	77.97	78.01	12300.0
2013-09-13 05:00:00	QQQ	ETF	78.03	78.07	78.03	78.05	3100.0
2013-09-13 06:00:00	QQQ	ETF	78.03	78.03	78.01	78.01	8800.0
2013-09-13 07:00:00	QQQ	ETF	78.03	78.12	78.03	78.09	9000.0
2013-09-13 08:00:00	QQQ	ETF	78.06	78.13	78.05	78.12	50155.0
2013-09-13 09:00:00	QQQ	ETF	78.12	78.145	77.97	78.03	2477510.0
2013-09-13 10:00:00	QQQ	ETF	78.03	78.049	77.64	77.84	4141259.0
2013-09-13 11:00:00	QQQ	ETF	77.84	77.98	77.8	77.935	1368563.0
2013-09-13 12:00:00	QQQ	ETF	77.94	78.07	77.87	77.9301	2451047.0
2013-09-13 13:00:00	QQQ	ETF	77.94	78.05	77.94	78.05	1159717.0
2013-09-13 14:00:00	QQQ	ETF	78.05	78.08	78.01	78.03	1095789.0
2013-09-13 15:00:00	QQQ	ETF	78.02	78.08	77.96	78.05	2415406.0
2013-09-13 16:00:00	QQQ	ETF	78.06	78.13	77.836	78.11	557136.0
2013-09-13 17:00:00	QQQ	ETF	78.12	78.15	77.9517	78.15	222540.0
2013-09-13 18:00:00	QQQ	ETF	78.16	78.17	78.16	78.17	900.0
2013-09-13 19:00:00	QQQ	ETF	78.16	78.16	78.15	78.16	9045.0
2013-09-13 08:00:00	IWM	ETF	104.5	104.94	104.5	104.62	229305.0
2013-09-13 09:00:00	IWM	ETF	104.62	104.66	104.32	104.655	3449797.0
2013-09-13 10:00:00	IWM	ETF	104.65	104.66	104.1	104.55	7058006.0
2013-09-13 11:00:00	IWM	ETF	104.56	104.7	104.46	104.52	2169771.0
2013-09-13 12:00:00	IWM	ETF	104.52	104.71	104.45	104.56	2450832.0
2013-09-13 13:00:00	IWM	ETF	104.565	104.775	104.565	104.71	1189761.0
2013-09-13 14:00:00	IWM	ETF	104.715	104.8	104.68	104.77	1950662.0
2013-09-13 15:00:00	IWM	ETF	104.76	104.83	104.655	104.8	4515288.0
2013-09-13 16:00:00	IWM	ETF	104.795	104.92	104.76	104.92	3612199.0
2013-09-13 17:00:00	IWM	ETF	104.88	104.88	104.5515	104.5515	166851.0
2013-09-13 07:00:00	DIA	ETF	153.08	153.08	153.08	153.08	100.0
2013-09-13 08:00:00	DIA	ETF	153.25	153.3	153.25	153.26	1600.0
2013-09-13 09:00:00	DIA	ETF	153.32	153.8	153.24	153.58	1021296.0
2013-09-13 10:00:00	DIA	ETF	153.59	153.62	153.21	153.51	955202.0
2013-09-13 11:00:00	DIA	ETF	153.5	153.7	153.45	153.63	426481.0
2013-09-13 12:00:00	DIA	ETF	153.64	153.745	153.49	153.49	374095.0
2013-09-13 13:00:00	DIA	ETF	153.4999	153.69	153.4999	153.68	248965.0
2013-09-13 14:00:00	DIA	ETF	153.69	153.75	153.58	153.6414	376172.0

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

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