PREVIEW / stock_30min / 2012-08-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-20.parquet
  size:    1.4 MB
  rows:    73,560
  symbols: 3,459

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-20 04:00:00	AAPL	Stock	23.2682	23.3393	23.2682	23.2857	46004.0
2012-08-20 04:30:00	AAPL	Stock	23.2771	23.2857	23.275	23.2857	37268.0
2012-08-20 05:00:00	AAPL	Stock	23.3214	23.3482	23.3036	23.3482	77056.0
2012-08-20 05:30:00	AAPL	Stock	23.3393	23.3482	23.3304	23.3304	33600.0
2012-08-20 06:00:00	AAPL	Stock	23.3304	23.3304	23.2768	23.2768	72660.0
2012-08-20 06:30:00	AAPL	Stock	23.2714	23.2857	23.2714	23.2857	22400.0
2012-08-20 07:00:00	AAPL	Stock	23.2732	23.2861	23.1786	23.1893	659400.0
2012-08-20 07:30:00	AAPL	Stock	23.1921	23.1932	23.1604	23.1846	434952.0
2012-08-20 08:00:00	AAPL	Stock	23.1857	23.2857	23.175	23.2536	2242856.0
2012-08-20 08:30:00	AAPL	Stock	23.2536	23.2536	23.2221	23.2429	928844.0
2012-08-20 09:00:00	AAPL	Stock	23.2446	23.2554	23.2086	23.2161	1973104.0
2012-08-20 09:30:00	AAPL	Stock	23.2179	23.3929	23.2107	23.325	89352480.0
2012-08-20 10:00:00	AAPL	Stock	23.325	23.5178	23.3214	23.5139	61595044.0
2012-08-20 10:30:00	AAPL	Stock	23.5125	23.5536	23.4404	23.5471	61047336.0
2012-08-20 11:00:00	AAPL	Stock	23.5467	23.5975	23.5271	23.5893	40968844.0
2012-08-20 11:30:00	AAPL	Stock	23.5868	23.7407	23.585	23.7193	54972344.0
2012-08-20 12:00:00	AAPL	Stock	23.7189	23.7411	23.6525	23.6646	49047908.0
2012-08-20 12:30:00	AAPL	Stock	23.6636	23.6754	23.5257	23.6321	57701980.0
2012-08-20 13:00:00	AAPL	Stock	23.6296	23.6857	23.5896	23.6393	27816208.0
2012-08-20 13:30:00	AAPL	Stock	23.6393	23.685	23.5932	23.6706	20929300.0
2012-08-20 14:00:00	AAPL	Stock	23.6729	23.7032	23.63	23.6666	21265272.0
2012-08-20 14:30:00	AAPL	Stock	23.6661	23.6768	23.6386	23.6665	14701484.0
2012-08-20 15:00:00	AAPL	Stock	23.6679	23.7339	23.6361	23.7318	26757024.0
2012-08-20 15:30:00	AAPL	Stock	23.7329	23.7554	23.6732	23.7496	55019916.0
2012-08-20 16:00:00	AAPL	Stock	23.7554	23.7932	23.5647	23.7589	12006372.0
2012-08-20 16:30:00	AAPL	Stock	23.7554	23.7711	23.3519	23.7579	611828.0
2012-08-20 17:00:00	AAPL	Stock	23.7589	23.775	23.7554	23.7732	330820.0
2012-08-20 17:30:00	AAPL	Stock	23.7686	23.7732	23.7654	23.77	261856.0
2012-08-20 18:00:00	AAPL	Stock	23.7696	23.7857	23.7679	23.7839	518980.0
2012-08-20 18:30:00	AAPL	Stock	23.7836	23.8054	23.7836	23.7993	341572.0
2012-08-20 19:00:00	AAPL	Stock	23.7946	23.8	23.7857	23.7868	59136.0
2012-08-20 19:30:00	AAPL	Stock	23.7921	23.8036	23.7793	23.8036	222796.0
2012-08-20 08:00:00	MSFT	Stock	30.86	30.97	30.85	30.9	6310.0
2012-08-20 08:30:00	MSFT	Stock	30.9	30.9	30.85	30.85	1410.0
2012-08-20 09:00:00	MSFT	Stock	30.88	30.9	30.83	30.84	14640.0
2012-08-20 09:30:00	MSFT	Stock	30.83	30.85	30.58	30.64	3313240.0
2012-08-20 10:00:00	MSFT	Stock	30.64	30.725	30.63	30.69	2766799.0
2012-08-20 10:30:00	MSFT	Stock	30.69	30.72	30.64	30.7	1869782.0
2012-08-20 11:00:00	MSFT	Stock	30.7	30.74	30.65	30.69	1405842.0
2012-08-20 11:30:00	MSFT	Stock	30.68	30.74	30.67	30.726	1462154.0
2012-08-20 12:00:00	MSFT	Stock	30.72	30.82	30.72	30.76	1044241.0
2012-08-20 12:30:00	MSFT	Stock	30.76	30.78	30.72	30.76	1066824.0
2012-08-20 13:00:00	MSFT	Stock	30.76	30.77	30.72	30.72	729593.0
2012-08-20 13:30:00	MSFT	Stock	30.72	30.73	30.65	30.68	1259408.0
2012-08-20 14:00:00	MSFT	Stock	30.672	30.74	30.665	30.734	1066093.0
2012-08-20 14:30:00	MSFT	Stock	30.735	30.76	30.7	30.74	1639722.0
2012-08-20 15:00:00	MSFT	Stock	30.745	30.77	30.68	30.765	1478223.0
2012-08-20 15:30:00	MSFT	Stock	30.77	30.79	30.67	30.74	2816647.0
2012-08-20 16:00:00	MSFT	Stock	30.73	30.84	30.667	30.79	1233614.0
2012-08-20 16:30:00	MSFT	Stock	30.74	30.76	30.674	30.76	25422.0

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

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