PREVIEW / stock_30min / 2013-07-16

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-16.parquet
  size:    1.5 MB
  rows:    77,335
  symbols: 3,497

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-16 04:00:00	AAPL	Stock	15.2786	15.2786	15.2786	15.2786	7140.0
2013-07-16 06:00:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	2800.0
2013-07-16 07:00:00	AAPL	Stock	15.2475	15.3	15.2475	15.2657	34048.0
2013-07-16 07:30:00	AAPL	Stock	15.2607	15.2607	15.2457	15.2457	8400.0
2013-07-16 08:00:00	AAPL	Stock	15.2432	15.25	15.2357	15.2493	245672.0
2013-07-16 08:30:00	AAPL	Stock	15.25	15.25	15.2304	15.2464	501004.0
2013-07-16 09:00:00	AAPL	Stock	15.2457	15.2457	15.2154	15.2339	815724.0
2013-07-16 09:30:00	AAPL	Stock	15.2329	15.3121	15.1489	15.2239	41620852.0
2013-07-16 10:00:00	AAPL	Stock	15.2279	15.2775	15.19	15.2214	23574544.0
2013-07-16 10:30:00	AAPL	Stock	15.2196	15.2709	15.2114	15.2332	10950548.0
2013-07-16 11:00:00	AAPL	Stock	15.2326	15.2675	15.2232	15.2321	12893552.0
2013-07-16 11:30:00	AAPL	Stock	15.2279	15.2657	15.225	15.2504	7283052.0
2013-07-16 12:00:00	AAPL	Stock	15.2504	15.3171	15.245	15.2857	13197548.0
2013-07-16 12:30:00	AAPL	Stock	15.2882	15.31	15.275	15.3036	6990424.0
2013-07-16 13:00:00	AAPL	Stock	15.3054	15.3339	15.2886	15.3232	13590108.0
2013-07-16 13:30:00	AAPL	Stock	15.3229	15.3554	15.3154	15.3543	10849356.0
2013-07-16 14:00:00	AAPL	Stock	15.3543	15.3589	15.3054	15.315	11186616.0
2013-07-16 14:30:00	AAPL	Stock	15.315	15.3418	15.3086	15.3293	6918184.0
2013-07-16 15:00:00	AAPL	Stock	15.3293	15.3714	15.3075	15.3682	17359216.0
2013-07-16 15:30:00	AAPL	Stock	15.3696	15.3825	15.3572	15.3675	25501504.0
2013-07-16 16:00:00	AAPL	Stock	15.3675	15.375	15.2232	15.3607	7898184.0
2013-07-16 16:30:00	AAPL	Stock	15.3636	15.3675	15.2885	15.3546	1101660.0
2013-07-16 17:00:00	AAPL	Stock	15.3571	15.3643	15.3571	15.3629	1542324.0
2013-07-16 17:30:00	AAPL	Stock	15.3554	15.3571	15.3554	15.3571	20888.0
2013-07-16 18:00:00	AAPL	Stock	15.3632	15.3632	15.3589	15.3604	16800.0
2013-07-16 18:30:00	AAPL	Stock	15.3632	15.3646	15.3593	15.3646	36400.0
2013-07-16 19:00:00	AAPL	Stock	15.3593	15.3611	15.3268	15.3571	115528.0
2013-07-16 19:30:00	AAPL	Stock	15.3536	15.3536	15.3218	15.3407	233520.0
2013-07-16 08:00:00	MSFT	Stock	36.1	36.2	36.1	36.1	10733.0
2013-07-16 08:30:00	MSFT	Stock	36.17	36.17	36.17	36.17	251300.0
2013-07-16 09:00:00	MSFT	Stock	36.11	36.15	35.98	36.01	138365.0
2013-07-16 09:30:00	MSFT	Stock	36.01	36.2	35.96	36.17	4749707.0
2013-07-16 10:00:00	MSFT	Stock	36.17	36.3	36.15	36.28	2918420.0
2013-07-16 10:30:00	MSFT	Stock	36.28	36.32	36.22	36.24	2094675.0
2013-07-16 11:00:00	MSFT	Stock	36.24	36.24	36.11	36.16	2887405.0
2013-07-16 11:30:00	MSFT	Stock	36.16	36.25	36.15	36.25	2888685.0
2013-07-16 12:00:00	MSFT	Stock	36.24	36.29	36.22	36.24	1556572.0
2013-07-16 12:30:00	MSFT	Stock	36.243	36.25	36.19	36.245	1394367.0
2013-07-16 13:00:00	MSFT	Stock	36.24	36.31	36.24	36.26	1671216.0
2013-07-16 13:30:00	MSFT	Stock	36.27	36.43	36.25	36.37	1895055.0
2013-07-16 14:00:00	MSFT	Stock	36.373	36.42	36.3	36.33	2149144.0
2013-07-16 14:30:00	MSFT	Stock	36.34	36.35	36.25	36.26	1640184.0
2013-07-16 15:00:00	MSFT	Stock	36.26	36.27	36.15	36.25	2285300.0
2013-07-16 15:30:00	MSFT	Stock	36.25	36.31	36.25	36.255	5075891.0
2013-07-16 16:00:00	MSFT	Stock	36.3	36.31	36.122	36.25	2285521.0
2013-07-16 16:30:00	MSFT	Stock	36.27	36.27	36.25	36.25	52387.0
2013-07-16 17:00:00	MSFT	Stock	36.26	36.26	36.24	36.24	280.0
2013-07-16 17:30:00	MSFT	Stock	36.32	36.32	36.32	36.32	100.0
2013-07-16 18:30:00	MSFT	Stock	36.27	36.27	36.27	36.27	100.0
2013-07-16 19:30:00	MSFT	Stock	36.29	36.29	36.29	36.29	100.0

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

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