PREVIEW / stock_30min / 2013-08-20

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-20.parquet
  size:    1.5 MB
  rows:    81,102
  symbols: 3,533

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-08-20 04:00:00	AAPL	Stock	18.2143	18.2143	18.0714	18.0714	40600.0
2013-08-20 04:30:00	AAPL	Stock	18.08	18.08	17.9839	18.0146	64400.0
2013-08-20 05:00:00	AAPL	Stock	18.0146	18.08	18.0146	18.08	22400.0
2013-08-20 05:30:00	AAPL	Stock	18.0786	18.08	18.0632	18.08	41356.0
2013-08-20 06:00:00	AAPL	Stock	18.08	18.1107	18.08	18.1071	35728.0
2013-08-20 06:30:00	AAPL	Stock	18.1086	18.1357	18.1086	18.1357	8400.0
2013-08-20 07:00:00	AAPL	Stock	18.1339	18.2032	18.11	18.1929	297948.0
2013-08-20 07:30:00	AAPL	Stock	18.2	18.2529	18.2	18.2268	379064.0
2013-08-20 08:00:00	AAPL	Stock	18.2357	18.2457	18.1429	18.2221	1426768.0
2013-08-20 08:30:00	AAPL	Stock	18.2232	18.2321	18.1964	18.2118	1131620.0
2013-08-20 09:00:00	AAPL	Stock	18.2143	18.2239	18.1825	18.1911	1976716.0
2013-08-20 09:30:00	AAPL	Stock	18.1911	18.2346	18.0096	18.0354	74738132.0
2013-08-20 10:00:00	AAPL	Stock	18.0354	18.0693	17.8864	17.9739	75531316.0
2013-08-20 10:30:00	AAPL	Stock	17.9714	18.0311	17.94	17.9675	32788728.0
2013-08-20 11:00:00	AAPL	Stock	17.9675	18.0311	17.9593	18.01	16928184.0
2013-08-20 11:30:00	AAPL	Stock	18.0143	18.0482	17.9982	17.9986	16931712.0
2013-08-20 12:00:00	AAPL	Stock	17.9986	18.0179	17.9536	17.9975	12558364.0
2013-08-20 12:30:00	AAPL	Stock	17.9943	18.0064	17.9464	18.0	10953236.0
2013-08-20 13:00:00	AAPL	Stock	18.0011	18.0096	17.9611	17.9643	10417680.0
2013-08-20 13:30:00	AAPL	Stock	17.9682	18.0036	17.9471	17.9914	11634896.0
2013-08-20 14:00:00	AAPL	Stock	17.9895	17.9993	17.9646	17.9893	9564716.0
2013-08-20 14:30:00	AAPL	Stock	17.9871	17.9939	17.9525	17.9668	11035192.0
2013-08-20 15:00:00	AAPL	Stock	17.9682	17.9918	17.9157	17.9479	18493524.0
2013-08-20 15:30:00	AAPL	Stock	17.9443	17.9879	17.8875	17.8961	35978320.0
2013-08-20 16:00:00	AAPL	Stock	17.9028	18.0036	17.895	17.9179	9859920.0
2013-08-20 16:30:00	AAPL	Stock	17.8989	17.9243	17.8989	17.9232	76496.0
2013-08-20 17:00:00	AAPL	Stock	17.9204	17.9321	17.8954	17.9289	346500.0
2013-08-20 17:30:00	AAPL	Stock	17.9318	17.9339	17.9264	17.9336	83972.0
2013-08-20 18:00:00	AAPL	Stock	17.9264	17.9318	17.9264	17.9286	61292.0
2013-08-20 18:30:00	AAPL	Stock	17.9282	17.9296	17.9175	17.9214	93100.0
2013-08-20 19:00:00	AAPL	Stock	17.9161	17.9179	17.9139	17.9139	140168.0
2013-08-20 19:30:00	AAPL	Stock	17.9243	17.9464	17.9168	17.9464	265328.0
2013-08-20 08:30:00	MSFT	Stock	31.44	31.49	31.42	31.49	1800.0
2013-08-20 09:00:00	MSFT	Stock	31.45	31.45	31.42	31.43	1290.0
2013-08-20 09:30:00	MSFT	Stock	31.47	31.78	31.37	31.77	3525387.0
2013-08-20 10:00:00	MSFT	Stock	31.77	31.79	31.6	31.605	2651893.0
2013-08-20 10:30:00	MSFT	Stock	31.6	31.745	31.6	31.67	1826021.0
2013-08-20 11:00:00	MSFT	Stock	31.67	31.85	31.61	31.835	1519616.0
2013-08-20 11:30:00	MSFT	Stock	31.83	31.9	31.79	31.81	1997848.0
2013-08-20 12:00:00	MSFT	Stock	31.81	31.895	31.8	31.865	1094612.0
2013-08-20 12:30:00	MSFT	Stock	31.865	31.87	31.67	31.743	1217376.0
2013-08-20 13:00:00	MSFT	Stock	31.74	31.81	31.65	31.66	789680.0
2013-08-20 13:30:00	MSFT	Stock	31.653	31.7	31.62	31.655	799844.0
2013-08-20 14:00:00	MSFT	Stock	31.654	31.71	31.63	31.71	773032.0
2013-08-20 14:30:00	MSFT	Stock	31.705	31.78	31.68	31.69	1278923.0
2013-08-20 15:00:00	MSFT	Stock	31.69	31.74	31.66	31.74	874352.0
2013-08-20 15:30:00	MSFT	Stock	31.74	31.77	31.6	31.63	2418286.0
2013-08-20 16:00:00	MSFT	Stock	31.62	31.87	31.61	31.63	1666520.0
2013-08-20 16:30:00	MSFT	Stock	31.626	31.739	31.626	31.7	230574.0
2013-08-20 17:00:00	MSFT	Stock	31.7	31.7	31.63	31.63	359.0

> showing 50 of 81,102 rows — these rows as CSV

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