PREVIEW / etf_30min / 2013-07-24

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-24.parquet
  size:    327 KB
  rows:    10,909

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-07-24 04:00:00	SPY	ETF	169.53	169.64	169.53	169.6	14927.0
2013-07-24 04:30:00	SPY	ETF	169.59	169.7	169.59	169.7	3100.0
2013-07-24 05:00:00	SPY	ETF	169.7	169.76	169.64	169.64	23900.0
2013-07-24 05:30:00	SPY	ETF	169.62	169.63	169.48	169.52	93750.0
2013-07-24 06:00:00	SPY	ETF	169.5	169.58	169.48	169.58	51600.0
2013-07-24 06:30:00	SPY	ETF	169.6	169.75	169.6	169.71	79100.0
2013-07-24 07:00:00	SPY	ETF	169.71	169.91	169.71	169.9	209947.0
2013-07-24 07:30:00	SPY	ETF	169.89	169.94	169.84	169.86	189675.0
2013-07-24 08:00:00	SPY	ETF	169.84	169.94	169.71	169.76	254030.0
2013-07-24 08:30:00	SPY	ETF	169.77	169.86	169.61	169.69	280826.0
2013-07-24 09:00:00	SPY	ETF	169.69	169.8	169.55	169.8	722989.0
2013-07-24 09:30:00	SPY	ETF	169.79	169.86	169.11	169.1299	13890464.0
2013-07-24 10:00:00	SPY	ETF	169.12	169.29	168.68	168.77	14687196.0
2013-07-24 10:30:00	SPY	ETF	168.77	169.03	168.7	168.87	5207797.0
2013-07-24 11:00:00	SPY	ETF	168.87	169.02	168.75	169.01	5446565.0
2013-07-24 11:30:00	SPY	ETF	169.01	169.13	168.87	168.88	5708674.0
2013-07-24 12:00:00	SPY	ETF	168.88	168.92	168.52	168.57	5852105.0
2013-07-24 12:30:00	SPY	ETF	168.57	168.67	168.45	168.52	5994491.0
2013-07-24 13:00:00	SPY	ETF	168.52	168.65	168.28	168.37	8263740.0
2013-07-24 13:30:00	SPY	ETF	168.37	168.38	168.18	168.37	5939397.0
2013-07-24 14:00:00	SPY	ETF	168.37	168.62	168.36	168.54	5847575.0
2013-07-24 14:30:00	SPY	ETF	168.535	168.58	168.36	168.54	3942547.0
2013-07-24 15:00:00	SPY	ETF	168.535	168.55	168.24	168.4801	6533579.0
2013-07-24 15:30:00	SPY	ETF	168.49	168.59	168.3	168.53	14678481.0
2013-07-24 16:00:00	SPY	ETF	168.53	168.85	168.39	168.84	5126097.0
2013-07-24 16:30:00	SPY	ETF	168.84	168.88	168.4	168.85	452204.0
2013-07-24 17:00:00	SPY	ETF	168.86	168.89	168.82	168.85	52635.0
2013-07-24 17:30:00	SPY	ETF	168.85	168.89	168.83	168.86	25425.0
2013-07-24 18:00:00	SPY	ETF	168.85	168.89	168.76	168.86	32331.0
2013-07-24 18:30:00	SPY	ETF	168.81	168.81	168.76	168.77	32670.0
2013-07-24 19:00:00	SPY	ETF	168.75	168.79	168.75	168.78	8059.0
2013-07-24 19:30:00	SPY	ETF	168.75	168.8	168.7	168.73	39650.0
2013-07-24 04:00:00	QQQ	ETF	74.83	74.86	74.82	74.86	32300.0
2013-07-24 04:30:00	QQQ	ETF	74.86	74.88	74.86	74.88	2000.0
2013-07-24 05:00:00	QQQ	ETF	74.9	74.9	74.88	74.88	1600.0
2013-07-24 05:30:00	QQQ	ETF	74.88	74.88	74.84	74.84	2800.0
2013-07-24 06:00:00	QQQ	ETF	74.83	74.84	74.82	74.84	3700.0
2013-07-24 06:30:00	QQQ	ETF	74.85	74.93	74.85	74.89	15224.0
2013-07-24 07:00:00	QQQ	ETF	74.92	74.98	74.92	74.98	9400.0
2013-07-24 07:30:00	QQQ	ETF	75.0	75.01	74.96	74.99	33300.0
2013-07-24 08:00:00	QQQ	ETF	74.89	75.01	74.89	74.95	48155.0
2013-07-24 08:30:00	QQQ	ETF	74.95	74.97	74.94	74.96	114390.0
2013-07-24 09:00:00	QQQ	ETF	74.96	75.0	74.91	75.0	202539.0
2013-07-24 09:30:00	QQQ	ETF	74.99	75.02	74.61	74.63	3769005.0
2013-07-24 10:00:00	QQQ	ETF	74.62	74.68	74.4	74.511	2658519.0
2013-07-24 10:30:00	QQQ	ETF	74.51	74.72	74.46	74.63	1098837.0
2013-07-24 11:00:00	QQQ	ETF	74.63	74.825	74.62	74.81	1381083.0
2013-07-24 11:30:00	QQQ	ETF	74.82	74.87	74.71	74.71	1169033.0
2013-07-24 12:00:00	QQQ	ETF	74.71	74.77	74.53	74.54	1342090.0
2013-07-24 12:30:00	QQQ	ETF	74.55	74.61	74.49	74.55	850948.0

> showing 50 of 10,909 rows — these rows as CSV

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