PREVIEW / etf_30min / 2013-12-10

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-10.parquet
  size:    323 KB
  rows:    11,131

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-10 04:00:00	SPY	ETF	181.56	181.57	181.5	181.5	1450.0
2013-12-10 04:30:00	SPY	ETF	181.54	181.63	181.54	181.63	1424.0
2013-12-10 05:00:00	SPY	ETF	181.61	181.62	181.6	181.62	4400.0
2013-12-10 05:30:00	SPY	ETF	181.59	181.6	181.53	181.55	3908.0
2013-12-10 06:00:00	SPY	ETF	181.57	181.6	181.57	181.6	772.0
2013-12-10 06:30:00	SPY	ETF	181.63	181.63	181.62	181.62	300.0
2013-12-10 07:00:00	SPY	ETF	181.62	181.62	181.4	181.4	61893.0
2013-12-10 07:30:00	SPY	ETF	181.41	181.42	181.27	181.29	163313.0
2013-12-10 08:00:00	SPY	ETF	181.3	181.34	181.02	181.04	259953.0
2013-12-10 08:30:00	SPY	ETF	181.04	181.04	180.8	180.88	561725.0
2013-12-10 09:00:00	SPY	ETF	180.87	180.98	180.82	180.96	556173.0
2013-12-10 09:30:00	SPY	ETF	180.98	181.2	180.85	181.1	8969057.0
2013-12-10 10:00:00	SPY	ETF	181.11	181.3	181.05	181.15	4481357.0
2013-12-10 10:30:00	SPY	ETF	181.15	181.36	181.1251	181.18	4126533.0
2013-12-10 11:00:00	SPY	ETF	181.18	181.2	180.96	181.01	4093013.0
2013-12-10 11:30:00	SPY	ETF	181.01	181.02	180.79	180.865	4177295.0
2013-12-10 12:00:00	SPY	ETF	180.87	180.97	180.68	180.91	5023192.0
2013-12-10 12:30:00	SPY	ETF	180.91	181.07	180.83	181.005	2842656.0
2013-12-10 13:00:00	SPY	ETF	181.0	181.09	180.81	180.835	3439232.0
2013-12-10 13:30:00	SPY	ETF	180.84	180.91	180.635	180.74	2835749.0
2013-12-10 14:00:00	SPY	ETF	180.74	180.89	180.71	180.86	3199249.0
2013-12-10 14:30:00	SPY	ETF	180.87	180.96	180.72	180.93	3984127.0
2013-12-10 15:00:00	SPY	ETF	180.93	181.11	180.9	181.03	5926152.0
2013-12-10 15:30:00	SPY	ETF	181.02	181.07	180.73	180.77	9727410.0
2013-12-10 16:00:00	SPY	ETF	180.78	180.9098	180.7413	180.83	7396559.0
2013-12-10 16:30:00	SPY	ETF	180.83	180.91	180.83	180.89	1556111.0
2013-12-10 17:00:00	SPY	ETF	180.88	180.9	180.87	180.9	242436.0
2013-12-10 17:30:00	SPY	ETF	180.9	180.9	180.88	180.9	143700.0
2013-12-10 18:00:00	SPY	ETF	180.9	181.09	180.75	181.07	2155095.0
2013-12-10 18:30:00	SPY	ETF	181.08	181.17	181.05	181.07	1155677.0
2013-12-10 19:00:00	SPY	ETF	181.07	181.26	181.07	181.25	2080915.0
2013-12-10 19:30:00	SPY	ETF	181.23	181.35	181.23	181.29	1136420.0
2013-12-10 04:30:00	QQQ	ETF	86.46	86.51	86.46	86.51	6800.0
2013-12-10 05:30:00	QQQ	ETF	86.48	86.48	86.48	86.48	800.0
2013-12-10 06:00:00	QQQ	ETF	86.48	86.48	86.48	86.48	300.0
2013-12-10 07:00:00	QQQ	ETF	86.48	86.48	86.41	86.41	12500.0
2013-12-10 07:30:00	QQQ	ETF	86.4	86.4	86.36	86.36	7800.0
2013-12-10 08:00:00	QQQ	ETF	86.33	86.33	86.21	86.23	29828.0
2013-12-10 08:30:00	QQQ	ETF	86.18	86.2	86.12	86.15	33844.0
2013-12-10 09:00:00	QQQ	ETF	86.15	86.19	86.15	86.19	258449.0
2013-12-10 09:30:00	QQQ	ETF	86.19	86.3399	86.12	86.2	3523720.0
2013-12-10 10:00:00	QQQ	ETF	86.21	86.34	86.19	86.31	2412327.0
2013-12-10 10:30:00	QQQ	ETF	86.31	86.45	86.3	86.35	1808818.0
2013-12-10 11:00:00	QQQ	ETF	86.34	86.43	86.28	86.3701	1388516.0
2013-12-10 11:30:00	QQQ	ETF	86.38	86.39	86.26	86.3	2316334.0
2013-12-10 12:00:00	QQQ	ETF	86.29	86.35	86.18	86.32	1892859.0
2013-12-10 12:30:00	QQQ	ETF	86.325	86.3799	86.2725	86.3201	897623.0
2013-12-10 13:00:00	QQQ	ETF	86.32	86.37	86.23	86.243	601308.0
2013-12-10 13:30:00	QQQ	ETF	86.26	86.3	86.18	86.22	1078012.0
2013-12-10 14:00:00	QQQ	ETF	86.22	86.32	86.2	86.31	1390038.0

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

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