PREVIEW / stock_30min / 2011-01-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-18.parquet
  size:    1.4 MB
  rows:    77,218
  symbols: 3,542

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-01-18 04:00:00	AAPL	Stock	11.6429	11.7857	11.6429	11.7857	381612.0
2011-01-18 04:30:00	AAPL	Stock	11.7857	11.8107	11.7579	11.8107	149800.0
2011-01-18 05:00:00	AAPL	Stock	11.8211	11.9454	11.8211	11.925	385000.0
2011-01-18 05:30:00	AAPL	Stock	11.9143	11.9282	11.8454	11.8493	500780.0
2011-01-18 06:00:00	AAPL	Stock	11.8571	11.9404	11.8411	11.8789	339332.0
2011-01-18 06:30:00	AAPL	Stock	11.875	11.9375	11.8429	11.9018	1713796.0
2011-01-18 07:00:00	AAPL	Stock	11.9018	11.9018	11.7529	11.8214	7577248.0
2011-01-18 07:30:00	AAPL	Stock	11.8161	11.9089	11.8125	11.9	8325436.0
2011-01-18 08:00:00	AAPL	Stock	11.8929	11.9068	11.7714	11.8661	17055136.0
2011-01-18 08:30:00	AAPL	Stock	11.8732	11.9286	11.8246	11.8361	11549832.0
2011-01-18 09:00:00	AAPL	Stock	11.8339	11.9011	11.7611	11.7661	25096988.0
2011-01-18 09:30:00	AAPL	Stock	11.7661	12.0714	11.6429	11.9507	490210084.0
2011-01-18 10:00:00	AAPL	Stock	11.9527	11.9939	11.89	11.9861	151774868.0
2011-01-18 10:30:00	AAPL	Stock	11.9864	12.0021	11.9561	11.98	88887400.0
2011-01-18 11:00:00	AAPL	Stock	11.9793	12.0396	11.9743	12.0317	76198024.0
2011-01-18 11:30:00	AAPL	Stock	12.0311	12.1239	12.0193	12.1	89501020.0
2011-01-18 12:00:00	AAPL	Stock	12.1021	12.1389	12.0736	12.1307	70602476.0
2011-01-18 12:30:00	AAPL	Stock	12.1304	12.1942	12.1221	12.1689	107544668.0
2011-01-18 13:00:00	AAPL	Stock	12.1682	12.265	12.1632	12.2454	108268216.0
2011-01-18 13:30:00	AAPL	Stock	12.2454	12.2914	12.2071	12.2296	95489240.0
2011-01-18 14:00:00	AAPL	Stock	12.2296	12.2307	12.1622	12.1796	69815648.0
2011-01-18 14:30:00	AAPL	Stock	12.1811	12.2286	12.1793	12.21	55874728.0
2011-01-18 15:00:00	AAPL	Stock	12.2082	12.2193	12.1625	12.1832	59726772.0
2011-01-18 15:30:00	AAPL	Stock	12.1832	12.2607	12.1607	12.1786	138787292.0
2011-01-18 16:00:00	AAPL	Stock	12.1786	12.2321	11.9617	12.2168	56659260.0
2011-01-18 16:30:00	AAPL	Stock	11.6803	12.75	11.6803	12.3886	67198768.0
2011-01-18 17:00:00	AAPL	Stock	12.3929	12.4593	12.2875	12.3607	41711404.0
2011-01-18 17:30:00	AAPL	Stock	12.3575	12.3786	12.1807	12.3279	13133400.0
2011-01-18 18:00:00	AAPL	Stock	12.3275	12.3686	12.1661	12.3464	6927508.0
2011-01-18 18:30:00	AAPL	Stock	12.3464	12.3554	12.3164	12.3214	3235204.0
2011-01-18 19:00:00	AAPL	Stock	12.3214	12.3286	12.3164	12.325	2091684.0
2011-01-18 19:30:00	AAPL	Stock	12.3243	12.3264	12.3143	12.3179	2619708.0
2011-01-18 07:00:00	MSFT	Stock	28.32	28.32	28.32	28.32	1000.0
2011-01-18 07:30:00	MSFT	Stock	28.35	28.36	28.34	28.34	5200.0
2011-01-18 08:00:00	MSFT	Stock	28.34	28.34	28.3	28.3	19795.0
2011-01-18 08:30:00	MSFT	Stock	28.3	28.34	28.27	28.31	8107.0
2011-01-18 09:00:00	MSFT	Stock	28.31	28.31	28.14	28.15	55579.0
2011-01-18 09:30:00	MSFT	Stock	28.15	28.53	28.14	28.43	6441097.0
2011-01-18 10:00:00	MSFT	Stock	28.43	28.53	28.29	28.517	3349463.0
2011-01-18 10:30:00	MSFT	Stock	28.518	28.56	28.49	28.519	4018786.0
2011-01-18 11:00:00	MSFT	Stock	28.513	28.6	28.51	28.57	2997601.0
2011-01-18 11:30:00	MSFT	Stock	28.575	28.59	28.52	28.531	2204010.0
2011-01-18 12:00:00	MSFT	Stock	28.53	28.56	28.52	28.53	1625757.0
2011-01-18 12:30:00	MSFT	Stock	28.53	28.56	28.52	28.53	1133427.0
2011-01-18 13:00:00	MSFT	Stock	28.535	28.54	28.45	28.48	1929664.0
2011-01-18 13:30:00	MSFT	Stock	28.481	28.52	28.45	28.47	1877566.0
2011-01-18 14:00:00	MSFT	Stock	28.46	28.57	28.44	28.54	2183724.0
2011-01-18 14:30:00	MSFT	Stock	28.54	28.595	28.52	28.59	2976395.0
2011-01-18 15:00:00	MSFT	Stock	28.58	28.64	28.58	28.63	4320193.0
2011-01-18 15:30:00	MSFT	Stock	28.63	28.74	28.61	28.66	7220229.0

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

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