PREVIEW / stock_30min / 2013-02-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-04.parquet
  size:    1.5 MB
  rows:    77,171
  symbols: 3,480

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
2013-02-04 04:00:00	AAPL	Stock	16.2218	16.2218	16.2218	16.2218	5600.0
2013-02-04 05:30:00	AAPL	Stock	16.2143	16.2143	16.2143	16.2143	30660.0
2013-02-04 06:00:00	AAPL	Stock	16.2071	16.2071	16.2018	16.2018	19600.0
2013-02-04 06:30:00	AAPL	Stock	16.2264	16.2264	16.1879	16.1879	30716.0
2013-02-04 07:00:00	AAPL	Stock	16.2036	16.2214	16.1407	16.1421	260176.0
2013-02-04 07:30:00	AAPL	Stock	16.1432	16.1857	16.1429	16.1679	272216.0
2013-02-04 08:00:00	AAPL	Stock	16.1879	16.2	16.0268	16.0421	1453508.0
2013-02-04 08:30:00	AAPL	Stock	16.0511	16.1429	16.0507	16.1257	1136828.0
2013-02-04 09:00:00	AAPL	Stock	16.1329	16.2804	16.125	16.2146	3257576.0
2013-02-04 09:30:00	AAPL	Stock	16.2121	16.2836	16.0825	16.0865	64387204.0
2013-02-04 10:00:00	AAPL	Stock	16.0843	16.1189	16.0446	16.0886	42043008.0
2013-02-04 10:30:00	AAPL	Stock	16.0811	16.1561	16.0639	16.1227	34609344.0
2013-02-04 11:00:00	AAPL	Stock	16.1168	16.1346	16.0261	16.0361	29861916.0
2013-02-04 11:30:00	AAPL	Stock	16.0368	16.0404	15.9232	15.9329	50855728.0
2013-02-04 12:00:00	AAPL	Stock	15.9371	15.9707	15.8804	15.9318	37711128.0
2013-02-04 12:30:00	AAPL	Stock	15.9343	15.9529	15.845	15.8659	27364428.0
2013-02-04 13:00:00	AAPL	Stock	15.8636	15.9204	15.8516	15.8811	19901336.0
2013-02-04 13:30:00	AAPL	Stock	15.8836	15.8982	15.815	15.8479	23413712.0
2013-02-04 14:00:00	AAPL	Stock	15.8477	15.9279	15.8321	15.9209	24947524.0
2013-02-04 14:30:00	AAPL	Stock	15.9161	15.9268	15.8721	15.8764	18088868.0
2013-02-04 15:00:00	AAPL	Stock	15.8782	15.8907	15.8361	15.8546	23488080.0
2013-02-04 15:30:00	AAPL	Stock	15.8544	15.8604	15.7857	15.7936	47997432.0
2013-02-04 16:00:00	AAPL	Stock	15.7932	15.9819	15.7901	15.8007	12297600.0
2013-02-04 16:30:00	AAPL	Stock	15.7932	16.2215	15.7524	16.2215	1487108.0
2013-02-04 17:00:00	AAPL	Stock	15.7964	16.2007	15.7875	15.7907	160580.0
2013-02-04 17:30:00	AAPL	Stock	15.7946	15.7946	15.7643	15.775	353584.0
2013-02-04 18:00:00	AAPL	Stock	15.7714	15.7964	15.7696	15.7957	144368.0
2013-02-04 18:30:00	AAPL	Stock	15.7971	15.8007	15.7929	15.7943	137508.0
2013-02-04 19:00:00	AAPL	Stock	15.7964	15.8029	15.7946	15.7964	129612.0
2013-02-04 19:30:00	AAPL	Stock	15.8018	15.8018	15.7875	15.7946	145824.0
2013-02-04 08:00:00	MSFT	Stock	27.92	27.92	27.73	27.74	22567.0
2013-02-04 08:30:00	MSFT	Stock	27.79	27.79	27.7	27.72	8455.0
2013-02-04 09:00:00	MSFT	Stock	27.72	27.92	27.72	27.92	33581.0
2013-02-04 09:30:00	MSFT	Stock	27.92	28.02	27.51	27.86	6909186.0
2013-02-04 10:00:00	MSFT	Stock	27.855	27.87	27.75	27.85	2608720.0
2013-02-04 10:30:00	MSFT	Stock	27.86	27.86	27.74	27.762	2577356.0
2013-02-04 11:00:00	MSFT	Stock	27.765	27.84	27.74	27.75	3464454.0
2013-02-04 11:30:00	MSFT	Stock	27.75	27.755	27.6	27.64	4711270.0
2013-02-04 12:00:00	MSFT	Stock	27.64	27.675	27.55	27.638	3370723.0
2013-02-04 12:30:00	MSFT	Stock	27.64	27.645	27.57	27.579	2605699.0
2013-02-04 13:00:00	MSFT	Stock	27.57	27.6	27.51	27.51	1995424.0
2013-02-04 13:30:00	MSFT	Stock	27.52	27.55	27.49	27.53	2860039.0
2013-02-04 14:00:00	MSFT	Stock	27.54	27.58	27.51	27.56	2968762.0
2013-02-04 14:30:00	MSFT	Stock	27.56	27.61	27.52	27.59	2239837.0
2013-02-04 15:00:00	MSFT	Stock	27.59	27.6	27.525	27.545	2120832.0
2013-02-04 15:30:00	MSFT	Stock	27.545	27.56	27.42	27.425	6457269.0
2013-02-04 16:00:00	MSFT	Stock	27.43	27.665	27.424	27.48	4962939.0
2013-02-04 16:30:00	MSFT	Stock	27.43	27.545	27.43	27.47	347707.0
2013-02-04 17:00:00	MSFT	Stock	27.48	27.93	27.47	27.48	8824.0
2013-02-04 17:30:00	MSFT	Stock	27.48	27.55	27.48	27.54	9100.0

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

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