PREVIEW / stock_30min / 2011-02-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-28.parquet
  size:    1.5 MB
  rows:    78,153
  symbols: 3,560

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
2011-02-28 04:00:00	AAPL	Stock	12.5	12.5714	12.5	12.5714	35000.0
2011-02-28 04:30:00	AAPL	Stock	12.5714	12.5821	12.57	12.5821	33600.0
2011-02-28 05:00:00	AAPL	Stock	12.5643	12.5793	12.4464	12.5704	28420.0
2011-02-28 05:30:00	AAPL	Stock	12.5714	12.575	12.5714	12.575	19600.0
2011-02-28 06:00:00	AAPL	Stock	12.5732	12.5861	12.5732	12.5861	14000.0
2011-02-28 06:30:00	AAPL	Stock	12.5821	12.5889	12.5714	12.5889	30800.0
2011-02-28 07:00:00	AAPL	Stock	12.5804	12.5804	12.5186	12.525	316820.0
2011-02-28 07:30:00	AAPL	Stock	12.525	12.5554	12.525	12.5468	330232.0
2011-02-28 08:00:00	AAPL	Stock	12.5464	12.5786	12.5421	12.5614	1574664.0
2011-02-28 08:30:00	AAPL	Stock	12.5614	12.5629	12.5429	12.5482	1274560.0
2011-02-28 09:00:00	AAPL	Stock	12.5475	12.5543	12.5386	12.54	2330300.0
2011-02-28 09:30:00	AAPL	Stock	12.5439	12.6804	12.54	12.6407	92815268.0
2011-02-28 10:00:00	AAPL	Stock	12.64	12.6561	12.625	12.6329	30310476.0
2011-02-28 10:30:00	AAPL	Stock	12.6347	12.6425	12.5925	12.6157	35346612.0
2011-02-28 11:00:00	AAPL	Stock	12.6157	12.6218	12.5986	12.6018	16510508.0
2011-02-28 11:30:00	AAPL	Stock	12.6014	12.6286	12.5739	12.6107	25902772.0
2011-02-28 12:00:00	AAPL	Stock	12.61	12.6193	12.6007	12.6089	12238184.0
2011-02-28 12:30:00	AAPL	Stock	12.6089	12.6307	12.5643	12.575	21156408.0
2011-02-28 13:00:00	AAPL	Stock	12.5739	12.5839	12.5504	12.5621	20283564.0
2011-02-28 13:30:00	AAPL	Stock	12.5618	12.5786	12.5482	12.5528	11425008.0
2011-02-28 14:00:00	AAPL	Stock	12.5496	12.6029	12.545	12.6001	18455080.0
2011-02-28 14:30:00	AAPL	Stock	12.6	12.6157	12.5875	12.6043	16626652.0
2011-02-28 15:00:00	AAPL	Stock	12.6036	12.615	12.5807	12.6089	17121692.0
2011-02-28 15:30:00	AAPL	Stock	12.6103	12.6261	12.5982	12.6246	40553968.0
2011-02-28 16:00:00	AAPL	Stock	12.6221	12.6427	12.5901	12.6115	25133360.0
2011-02-28 16:30:00	AAPL	Stock	12.6193	12.6364	12.4343	12.62	1823136.0
2011-02-28 17:00:00	AAPL	Stock	12.6189	12.6232	12.6071	12.6143	225988.0
2011-02-28 17:30:00	AAPL	Stock	12.6182	12.6357	12.6182	12.6357	308084.0
2011-02-28 18:00:00	AAPL	Stock	12.635	12.635	12.6286	12.6332	59388.0
2011-02-28 18:30:00	AAPL	Stock	12.6354	12.6411	12.6146	12.6393	288820.0
2011-02-28 19:00:00	AAPL	Stock	12.6418	12.6418	12.6375	12.64	86436.0
2011-02-28 19:30:00	AAPL	Stock	12.6414	12.6429	12.64	12.6429	331996.0
2011-02-28 04:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	200.0
2011-02-28 07:00:00	MSFT	Stock	26.6	26.6	26.59	26.59	1120.0
2011-02-28 07:30:00	MSFT	Stock	26.66	26.68	26.52	26.59	6772.0
2011-02-28 08:00:00	MSFT	Stock	26.65	26.65	26.6	26.64	6450.0
2011-02-28 08:30:00	MSFT	Stock	26.64	26.65	26.61	26.62	19339.0
2011-02-28 09:00:00	MSFT	Stock	26.63	26.73	26.61	26.68	121468.0
2011-02-28 09:30:00	MSFT	Stock	26.65	26.86	26.6	26.75	6567309.0
2011-02-28 10:00:00	MSFT	Stock	26.75	26.79	26.73	26.76	3734688.0
2011-02-28 10:30:00	MSFT	Stock	26.755	26.79	26.71	26.78	3623078.0
2011-02-28 11:00:00	MSFT	Stock	26.79	26.8	26.72	26.72	2177761.0
2011-02-28 11:30:00	MSFT	Stock	26.72	26.73	26.62	26.63	2881799.0
2011-02-28 12:00:00	MSFT	Stock	26.62	26.67	26.61	26.65	2459031.0
2011-02-28 12:30:00	MSFT	Stock	26.64	26.65	26.54	26.6	3186711.0
2011-02-28 13:00:00	MSFT	Stock	26.59	26.61	26.51	26.562	2268713.0
2011-02-28 13:30:00	MSFT	Stock	26.57	26.62	26.53	26.548	2233113.0
2011-02-28 14:00:00	MSFT	Stock	26.54	26.6	26.53	26.58	2038934.0
2011-02-28 14:30:00	MSFT	Stock	26.582	26.61	26.55	26.59	2045058.0
2011-02-28 15:00:00	MSFT	Stock	26.59	26.6	26.54	26.56	3183605.0

> showing 50 of 78,153 rows — these rows as CSV

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