PREVIEW / stock_30min / 2012-05-31

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-31.parquet
  size:    1.5 MB
  rows:    77,980
  symbols: 3,548

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-05-31 04:00:00	AAPL	Stock	20.7321	20.7321	20.6786	20.6786	14000.0
2012-05-31 04:30:00	AAPL	Stock	20.6786	20.7036	20.6786	20.7036	16800.0
2012-05-31 05:00:00	AAPL	Stock	20.7321	20.7429	20.7143	20.7143	44100.0
2012-05-31 05:30:00	AAPL	Stock	20.7321	20.7732	20.7143	20.7679	61600.0
2012-05-31 06:00:00	AAPL	Stock	20.7679	20.7679	20.7679	20.7679	11200.0
2012-05-31 06:30:00	AAPL	Stock	20.7457	20.7457	20.7268	20.7268	22680.0
2012-05-31 07:00:00	AAPL	Stock	20.7268	20.775	20.7268	20.7357	282352.0
2012-05-31 07:30:00	AAPL	Stock	20.7364	20.7411	20.7232	20.74	423416.0
2012-05-31 08:00:00	AAPL	Stock	20.7407	20.8125	20.6846	20.7889	3730972.0
2012-05-31 08:30:00	AAPL	Stock	20.7889	20.8071	20.6846	20.7893	2947448.0
2012-05-31 09:00:00	AAPL	Stock	20.795	20.8	20.7357	20.7446	1861832.0
2012-05-31 09:30:00	AAPL	Stock	20.74	20.7679	20.5621	20.6068	69660976.0
2012-05-31 10:00:00	AAPL	Stock	20.6011	20.6161	20.4093	20.5161	63309932.0
2012-05-31 10:30:00	AAPL	Stock	20.5121	20.5971	20.4936	20.5546	36103592.0
2012-05-31 11:00:00	AAPL	Stock	20.5494	20.5846	20.4982	20.5757	24008432.0
2012-05-31 11:30:00	AAPL	Stock	20.5732	20.6325	20.5611	20.5841	27840008.0
2012-05-31 12:00:00	AAPL	Stock	20.5821	20.7304	20.5643	20.7011	32280808.0
2012-05-31 12:30:00	AAPL	Stock	20.7007	20.7129	20.6507	20.6715	22048124.0
2012-05-31 13:00:00	AAPL	Stock	20.6714	20.7329	20.6625	20.6811	29839516.0
2012-05-31 13:30:00	AAPL	Stock	20.6807	20.7	20.56	20.5875	24206420.0
2012-05-31 14:00:00	AAPL	Stock	20.5875	20.6843	20.5764	20.6721	23029328.0
2012-05-31 14:30:00	AAPL	Stock	20.6705	20.6732	20.6071	20.6529	14929404.0
2012-05-31 15:00:00	AAPL	Stock	20.6575	20.7218	20.625	20.7028	27985720.0
2012-05-31 15:30:00	AAPL	Stock	20.7029	20.7396	20.625	20.6268	55387164.0
2012-05-31 16:00:00	AAPL	Stock	20.6254	20.7098	20.5989	20.6374	21703836.0
2012-05-31 16:30:00	AAPL	Stock	20.6089	20.7064	20.6071	20.6114	2142308.0
2012-05-31 17:00:00	AAPL	Stock	20.6118	20.6332	20.5554	20.5786	769468.0
2012-05-31 17:30:00	AAPL	Stock	20.5779	20.5786	20.5682	20.5711	123228.0
2012-05-31 18:00:00	AAPL	Stock	20.5775	20.5868	20.5714	20.5714	104412.0
2012-05-31 18:30:00	AAPL	Stock	20.6332	20.6332	20.58	20.5821	64120.0
2012-05-31 19:00:00	AAPL	Stock	20.5871	20.5886	20.5821	20.5875	53984.0
2012-05-31 19:30:00	AAPL	Stock	20.5807	20.5907	20.5764	20.5793	118020.0
2012-05-31 08:00:00	MSFT	Stock	29.34	29.39	29.34	29.38	16099.0
2012-05-31 08:30:00	MSFT	Stock	29.35	29.35	29.3	29.31	1325.0
2012-05-31 09:00:00	MSFT	Stock	29.35	29.35	29.28	29.28	7508.0
2012-05-31 09:30:00	MSFT	Stock	29.3	29.35	29.01	29.04	3980640.0
2012-05-31 10:00:00	MSFT	Stock	29.04	29.1	28.95	29.053	3796554.0
2012-05-31 10:30:00	MSFT	Stock	29.05	29.13	29.0	29.04	2422128.0
2012-05-31 11:00:00	MSFT	Stock	29.036	29.09	28.94	29.08	1735372.0
2012-05-31 11:30:00	MSFT	Stock	29.085	29.208	29.07	29.16	1718712.0
2012-05-31 12:00:00	MSFT	Stock	29.16	29.32	29.11	29.28	1780854.0
2012-05-31 12:30:00	MSFT	Stock	29.28	29.33	29.24	29.305	1248593.0
2012-05-31 13:00:00	MSFT	Stock	29.3	29.42	29.29	29.314	1751068.0
2012-05-31 13:30:00	MSFT	Stock	29.32	29.32	29.14	29.18	1416117.0
2012-05-31 14:00:00	MSFT	Stock	29.18	29.3	29.17	29.22	1748678.0
2012-05-31 14:30:00	MSFT	Stock	29.215	29.3	29.16	29.27	1616908.0
2012-05-31 15:00:00	MSFT	Stock	29.26	29.4	29.2	29.37	2260212.0
2012-05-31 15:30:00	MSFT	Stock	29.37	29.38	29.19	29.2	6789620.0
2012-05-31 16:00:00	MSFT	Stock	29.2	29.22	29.12	29.188	5715495.0
2012-05-31 16:30:00	MSFT	Stock	29.196	29.264	29.12	29.15	613445.0

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

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