PREVIEW / stock_30min / 2013-07-01

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-01.parquet
  size:    1.5 MB
  rows:    79,144
  symbols: 3,507

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-07-01 04:00:00	AAPL	Stock	14.2311	14.2543	14.2193	14.2193	28000.0
2013-07-01 05:00:00	AAPL	Stock	14.2143	14.2143	14.2107	14.2107	8400.0
2013-07-01 05:30:00	AAPL	Stock	14.2393	14.2482	14.2321	14.2321	68880.0
2013-07-01 06:00:00	AAPL	Stock	14.2321	14.2321	14.2321	14.2321	8400.0
2013-07-01 06:30:00	AAPL	Stock	14.2411	14.2857	14.2411	14.2857	126168.0
2013-07-01 07:00:00	AAPL	Stock	14.2854	14.375	14.2768	14.3339	1001448.0
2013-07-01 07:30:00	AAPL	Stock	14.335	14.3821	14.335	14.375	548212.0
2013-07-01 08:00:00	AAPL	Stock	14.3668	14.3929	14.1193	14.3643	1562820.0
2013-07-01 08:30:00	AAPL	Stock	14.3661	14.3661	14.3307	14.3518	681520.0
2013-07-01 09:00:00	AAPL	Stock	14.3518	14.3993	14.3471	14.3814	1947512.0
2013-07-01 09:30:00	AAPL	Stock	14.3818	14.515	14.3293	14.4807	67698176.0
2013-07-01 10:00:00	AAPL	Stock	14.4846	14.5475	14.4729	14.5146	36945076.0
2013-07-01 10:30:00	AAPL	Stock	14.515	14.5861	14.5054	14.5835	24963708.0
2013-07-01 11:00:00	AAPL	Stock	14.5832	14.5979	14.5275	14.5832	22557276.0
2013-07-01 11:30:00	AAPL	Stock	14.5825	14.6493	14.5718	14.6357	25433464.0
2013-07-01 12:00:00	AAPL	Stock	14.6357	14.6839	14.6321	14.6411	27115760.0
2013-07-01 12:30:00	AAPL	Stock	14.6425	14.6979	14.6179	14.6846	20283312.0
2013-07-01 13:00:00	AAPL	Stock	14.6838	14.6896	14.6439	14.6586	12944848.0
2013-07-01 13:30:00	AAPL	Stock	14.6568	14.71	14.6304	14.6388	18196276.0
2013-07-01 14:00:00	AAPL	Stock	14.6404	14.6682	14.6204	14.6496	15967980.0
2013-07-01 14:30:00	AAPL	Stock	14.6475	14.7196	14.6293	14.7054	20528704.0
2013-07-01 15:00:00	AAPL	Stock	14.7032	14.7239	14.6657	14.6743	19467896.0
2013-07-01 15:30:00	AAPL	Stock	14.6696	14.6696	14.5761	14.615	39941272.0
2013-07-01 16:00:00	AAPL	Stock	14.615	14.6542	14.5986	14.6043	18910892.0
2013-07-01 16:30:00	AAPL	Stock	14.6121	14.669	14.6032	14.6089	740320.0
2013-07-01 17:00:00	AAPL	Stock	14.6129	14.6164	14.6111	14.6164	338492.0
2013-07-01 17:30:00	AAPL	Stock	14.6164	14.6164	14.6143	14.6143	28588.0
2013-07-01 18:00:00	AAPL	Stock	14.6125	14.6164	14.6071	14.6075	83832.0
2013-07-01 18:30:00	AAPL	Stock	14.6111	14.6161	14.6107	14.6161	55440.0
2013-07-01 19:00:00	AAPL	Stock	14.6157	14.6171	14.6157	14.6171	23576.0
2013-07-01 19:30:00	AAPL	Stock	14.6229	14.6304	14.6196	14.6254	35700.0
2013-07-01 08:00:00	MSFT	Stock	34.58	34.63	34.54	34.62	7740.0
2013-07-01 08:30:00	MSFT	Stock	34.62	34.67	34.61	34.63	5100.0
2013-07-01 09:00:00	MSFT	Stock	34.62	34.75	34.61	34.73	6920.0
2013-07-01 09:30:00	MSFT	Stock	34.75	34.88	34.68	34.84	4479214.0
2013-07-01 10:00:00	MSFT	Stock	34.845	34.99	34.84	34.9	2453929.0
2013-07-01 10:30:00	MSFT	Stock	34.905	34.91	34.79	34.803	1997136.0
2013-07-01 11:00:00	MSFT	Stock	34.8	34.8	34.59	34.65	2256774.0
2013-07-01 11:30:00	MSFT	Stock	34.66	34.72	34.65	34.658	1742574.0
2013-07-01 12:00:00	MSFT	Stock	34.655	34.67	34.48	34.52	1462495.0
2013-07-01 12:30:00	MSFT	Stock	34.53	34.55	34.47	34.53	1357831.0
2013-07-01 13:00:00	MSFT	Stock	34.525	34.54	34.4	34.505	1753544.0
2013-07-01 13:30:00	MSFT	Stock	34.5	34.55	34.38	34.44	1679948.0
2013-07-01 14:00:00	MSFT	Stock	34.435	34.52	34.4	34.49	1489751.0
2013-07-01 14:30:00	MSFT	Stock	34.5	34.58	34.44	34.545	1273604.0
2013-07-01 15:00:00	MSFT	Stock	34.545	34.58	34.43	34.435	1371462.0
2013-07-01 15:30:00	MSFT	Stock	34.43	34.435	34.33	34.36	3883162.0
2013-07-01 16:00:00	MSFT	Stock	34.36	34.59	34.3	34.3	3406289.0
2013-07-01 16:30:00	MSFT	Stock	34.3	34.776	34.3	34.35	157341.0
2013-07-01 17:00:00	MSFT	Stock	34.35	34.35	34.35	34.35	1500.0

> showing 50 of 79,144 rows — these rows as CSV

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