PREVIEW / stock_30min / 2013-04-09

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-09.parquet
  size:    1.5 MB
  rows:    75,718
  symbols: 3,494

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-04-09 05:00:00	AAPL	Stock	15.2668	15.2668	15.2668	15.2668	23772.0
2013-04-09 05:30:00	AAPL	Stock	15.25	15.25	15.25	15.25	8400.0
2013-04-09 06:00:00	AAPL	Stock	15.25	15.25	15.25	15.25	2800.0
2013-04-09 06:30:00	AAPL	Stock	15.2464	15.2464	15.2464	15.2464	2800.0
2013-04-09 07:00:00	AAPL	Stock	15.2464	15.28	15.2464	15.28	71036.0
2013-04-09 07:30:00	AAPL	Stock	15.2696	15.2696	15.2496	15.2521	97048.0
2013-04-09 08:00:00	AAPL	Stock	15.2486	15.28	15.1786	15.2029	621628.0
2013-04-09 08:30:00	AAPL	Stock	15.2029	15.2386	15.1982	15.2364	550340.0
2013-04-09 09:00:00	AAPL	Stock	15.2386	15.2761	15.2286	15.2286	812168.0
2013-04-09 09:30:00	AAPL	Stock	15.2257	15.2493	15.1164	15.1402	40714716.0
2013-04-09 10:00:00	AAPL	Stock	15.1346	15.1693	15.1136	15.145	20905332.0
2013-04-09 10:30:00	AAPL	Stock	15.145	15.1582	15.1193	15.1399	17126676.0
2013-04-09 11:00:00	AAPL	Stock	15.1339	15.1446	15.1043	15.1171	16975112.0
2013-04-09 11:30:00	AAPL	Stock	15.1186	15.1275	15.0982	15.1143	13360284.0
2013-04-09 12:00:00	AAPL	Stock	15.1161	15.1429	15.1032	15.1429	11889808.0
2013-04-09 12:30:00	AAPL	Stock	15.1429	15.1911	15.1421	15.1796	14842072.0
2013-04-09 13:00:00	AAPL	Stock	15.1793	15.3014	15.1743	15.2921	27239716.0
2013-04-09 13:30:00	AAPL	Stock	15.2875	15.3036	15.2357	15.2371	19281192.0
2013-04-09 14:00:00	AAPL	Stock	15.2375	15.2643	15.1964	15.2186	16345812.0
2013-04-09 14:30:00	AAPL	Stock	15.2186	15.2529	15.2071	15.2211	13087676.0
2013-04-09 15:00:00	AAPL	Stock	15.2246	15.2607	15.2186	15.2554	13043660.0
2013-04-09 15:30:00	AAPL	Stock	15.2568	15.2796	15.2068	15.2493	38103464.0
2013-04-09 16:00:00	AAPL	Stock	15.2489	15.2607	15.114	15.2607	34300280.0
2013-04-09 16:30:00	AAPL	Stock	15.2607	15.2679	15.1394	15.2525	271432.0
2013-04-09 17:00:00	AAPL	Stock	15.2543	15.3029	15.2493	15.2632	340872.0
2013-04-09 17:30:00	AAPL	Stock	15.2643	15.2675	15.2582	15.2661	55720.0
2013-04-09 18:00:00	AAPL	Stock	15.2582	15.2696	15.2582	15.2679	180432.0
2013-04-09 18:30:00	AAPL	Stock	15.2671	15.2729	15.2671	15.2679	25060.0
2013-04-09 19:00:00	AAPL	Stock	15.2679	15.2679	15.2643	15.2643	8400.0
2013-04-09 19:30:00	AAPL	Stock	15.2607	15.2711	15.2575	15.2632	76552.0
2013-04-09 07:00:00	MSFT	Stock	28.79	28.85	28.79	28.85	2594.0
2013-04-09 07:30:00	MSFT	Stock	28.72	28.72	28.7	28.7	800.0
2013-04-09 08:00:00	MSFT	Stock	28.7	28.7	28.67	28.67	3000.0
2013-04-09 08:30:00	MSFT	Stock	28.67	28.69	28.67	28.69	3700.0
2013-04-09 09:00:00	MSFT	Stock	28.66	28.74	28.66	28.7	27500.0
2013-04-09 09:30:00	MSFT	Stock	28.7	28.87	28.68	28.795	4246094.0
2013-04-09 10:00:00	MSFT	Stock	28.8	29.06	28.77	28.99	5928217.0
2013-04-09 10:30:00	MSFT	Stock	28.99	29.19	28.945	29.109	5840248.0
2013-04-09 11:00:00	MSFT	Stock	29.105	29.13	28.96	29.09	4184456.0
2013-04-09 11:30:00	MSFT	Stock	29.09	29.25	29.085	29.226	3764996.0
2013-04-09 12:00:00	MSFT	Stock	29.23	29.27	29.21	29.263	2242432.0
2013-04-09 12:30:00	MSFT	Stock	29.265	29.5	29.26	29.485	5648072.0
2013-04-09 13:00:00	MSFT	Stock	29.49	29.815	29.48	29.745	10023040.0
2013-04-09 13:30:00	MSFT	Stock	29.74	29.75	29.47	29.6	6952268.0
2013-04-09 14:00:00	MSFT	Stock	29.6	29.65	29.455	29.614	5520809.0
2013-04-09 14:30:00	MSFT	Stock	29.615	29.73	29.61	29.695	4068287.0
2013-04-09 15:00:00	MSFT	Stock	29.7	29.76	29.625	29.725	5748719.0
2013-04-09 15:30:00	MSFT	Stock	29.72	29.75	29.61	29.638	8833949.0
2013-04-09 16:00:00	MSFT	Stock	29.61	29.659	28.59	29.61	3569256.0
2013-04-09 16:30:00	MSFT	Stock	29.62	29.72	29.61	29.61	125241.0

> showing 50 of 75,718 rows — these rows as CSV

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