PREVIEW / stock_30min / 2012-08-14

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-14.parquet
  size:    1.4 MB
  rows:    73,598
  symbols: 3,485

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-08-14 04:00:00	AAPL	Stock	22.6225	22.6375	22.5893	22.6375	30380.0
2012-08-14 04:30:00	AAPL	Stock	22.6214	22.6521	22.6079	22.6464	25200.0
2012-08-14 05:00:00	AAPL	Stock	22.6093	22.6482	22.6089	22.6429	19600.0
2012-08-14 05:30:00	AAPL	Stock	22.6429	22.6429	22.61	22.6354	69860.0
2012-08-14 06:00:00	AAPL	Stock	22.6261	22.6496	22.6261	22.6357	40040.0
2012-08-14 06:30:00	AAPL	Stock	22.6493	22.6496	22.6339	22.6339	36400.0
2012-08-14 07:00:00	AAPL	Stock	22.6389	22.6425	22.5982	22.5982	194684.0
2012-08-14 07:30:00	AAPL	Stock	22.605	22.6143	22.5786	22.61	369264.0
2012-08-14 08:00:00	AAPL	Stock	22.6071	22.6214	22.5536	22.6214	1108940.0
2012-08-14 08:30:00	AAPL	Stock	22.6214	22.6393	22.5936	22.5964	1939812.0
2012-08-14 09:00:00	AAPL	Stock	22.5946	22.6136	22.5646	22.5714	1457652.0
2012-08-14 09:30:00	AAPL	Stock	22.5668	22.6893	22.5661	22.6571	58137828.0
2012-08-14 10:00:00	AAPL	Stock	22.6589	22.7054	22.6479	22.6646	29565704.0
2012-08-14 10:30:00	AAPL	Stock	22.6664	22.7232	22.6557	22.7179	22594712.0
2012-08-14 11:00:00	AAPL	Stock	22.715	22.7875	22.707	22.7854	24665676.0
2012-08-14 11:30:00	AAPL	Stock	22.7875	22.8075	22.7107	22.7261	26483408.0
2012-08-14 12:00:00	AAPL	Stock	22.7282	22.7679	22.705	22.728	17205020.0
2012-08-14 12:30:00	AAPL	Stock	22.7279	22.7436	22.6396	22.6832	26079312.0
2012-08-14 13:00:00	AAPL	Stock	22.6839	22.7086	22.5971	22.6132	20481048.0
2012-08-14 13:30:00	AAPL	Stock	22.6154	22.7028	22.6111	22.6707	15085252.0
2012-08-14 14:00:00	AAPL	Stock	22.67	22.6875	22.6286	22.6532	10607296.0
2012-08-14 14:30:00	AAPL	Stock	22.6557	22.6854	22.6357	22.6793	11121768.0
2012-08-14 15:00:00	AAPL	Stock	22.6804	22.6832	22.6146	22.6318	14062860.0
2012-08-14 15:30:00	AAPL	Stock	22.6311	22.6386	22.5075	22.5582	48260380.0
2012-08-14 16:00:00	AAPL	Stock	22.5604	22.6716	22.5489	22.5764	4394852.0
2012-08-14 16:30:00	AAPL	Stock	22.575	22.6242	22.5596	22.5643	419440.0
2012-08-14 17:00:00	AAPL	Stock	22.5611	22.5725	22.5607	22.5725	139636.0
2012-08-14 17:30:00	AAPL	Stock	22.5789	22.5811	22.5739	22.5811	19600.0
2012-08-14 18:00:00	AAPL	Stock	22.5804	22.5889	22.5768	22.5821	72604.0
2012-08-14 18:30:00	AAPL	Stock	22.5861	22.5861	22.5782	22.5804	84168.0
2012-08-14 19:00:00	AAPL	Stock	22.5786	22.5836	22.5739	22.5739	63616.0
2012-08-14 19:30:00	AAPL	Stock	22.575	22.5893	22.5739	22.5893	171052.0
2012-08-14 06:30:00	MSFT	Stock	30.4	30.4	30.4	30.4	150.0
2012-08-14 07:30:00	MSFT	Stock	30.33	30.33	30.11	30.29	5400.0
2012-08-14 08:00:00	MSFT	Stock	30.28	30.29	30.26	30.26	5800.0
2012-08-14 08:30:00	MSFT	Stock	30.33	30.4	30.26	30.4	28682.0
2012-08-14 09:00:00	MSFT	Stock	30.32	30.4	30.29	30.31	56483.0
2012-08-14 09:30:00	MSFT	Stock	30.3	30.39	30.14	30.222	3964429.0
2012-08-14 10:00:00	MSFT	Stock	30.23	30.27	30.16	30.2	2877826.0
2012-08-14 10:30:00	MSFT	Stock	30.195	30.29	30.15	30.261	1651530.0
2012-08-14 11:00:00	MSFT	Stock	30.262	30.28	30.21	30.225	1309402.0
2012-08-14 11:30:00	MSFT	Stock	30.22	30.25	30.2	30.21	1509583.0
2012-08-14 12:00:00	MSFT	Stock	30.21	30.24	30.18	30.216	1830195.0
2012-08-14 12:30:00	MSFT	Stock	30.21	30.22	30.1	30.14	2430748.0
2012-08-14 13:00:00	MSFT	Stock	30.145	30.21	30.12	30.15	1420422.0
2012-08-14 13:30:00	MSFT	Stock	30.155	30.17	30.13	30.15	1214582.0
2012-08-14 14:00:00	MSFT	Stock	30.15	30.16	30.07	30.11	2954793.0
2012-08-14 14:30:00	MSFT	Stock	30.11	30.12	30.05	30.085	1774136.0
2012-08-14 15:00:00	MSFT	Stock	30.09	30.1	30.01	30.076	2761462.0
2012-08-14 15:30:00	MSFT	Stock	30.08	30.14	30.01	30.14	7133185.0

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

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