PREVIEW / stock_30min / 2012-09-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-12.parquet
  size:    1.4 MB
  rows:    73,255
  symbols: 3,466

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
2012-09-12 04:00:00	AAPL	Stock	23.7507	23.7679	23.7061	23.75	100800.0
2012-09-12 04:30:00	AAPL	Stock	23.7561	23.7857	23.7561	23.7857	34580.0
2012-09-12 05:00:00	AAPL	Stock	23.7857	23.8036	23.7857	23.8036	29400.0
2012-09-12 05:30:00	AAPL	Stock	23.8193	23.8568	23.7893	23.8532	48244.0
2012-09-12 06:00:00	AAPL	Stock	23.8393	23.8429	23.8286	23.8286	12712.0
2012-09-12 06:30:00	AAPL	Stock	23.8421	23.8429	23.7857	23.7857	74816.0
2012-09-12 07:00:00	AAPL	Stock	23.8089	23.8393	23.75	23.7768	719908.0
2012-09-12 07:30:00	AAPL	Stock	23.7714	23.7714	23.7132	23.7139	343364.0
2012-09-12 08:00:00	AAPL	Stock	23.7143	23.8125	23.7107	23.7504	1522220.0
2012-09-12 08:30:00	AAPL	Stock	23.7504	23.7918	23.7482	23.7714	1047928.0
2012-09-12 09:00:00	AAPL	Stock	23.775	23.8214	23.7279	23.8061	2312212.0
2012-09-12 09:30:00	AAPL	Stock	23.8161	23.8186	23.6021	23.6246	64445948.0
2012-09-12 10:00:00	AAPL	Stock	23.625	23.6296	23.5179	23.597	43873004.0
2012-09-12 10:30:00	AAPL	Stock	23.5914	23.6357	23.5232	23.5762	26322632.0
2012-09-12 11:00:00	AAPL	Stock	23.5786	23.5903	23.5243	23.5529	19782644.0
2012-09-12 11:30:00	AAPL	Stock	23.5514	23.6964	23.55	23.6631	31446156.0
2012-09-12 12:00:00	AAPL	Stock	23.6632	23.6854	23.5386	23.5764	23639980.0
2012-09-12 12:30:00	AAPL	Stock	23.5777	23.63	23.5605	23.6099	15979656.0
2012-09-12 13:00:00	AAPL	Stock	23.6136	23.7607	23.4421	23.5918	100649612.0
2012-09-12 13:30:00	AAPL	Stock	23.5968	23.8775	23.5718	23.6743	97159356.0
2012-09-12 14:00:00	AAPL	Stock	23.6836	23.7811	23.6129	23.7393	45910424.0
2012-09-12 14:30:00	AAPL	Stock	23.7393	23.7975	23.5111	23.5282	60622184.0
2012-09-12 15:00:00	AAPL	Stock	23.5321	23.6193	23.4286	23.6114	55380584.0
2012-09-12 15:30:00	AAPL	Stock	23.6105	23.925	23.5982	23.9236	95237464.0
2012-09-12 16:00:00	AAPL	Stock	23.9225	24.0429	23.5282	24.0429	12764500.0
2012-09-12 16:30:00	AAPL	Stock	24.0396	24.0421	23.6142	23.9946	1916656.0
2012-09-12 17:00:00	AAPL	Stock	23.9914	23.9957	23.9211	23.9857	912128.0
2012-09-12 17:30:00	AAPL	Stock	23.9839	23.9893	23.9761	23.9768	395304.0
2012-09-12 18:00:00	AAPL	Stock	23.9771	24.0	23.9679	23.9711	545776.0
2012-09-12 18:30:00	AAPL	Stock	23.9711	23.9821	23.9679	23.9714	294504.0
2012-09-12 19:00:00	AAPL	Stock	23.9811	23.9904	23.9714	23.9714	224308.0
2012-09-12 19:30:00	AAPL	Stock	23.9732	23.9886	23.9714	23.9714	297696.0
2012-09-12 08:00:00	MSFT	Stock	30.9	30.9	30.79	30.89	6800.0
2012-09-12 08:30:00	MSFT	Stock	30.89	30.89	30.87	30.87	2042.0
2012-09-12 09:00:00	MSFT	Stock	30.88	30.9	30.87	30.9	13028.0
2012-09-12 09:30:00	MSFT	Stock	30.94	31.18	30.89	31.03	3568450.0
2012-09-12 10:00:00	MSFT	Stock	31.02	31.08	31.0	31.0	2195498.0
2012-09-12 10:30:00	MSFT	Stock	31.0	31.069	30.96	31.05	2003178.0
2012-09-12 11:00:00	MSFT	Stock	31.06	31.07	30.92	30.92	1544431.0
2012-09-12 11:30:00	MSFT	Stock	30.928	30.98	30.87	30.88	1656280.0
2012-09-12 12:00:00	MSFT	Stock	30.88	30.9	30.833	30.87	1268629.0
2012-09-12 12:30:00	MSFT	Stock	30.87	30.89	30.84	30.89	985689.0
2012-09-12 13:00:00	MSFT	Stock	30.89	30.96	30.88	30.91	1689874.0
2012-09-12 13:30:00	MSFT	Stock	30.913	30.94	30.9	30.92	882253.0
2012-09-12 14:00:00	MSFT	Stock	30.919	30.99	30.885	30.94	2589733.0
2012-09-12 14:30:00	MSFT	Stock	30.94	30.95	30.84	30.84	1367106.0
2012-09-12 15:00:00	MSFT	Stock	30.84	30.86	30.73	30.82	2841068.0
2012-09-12 15:30:00	MSFT	Stock	30.82	30.84	30.75	30.78	4649589.0
2012-09-12 16:00:00	MSFT	Stock	30.78	31.04	30.76	30.83	2791870.0
2012-09-12 16:30:00	MSFT	Stock	30.829	30.941	30.829	30.941	1526.0

> showing 50 of 73,255 rows — these rows as CSV

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