PREVIEW / stock_30min / 2013-04-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-22.parquet
  size:    1.4 MB
  rows:    76,318
  symbols: 3,479

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-22 04:00:00	AAPL	Stock	13.9639	13.9639	13.9639	13.9639	2800.0
2013-04-22 04:30:00	AAPL	Stock	13.9625	13.9643	13.9625	13.9643	5600.0
2013-04-22 05:00:00	AAPL	Stock	13.9679	13.9732	13.9679	13.9732	5600.0
2013-04-22 05:30:00	AAPL	Stock	14.0104	14.0143	14.0104	14.0143	33852.0
2013-04-22 06:00:00	AAPL	Stock	14.0186	14.0186	14.0186	14.0186	2800.0
2013-04-22 06:30:00	AAPL	Stock	14.0075	14.0179	14.0054	14.0171	19600.0
2013-04-22 07:00:00	AAPL	Stock	14.0071	14.0121	13.9875	13.9979	96292.0
2013-04-22 07:30:00	AAPL	Stock	13.9996	13.9996	13.8425	13.8932	559104.0
2013-04-22 08:00:00	AAPL	Stock	13.8932	14.0225	13.8571	14.0179	2501576.0
2013-04-22 08:30:00	AAPL	Stock	14.0071	14.0232	13.9714	13.9979	1668436.0
2013-04-22 09:00:00	AAPL	Stock	13.9986	14.0829	13.9857	14.0304	2051700.0
2013-04-22 09:30:00	AAPL	Stock	14.0229	14.2071	13.9741	14.1904	70447188.0
2013-04-22 10:00:00	AAPL	Stock	14.1861	14.1964	14.0478	14.0925	40704636.0
2013-04-22 10:30:00	AAPL	Stock	14.0962	14.1229	14.0539	14.1195	24683036.0
2013-04-22 11:00:00	AAPL	Stock	14.1168	14.2093	14.0886	14.1964	32864580.0
2013-04-22 11:30:00	AAPL	Stock	14.1968	14.2243	14.1307	14.1693	31224144.0
2013-04-22 12:00:00	AAPL	Stock	14.1714	14.1993	14.1339	14.1437	16876720.0
2013-04-22 12:30:00	AAPL	Stock	14.1429	14.1759	14.1368	14.1386	11094496.0
2013-04-22 13:00:00	AAPL	Stock	14.1371	14.1425	14.1	14.1214	13416704.0
2013-04-22 13:30:00	AAPL	Stock	14.1215	14.1686	14.1196	14.1593	13511568.0
2013-04-22 14:00:00	AAPL	Stock	14.1607	14.2086	14.1575	14.2036	18313568.0
2013-04-22 14:30:00	AAPL	Stock	14.2004	14.2993	14.2004	14.2911	37166948.0
2013-04-22 15:00:00	AAPL	Stock	14.2907	14.3089	14.2443	14.3026	25509484.0
2013-04-22 15:30:00	AAPL	Stock	14.3021	14.3643	14.2321	14.2386	51214100.0
2013-04-22 16:00:00	AAPL	Stock	14.2382	14.3049	14.1614	14.2239	9424744.0
2013-04-22 16:30:00	AAPL	Stock	14.2236	14.3052	14.0746	14.2429	1294888.0
2013-04-22 17:00:00	AAPL	Stock	14.2436	14.2857	14.2382	14.2679	983052.0
2013-04-22 17:30:00	AAPL	Stock	14.2686	14.2768	14.2625	14.2757	309848.0
2013-04-22 18:00:00	AAPL	Stock	14.2761	14.2768	14.25	14.25	223160.0
2013-04-22 18:30:00	AAPL	Stock	14.2464	14.2607	14.2386	14.2604	57232.0
2013-04-22 19:00:00	AAPL	Stock	14.2607	14.2657	14.2464	14.2518	153132.0
2013-04-22 19:30:00	AAPL	Stock	14.2536	14.2568	14.2361	14.2393	130956.0
2013-04-22 08:00:00	MSFT	Stock	29.5	29.8	29.5	29.8	4527.0
2013-04-22 08:30:00	MSFT	Stock	29.86	29.86	29.8	29.82	6590.0
2013-04-22 09:00:00	MSFT	Stock	29.8	30.75	29.8	30.32	2430548.0
2013-04-22 09:30:00	MSFT	Stock	30.32	31.15	30.27	31.08	33399544.0
2013-04-22 10:00:00	MSFT	Stock	31.085	31.18	30.8	30.85	13807999.0
2013-04-22 10:30:00	MSFT	Stock	30.85	30.99	30.8	30.93	6753653.0
2013-04-22 11:00:00	MSFT	Stock	30.93	30.94	30.8	30.815	3923484.0
2013-04-22 11:30:00	MSFT	Stock	30.815	30.84	30.68	30.775	6440146.0
2013-04-22 12:00:00	MSFT	Stock	30.775	30.96	30.76	30.945	6104626.0
2013-04-22 12:30:00	MSFT	Stock	30.945	31.0	30.9	30.96	6776208.0
2013-04-22 13:00:00	MSFT	Stock	30.96	31.01	30.92	30.965	6045484.0
2013-04-22 13:30:00	MSFT	Stock	30.96	31.02	30.94	30.965	5323389.0
2013-04-22 14:00:00	MSFT	Stock	30.96	31.0	30.96	30.995	5402871.0
2013-04-22 14:30:00	MSFT	Stock	31.0	31.05	30.95	30.96	8192659.0
2013-04-22 15:00:00	MSFT	Stock	30.965	30.99	30.83	30.932	4913380.0
2013-04-22 15:30:00	MSFT	Stock	30.93	30.99	30.8	30.81	16679362.0
2013-04-22 16:00:00	MSFT	Stock	30.81	30.911	30.75	30.8	7887790.0
2013-04-22 16:30:00	MSFT	Stock	30.8	31.01	30.78	30.85	174571.0

> showing 50 of 76,318 rows — these rows as CSV

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