PREVIEW / stock_30min / 2013-03-28

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-28.parquet
  size:    1.5 MB
  rows:    77,601
  symbols: 3,494

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-03-28 04:00:00	AAPL	Stock	16.0936	16.0936	16.0936	16.0936	2800.0
2013-03-28 07:00:00	AAPL	Stock	16.1564	16.1607	16.1493	16.1493	22036.0
2013-03-28 07:30:00	AAPL	Stock	16.1786	16.1786	16.1682	16.1682	33600.0
2013-03-28 08:00:00	AAPL	Stock	16.1786	16.1786	16.125	16.1554	191436.0
2013-03-28 08:30:00	AAPL	Stock	16.155	16.155	16.0929	16.1018	585256.0
2013-03-28 09:00:00	AAPL	Stock	16.1061	16.1071	16.0564	16.0643	1520848.0
2013-03-28 09:30:00	AAPL	Stock	16.0711	16.1364	16.0032	16.0714	62501320.0
2013-03-28 10:00:00	AAPL	Stock	16.0714	16.0929	16.0143	16.0209	29305500.0
2013-03-28 10:30:00	AAPL	Stock	16.0236	16.0489	15.9871	16.0168	29751456.0
2013-03-28 11:00:00	AAPL	Stock	16.02	16.024	15.9375	15.945	23311204.0
2013-03-28 11:30:00	AAPL	Stock	15.9439	15.9493	15.8454	15.8704	53429600.0
2013-03-28 12:00:00	AAPL	Stock	15.8693	15.8982	15.8463	15.8657	27652184.0
2013-03-28 12:30:00	AAPL	Stock	15.8686	15.8982	15.8493	15.8646	17157308.0
2013-03-28 13:00:00	AAPL	Stock	15.8646	15.8721	15.8404	15.8668	11165140.0
2013-03-28 13:30:00	AAPL	Stock	15.8686	15.8918	15.8464	15.8586	11639936.0
2013-03-28 14:00:00	AAPL	Stock	15.8586	15.8618	15.7971	15.7975	19959408.0
2013-03-28 14:30:00	AAPL	Stock	15.7993	15.825	15.7721	15.825	28344260.0
2013-03-28 15:00:00	AAPL	Stock	15.8257	15.83	15.795	15.8089	19678708.0
2013-03-28 15:30:00	AAPL	Stock	15.8107	15.8386	15.7768	15.805	60712568.0
2013-03-28 16:00:00	AAPL	Stock	15.8041	15.9139	15.7875	15.8082	29623272.0
2013-03-28 16:30:00	AAPL	Stock	15.7936	15.9005	15.7143	15.7714	3936912.0
2013-03-28 17:00:00	AAPL	Stock	15.7786	15.8082	15.7707	15.7857	1465240.0
2013-03-28 17:30:00	AAPL	Stock	15.7857	15.7964	15.7829	15.7964	296100.0
2013-03-28 18:00:00	AAPL	Stock	15.7843	15.7861	15.7786	15.7861	47236.0
2013-03-28 18:30:00	AAPL	Stock	15.7857	15.7939	15.7857	15.7939	25200.0
2013-03-28 19:00:00	AAPL	Stock	15.7893	15.7893	15.7857	15.7864	23352.0
2013-03-28 19:30:00	AAPL	Stock	15.7857	15.7886	15.7679	15.7857	94528.0
2013-03-28 06:30:00	MSFT	Stock	28.21	28.21	28.21	28.21	400.0
2013-03-28 07:00:00	MSFT	Stock	28.38	28.38	28.38	28.38	100.0
2013-03-28 07:30:00	MSFT	Stock	28.48	28.48	28.48	28.48	390.0
2013-03-28 08:00:00	MSFT	Stock	28.37	28.45	28.32	28.4	8291.0
2013-03-28 08:30:00	MSFT	Stock	28.37	28.4	28.37	28.4	5613.0
2013-03-28 09:00:00	MSFT	Stock	28.38	28.38	28.27	28.27	3020.0
2013-03-28 09:30:00	MSFT	Stock	28.27	28.47	28.26	28.355	3725483.0
2013-03-28 10:00:00	MSFT	Stock	28.36	28.42	28.34	28.41	1446325.0
2013-03-28 10:30:00	MSFT	Stock	28.42	28.52	28.4	28.5	2287209.0
2013-03-28 11:00:00	MSFT	Stock	28.5	28.59	28.49	28.574	2971057.0
2013-03-28 11:30:00	MSFT	Stock	28.575	28.66	28.54	28.555	5138071.0
2013-03-28 12:00:00	MSFT	Stock	28.555	28.565	28.47	28.47	3256516.0
2013-03-28 12:30:00	MSFT	Stock	28.47	28.52	28.333	28.46	5452893.0
2013-03-28 13:00:00	MSFT	Stock	28.46	28.51	28.46	28.497	819603.0
2013-03-28 13:30:00	MSFT	Stock	28.5	28.51	28.45	28.455	1136193.0
2013-03-28 14:00:00	MSFT	Stock	28.46	28.54	28.455	28.52	2471246.0
2013-03-28 14:30:00	MSFT	Stock	28.525	28.6	28.51	28.56	1977247.0
2013-03-28 15:00:00	MSFT	Stock	28.57	28.6	28.51	28.575	1779590.0
2013-03-28 15:30:00	MSFT	Stock	28.58	28.635	28.535	28.6	6709482.0
2013-03-28 16:00:00	MSFT	Stock	28.615	28.625	28.512	28.61	9538478.0
2013-03-28 16:30:00	MSFT	Stock	28.57	28.635	28.484	28.61	1279766.0
2013-03-28 17:00:00	MSFT	Stock	28.62	28.66	28.59	28.66	13835.0
2013-03-28 17:30:00	MSFT	Stock	28.62	28.62	28.62	28.62	258.0

> showing 50 of 77,601 rows — these rows as CSV

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