PREVIEW / stock_30min / 2010-08-27

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-27.parquet
  size:    1.3 MB
  rows:    73,334
  symbols: 3,465

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
2010-08-27 06:30:00	AAPL	Stock	8.6232	8.6429	8.6214	8.6429	57400.0
2010-08-27 07:00:00	AAPL	Stock	8.6046	8.6429	8.5993	8.6311	187600.0
2010-08-27 07:30:00	AAPL	Stock	8.6304	8.6418	8.6111	8.6275	245000.0
2010-08-27 08:00:00	AAPL	Stock	8.6218	8.6232	8.5925	8.5975	517580.0
2010-08-27 08:30:00	AAPL	Stock	8.5996	8.6729	8.5996	8.6421	2672124.0
2010-08-27 09:00:00	AAPL	Stock	8.6396	8.6525	8.6179	8.6354	832160.0
2010-08-27 09:30:00	AAPL	Stock	8.635	8.6646	8.5071	8.5111	68765200.0
2010-08-27 10:00:00	AAPL	Stock	8.5132	8.5957	8.4129	8.5693	139904884.0
2010-08-27 10:30:00	AAPL	Stock	8.5696	8.5996	8.5457	8.5589	46892328.0
2010-08-27 11:00:00	AAPL	Stock	8.5589	8.6264	8.5568	8.6168	45990308.0
2010-08-27 11:30:00	AAPL	Stock	8.6157	8.6204	8.5814	8.5861	23995664.0
2010-08-27 12:00:00	AAPL	Stock	8.5854	8.6161	8.5771	8.6057	21493080.0
2010-08-27 12:30:00	AAPL	Stock	8.6052	8.6134	8.5804	8.5896	16775164.0
2010-08-27 13:00:00	AAPL	Stock	8.5904	8.6071	8.5757	8.6046	20787928.0
2010-08-27 13:30:00	AAPL	Stock	8.6046	8.6239	8.5989	8.6214	31370192.0
2010-08-27 14:00:00	AAPL	Stock	8.6214	8.6229	8.5907	8.5986	19241880.0
2010-08-27 14:30:00	AAPL	Stock	8.5986	8.6307	8.5964	8.6114	24538192.0
2010-08-27 15:00:00	AAPL	Stock	8.6102	8.6179	8.5921	8.6143	23159584.0
2010-08-27 15:30:00	AAPL	Stock	8.6154	8.6321	8.6043	8.6282	45719268.0
2010-08-27 16:00:00	AAPL	Stock	8.6286	8.6375	8.5751	8.6268	10663296.0
2010-08-27 16:30:00	AAPL	Stock	8.6279	8.6375	8.6275	8.6375	99960.0
2010-08-27 17:00:00	AAPL	Stock	8.6357	8.6568	8.6293	8.6293	1441748.0
2010-08-27 17:30:00	AAPL	Stock	8.65	8.6607	8.65	8.6546	166460.0
2010-08-27 18:00:00	AAPL	Stock	8.6536	8.6536	8.6293	8.6475	91224.0
2010-08-27 18:30:00	AAPL	Stock	8.6446	8.6511	8.6446	8.6475	68768.0
2010-08-27 19:00:00	AAPL	Stock	8.6482	8.6589	8.6482	8.6486	61656.0
2010-08-27 19:30:00	AAPL	Stock	8.655	8.6564	8.6543	8.6564	60060.0
2010-08-27 20:00:00	AAPL	Stock	8.5946	8.5946	8.5946	8.5946	8400.0
2010-08-27 08:00:00	MSFT	Stock	23.85	23.85	23.85	23.85	200.0
2010-08-27 08:30:00	MSFT	Stock	23.9	24.18	23.9	23.99	33500.0
2010-08-27 09:00:00	MSFT	Stock	23.99	24.0	23.85	23.9	35532.0
2010-08-27 09:30:00	MSFT	Stock	23.88	24.02	23.73	23.76	5519224.0
2010-08-27 10:00:00	MSFT	Stock	23.76	23.86	23.53	23.755	11262922.0
2010-08-27 10:30:00	MSFT	Stock	23.76	23.82	23.51	23.53	6709519.0
2010-08-27 11:00:00	MSFT	Stock	23.535	23.77	23.53	23.73	5218714.0
2010-08-27 11:30:00	MSFT	Stock	23.73	23.77	23.6	23.65	3431237.0
2010-08-27 12:00:00	MSFT	Stock	23.65	23.78	23.59	23.734	2649198.0
2010-08-27 12:30:00	MSFT	Stock	23.74	23.77	23.62	23.635	2654257.0
2010-08-27 13:00:00	MSFT	Stock	23.635	23.79	23.63	23.785	1877601.0
2010-08-27 13:30:00	MSFT	Stock	23.785	23.85	23.73	23.83	1880346.0
2010-08-27 14:00:00	MSFT	Stock	23.82	23.86	23.74	23.86	3285229.0
2010-08-27 14:30:00	MSFT	Stock	23.86	23.97	23.85	23.861	3269243.0
2010-08-27 15:00:00	MSFT	Stock	23.86	23.955	23.82	23.94	1970915.0
2010-08-27 15:30:00	MSFT	Stock	23.94	23.95	23.85	23.93	5415860.0
2010-08-27 16:00:00	MSFT	Stock	23.92	23.94	23.75	23.91	5185046.0
2010-08-27 16:30:00	MSFT	Stock	23.93	23.98	23.905	23.95	19136.0
2010-08-27 17:00:00	MSFT	Stock	23.95	23.95	23.93	23.93	91869.0
2010-08-27 17:30:00	MSFT	Stock	23.95	23.95	23.93	23.94	25354.0
2010-08-27 18:00:00	MSFT	Stock	23.93	23.93	23.93	23.93	26914.0
2010-08-27 18:30:00	MSFT	Stock	23.96	23.98	23.94	23.98	1900.0

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

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