PREVIEW / etf_1hour / 2013-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-29.parquet
  size:    203 KB
  rows:    6,302

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-08-29 04:00:00	SPY	ETF	163.79	164.32	163.79	164.19	15450.0
2013-08-29 05:00:00	SPY	ETF	164.22	164.26	164.0	164.02	98690.0
2013-08-29 06:00:00	SPY	ETF	164.02	164.05	163.85	164.03	96400.0
2013-08-29 07:00:00	SPY	ETF	164.02	164.43	164.01	164.36	399508.0
2013-08-29 08:00:00	SPY	ETF	164.34	164.43	163.96	164.07	1422830.0
2013-08-29 09:00:00	SPY	ETF	164.06	164.42	163.37	164.22	18398240.0
2013-08-29 10:00:00	SPY	ETF	164.22	164.97	164.19	164.84	17771113.0
2013-08-29 11:00:00	SPY	ETF	164.841	165.04	164.765	165.0	9806211.0
2013-08-29 12:00:00	SPY	ETF	165.0	165.03	164.62	164.77	6763854.0
2013-08-29 13:00:00	SPY	ETF	164.775	164.925	164.315	164.41	9820548.0
2013-08-29 14:00:00	SPY	ETF	164.41	164.73	164.36	164.655	7421347.0
2013-08-29 15:00:00	SPY	ETF	164.66	164.68	164.02	164.17	21473992.0
2013-08-29 16:00:00	SPY	ETF	164.17	164.5	163.8794	164.37	20892289.0
2013-08-29 17:00:00	SPY	ETF	164.6689	164.6689	164.38	164.48	2455946.0
2013-08-29 18:00:00	SPY	ETF	164.46	164.5	164.37	164.37	99825.0
2013-08-29 19:00:00	SPY	ETF	164.39	164.47	164.39	164.47	72986.0
2013-08-29 04:00:00	QQQ	ETF	75.62	75.69	75.61	75.65	27300.0
2013-08-29 05:00:00	QQQ	ETF	75.67	75.67	75.57	75.57	10100.0
2013-08-29 06:00:00	QQQ	ETF	75.55	75.58	75.49	75.58	16200.0
2013-08-29 07:00:00	QQQ	ETF	75.59	75.73	75.59	75.71	42628.0
2013-08-29 08:00:00	QQQ	ETF	75.69	75.73	75.55	75.6	134990.0
2013-08-29 09:00:00	QQQ	ETF	75.6	75.94	75.3	75.85	5080691.0
2013-08-29 10:00:00	QQQ	ETF	75.86	76.29	75.86	76.18	4695933.0
2013-08-29 11:00:00	QQQ	ETF	76.19	76.33	76.171	76.3299	3543224.0
2013-08-29 12:00:00	QQQ	ETF	76.33	76.34	76.12	76.2	2036495.0
2013-08-29 13:00:00	QQQ	ETF	76.21	76.28	75.9607	76.03	1606401.0
2013-08-29 14:00:00	QQQ	ETF	76.02	76.22	76.0	76.18	1717871.0
2013-08-29 15:00:00	QQQ	ETF	76.18	76.199	75.9	75.94	5404984.0
2013-08-29 16:00:00	QQQ	ETF	75.94	75.9798	75.4291	75.96	2226431.0
2013-08-29 17:00:00	QQQ	ETF	75.97	75.98	75.94	75.98	15200.0
2013-08-29 18:00:00	QQQ	ETF	75.98	76.0	75.96	75.98	48300.0
2013-08-29 19:00:00	QQQ	ETF	75.97	75.99	75.97	75.98	146543.0
2013-08-29 04:00:00	IWM	ETF	101.11	101.11	101.11	101.11	200.0
2013-08-29 07:00:00	IWM	ETF	101.17	101.48	101.17	101.44	154221.0
2013-08-29 08:00:00	IWM	ETF	101.2	101.47	101.11	101.16	164657.0
2013-08-29 09:00:00	IWM	ETF	101.18	101.68	100.71	101.5	4189009.0
2013-08-29 10:00:00	IWM	ETF	101.49	102.25	101.42	102.11	4889314.0
2013-08-29 11:00:00	IWM	ETF	102.12	102.33	102.025	102.25	2674525.0
2013-08-29 12:00:00	IWM	ETF	102.26	102.36	101.99	102.05	2416701.0
2013-08-29 13:00:00	IWM	ETF	102.05	102.19	101.76	101.88	2619030.0
2013-08-29 14:00:00	IWM	ETF	101.88	102.08	101.81	102.01	2288004.0
2013-08-29 15:00:00	IWM	ETF	102.01	102.06	101.64	102.0	4806021.0
2013-08-29 16:00:00	IWM	ETF	101.99	102.03	101.8	101.93	769952.0
2013-08-29 17:00:00	IWM	ETF	101.91	101.91	101.91	101.91	700.0
2013-08-29 18:00:00	IWM	ETF	101.97	101.99	101.96	101.96	3775.0
2013-08-29 07:00:00	DIA	ETF	148.51	148.51	148.51	148.51	500.0
2013-08-29 08:00:00	DIA	ETF	148.52	148.54	148.37	148.37	2300.0
2013-08-29 09:00:00	DIA	ETF	148.25	148.49	147.81	148.3435	700997.0
2013-08-29 10:00:00	DIA	ETF	148.35	148.92	148.24	148.82	1068003.0
2013-08-29 11:00:00	DIA	ETF	148.8201	148.98	148.77	148.9263	584726.0

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

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