PREVIEW / stock_30min / 2014-02-25

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-25.parquet
  size:    1.6 MB
  rows:    82,875
  symbols: 3,528

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
2014-02-25 04:00:00	AAPL	Stock	18.8429	18.8429	18.6361	18.8321	11200.0
2014-02-25 04:30:00	AAPL	Stock	18.8214	18.8214	18.8036	18.8036	8400.0
2014-02-25 05:30:00	AAPL	Stock	18.8204	18.8204	18.8204	18.8204	11200.0
2014-02-25 06:30:00	AAPL	Stock	18.8643	18.8661	18.8643	18.8661	14000.0
2014-02-25 07:00:00	AAPL	Stock	18.8661	18.8925	18.8411	18.8411	58800.0
2014-02-25 07:30:00	AAPL	Stock	18.8429	18.8621	18.8429	18.8621	15176.0
2014-02-25 08:00:00	AAPL	Stock	18.8411	18.8889	18.8411	18.8786	205520.0
2014-02-25 08:30:00	AAPL	Stock	18.8825	18.8882	18.8621	18.8839	196532.0
2014-02-25 09:00:00	AAPL	Stock	18.8836	18.9286	18.8836	18.8961	1360380.0
2014-02-25 09:30:00	AAPL	Stock	18.9064	18.913	18.7646	18.7752	31976028.0
2014-02-25 10:00:00	AAPL	Stock	18.7771	18.7893	18.7154	18.775	22880088.0
2014-02-25 10:30:00	AAPL	Stock	18.7781	18.7998	18.6964	18.7107	12810980.0
2014-02-25 11:00:00	AAPL	Stock	18.7136	18.7921	18.6982	18.7679	13935012.0
2014-02-25 11:30:00	AAPL	Stock	18.7682	18.8671	18.7543	18.7971	13778268.0
2014-02-25 12:00:00	AAPL	Stock	18.797	18.8018	18.7325	18.7396	9006116.0
2014-02-25 12:30:00	AAPL	Stock	18.7375	18.7639	18.7179	18.7479	6140848.0
2014-02-25 13:00:00	AAPL	Stock	18.7468	18.7743	18.7429	18.7704	4745328.0
2014-02-25 13:30:00	AAPL	Stock	18.7704	18.7821	18.7143	18.7207	6921236.0
2014-02-25 14:00:00	AAPL	Stock	18.7225	18.7439	18.6579	18.7139	13700036.0
2014-02-25 14:30:00	AAPL	Stock	18.7129	18.7143	18.6643	18.6646	8933904.0
2014-02-25 15:00:00	AAPL	Stock	18.6703	18.6875	18.6071	18.6454	15423296.0
2014-02-25 15:30:00	AAPL	Stock	18.6432	18.6693	18.6357	18.6454	20472256.0
2014-02-25 16:00:00	AAPL	Stock	18.645	18.7427	18.6413	18.6714	6778772.0
2014-02-25 16:30:00	AAPL	Stock	18.6736	18.8995	18.6394	18.6714	367612.0
2014-02-25 17:00:00	AAPL	Stock	18.6696	18.6911	18.6696	18.6911	172788.0
2014-02-25 17:30:00	AAPL	Stock	18.6804	18.6807	18.6661	18.6714	75488.0
2014-02-25 18:00:00	AAPL	Stock	18.6871	18.6875	18.645	18.6704	424116.0
2014-02-25 18:30:00	AAPL	Stock	18.6725	18.6875	18.645	18.6786	152488.0
2014-02-25 19:00:00	AAPL	Stock	18.6786	18.6875	18.6736	18.6807	94164.0
2014-02-25 19:30:00	AAPL	Stock	18.6893	18.6911	18.6646	18.6679	238000.0
2014-02-25 07:00:00	MSFT	Stock	37.59	37.59	37.59	37.59	100.0
2014-02-25 08:00:00	MSFT	Stock	37.68	37.68	37.52	37.56	3590.0
2014-02-25 08:30:00	MSFT	Stock	37.56	37.64	37.56	37.64	3000.0
2014-02-25 09:00:00	MSFT	Stock	37.64	37.67	37.63	37.65	9882.0
2014-02-25 09:30:00	MSFT	Stock	37.65	37.78	37.35	37.58	5810439.0
2014-02-25 10:00:00	MSFT	Stock	37.58	37.79	37.55	37.695	2362386.0
2014-02-25 10:30:00	MSFT	Stock	37.69	37.79	37.68	37.76	1666151.0
2014-02-25 11:00:00	MSFT	Stock	37.76	37.8	37.72	37.79	1414945.0
2014-02-25 11:30:00	MSFT	Stock	37.79	37.85	37.69	37.69	1540783.0
2014-02-25 12:00:00	MSFT	Stock	37.69	37.7	37.57	37.6	1496710.0
2014-02-25 12:30:00	MSFT	Stock	37.6	37.63	37.53	37.62	1275617.0
2014-02-25 13:00:00	MSFT	Stock	37.62	37.73	37.59	37.725	1256515.0
2014-02-25 13:30:00	MSFT	Stock	37.72	37.74	37.65	37.7	1238249.0
2014-02-25 14:00:00	MSFT	Stock	37.695	37.7	37.54	37.62	1106348.0
2014-02-25 14:30:00	MSFT	Stock	37.61	37.67	37.57	37.625	1195695.0
2014-02-25 15:00:00	MSFT	Stock	37.624	37.63	37.53	37.59	2170929.0
2014-02-25 15:30:00	MSFT	Stock	37.59	37.61	37.51	37.55	5089609.0
2014-02-25 16:00:00	MSFT	Stock	37.54	37.641	37.35	37.54	2274454.0
2014-02-25 16:30:00	MSFT	Stock	37.6	37.622	37.54	37.54	98103.0
2014-02-25 17:00:00	MSFT	Stock	37.55	37.63	37.55	37.63	8025.0

> showing 50 of 82,875 rows — these rows as CSV

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