PREVIEW / etf_30min / 2013-12-09

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-09.parquet
  size:    322 KB
  rows:    11,039

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-12-09 04:00:00	SPY	ETF	181.26	181.26	181.14	181.2	4212.0
2013-12-09 04:30:00	SPY	ETF	181.23	181.24	181.19	181.19	55430.0
2013-12-09 05:00:00	SPY	ETF	181.17	181.17	181.11	181.14	891.0
2013-12-09 05:30:00	SPY	ETF	181.11	181.11	181.05	181.11	16407.0
2013-12-09 06:00:00	SPY	ETF	181.14	181.17	181.02	181.08	5358.0
2013-12-09 06:30:00	SPY	ETF	181.07	181.09	181.04	181.05	14137.0
2013-12-09 07:00:00	SPY	ETF	181.07	181.22	181.07	181.22	24091.0
2013-12-09 07:30:00	SPY	ETF	181.23	181.24	181.19	181.22	100758.0
2013-12-09 08:00:00	SPY	ETF	181.22	181.36	181.12	181.36	214362.0
2013-12-09 08:30:00	SPY	ETF	181.38	181.39	181.28	181.29	179280.0
2013-12-09 09:00:00	SPY	ETF	181.29	181.5	181.27	181.48	515302.0
2013-12-09 09:30:00	SPY	ETF	181.47	181.65	181.23	181.63	11123823.0
2013-12-09 10:00:00	SPY	ETF	181.621	181.67	181.26	181.29	7147814.0
2013-12-09 10:30:00	SPY	ETF	181.28	181.5	181.16	181.4	4814716.0
2013-12-09 11:00:00	SPY	ETF	181.4	181.6699	181.37	181.57	5177790.0
2013-12-09 11:30:00	SPY	ETF	181.57	181.63	181.4475	181.489	4012162.0
2013-12-09 12:00:00	SPY	ETF	181.48	181.57	181.36	181.38	2351407.0
2013-12-09 12:30:00	SPY	ETF	181.37	181.52	181.35	181.45	2290788.0
2013-12-09 13:00:00	SPY	ETF	181.46	181.65	181.39	181.57	2788349.0
2013-12-09 13:30:00	SPY	ETF	181.566	181.62	181.4	181.4252	2068473.0
2013-12-09 14:00:00	SPY	ETF	181.4275	181.45	181.25	181.33	2477104.0
2013-12-09 14:30:00	SPY	ETF	181.33	181.49	181.3	181.34	2914166.0
2013-12-09 15:00:00	SPY	ETF	181.35	181.445	181.18	181.2001	3156562.0
2013-12-09 15:30:00	SPY	ETF	181.21	181.39	181.2	181.38	10284491.0
2013-12-09 16:00:00	SPY	ETF	181.38	181.45	180.9977	181.4	6344793.0
2013-12-09 16:30:00	SPY	ETF	181.4	181.44	181.39	181.42	791233.0
2013-12-09 17:00:00	SPY	ETF	181.4	181.46	181.36	181.44	39230.0
2013-12-09 17:30:00	SPY	ETF	181.46	181.46	181.42	181.43	55848.0
2013-12-09 18:00:00	SPY	ETF	181.45	181.55	181.45	181.52	102691.0
2013-12-09 18:30:00	SPY	ETF	181.49	181.51	181.48	181.5	26855.0
2013-12-09 19:00:00	SPY	ETF	181.47	181.51	181.46	181.51	49750.0
2013-12-09 19:30:00	SPY	ETF	181.52	181.58	181.51	181.55	37010.0
2013-12-09 04:00:00	QQQ	ETF	86.16	86.19	86.16	86.19	600.0
2013-12-09 04:30:00	QQQ	ETF	86.18	86.18	86.14	86.14	19400.0
2013-12-09 05:00:00	QQQ	ETF	86.17	86.17	86.14	86.14	2000.0
2013-12-09 05:30:00	QQQ	ETF	86.14	86.14	86.11	86.11	2000.0
2013-12-09 06:00:00	QQQ	ETF	86.14	86.15	86.11	86.14	3600.0
2013-12-09 06:30:00	QQQ	ETF	86.14	86.14	86.13	86.14	1420.0
2013-12-09 07:00:00	QQQ	ETF	86.14	86.22	86.14	86.22	19100.0
2013-12-09 07:30:00	QQQ	ETF	86.22	86.23	86.19	86.23	50204.0
2013-12-09 08:00:00	QQQ	ETF	86.22	86.29	86.22	86.28	24000.0
2013-12-09 08:30:00	QQQ	ETF	86.29	86.29	86.26	86.26	30357.0
2013-12-09 09:00:00	QQQ	ETF	86.27	86.35	86.27	86.35	185608.0
2013-12-09 09:30:00	QQQ	ETF	86.35	86.48	86.2	86.46	4092930.0
2013-12-09 10:00:00	QQQ	ETF	86.46	86.49	86.3	86.315	1991601.0
2013-12-09 10:30:00	QQQ	ETF	86.31	86.4699	86.27	86.4399	1579198.0
2013-12-09 11:00:00	QQQ	ETF	86.44	86.53	86.411	86.47	980383.0
2013-12-09 11:30:00	QQQ	ETF	86.46	86.5	86.385	86.39	934580.0
2013-12-09 12:00:00	QQQ	ETF	86.39	86.4301	86.32	86.33	953607.0
2013-12-09 12:30:00	QQQ	ETF	86.33	86.4	86.31	86.36	532458.0

> showing 50 of 11,039 rows — these rows as CSV

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