PREVIEW / stock_30min / 2012-12-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-05.parquet
  size:    1.4 MB
  rows:    75,535
  symbols: 3,475

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
2012-12-05 04:00:00	AAPL	Stock	20.5	20.5	20.4018	20.4214	70868.0
2012-12-05 04:30:00	AAPL	Stock	20.3611	20.3929	20.3214	20.3218	66444.0
2012-12-05 05:00:00	AAPL	Stock	20.3018	20.3393	20.2968	20.3393	25200.0
2012-12-05 05:30:00	AAPL	Stock	20.3525	20.3571	20.3032	20.3214	29484.0
2012-12-05 06:00:00	AAPL	Stock	20.3214	20.3571	20.3214	20.3293	34524.0
2012-12-05 06:30:00	AAPL	Stock	20.3346	20.3604	20.3293	20.3604	86772.0
2012-12-05 07:00:00	AAPL	Stock	20.3414	20.3804	20.3143	20.3571	412580.0
2012-12-05 07:30:00	AAPL	Stock	20.3464	20.3839	20.3357	20.375	479332.0
2012-12-05 08:00:00	AAPL	Stock	20.3807	20.3857	20.2446	20.3489	3111528.0
2012-12-05 08:30:00	AAPL	Stock	20.3393	20.3821	20.3236	20.3571	1496908.0
2012-12-05 09:00:00	AAPL	Stock	20.3625	20.4371	20.3179	20.3236	3287592.0
2012-12-05 09:30:00	AAPL	Stock	20.3182	20.3307	19.9146	19.965	144752524.0
2012-12-05 10:00:00	AAPL	Stock	19.9654	20.0054	19.7589	19.7632	110832344.0
2012-12-05 10:30:00	AAPL	Stock	19.7618	19.7625	19.4843	19.5786	156231068.0
2012-12-05 11:00:00	AAPL	Stock	19.5843	19.8214	19.5396	19.7679	93017176.0
2012-12-05 11:30:00	AAPL	Stock	19.7729	19.8371	19.5871	19.7304	60603564.0
2012-12-05 12:00:00	AAPL	Stock	19.7307	19.7936	19.6286	19.6368	44662716.0
2012-12-05 12:30:00	AAPL	Stock	19.6361	19.7536	19.6286	19.7014	25924556.0
2012-12-05 13:00:00	AAPL	Stock	19.7018	19.7393	19.6071	19.6546	28427476.0
2012-12-05 13:30:00	AAPL	Stock	19.6543	19.6711	19.5368	19.5368	35837704.0
2012-12-05 14:00:00	AAPL	Stock	19.5384	19.6907	19.5368	19.6086	40572952.0
2012-12-05 14:30:00	AAPL	Stock	19.6128	19.6332	19.5293	19.5585	37972032.0
2012-12-05 15:00:00	AAPL	Stock	19.5589	19.71	19.5464	19.5921	58264472.0
2012-12-05 15:30:00	AAPL	Stock	19.5895	19.5989	19.2418	19.2429	137190816.0
2012-12-05 16:00:00	AAPL	Stock	19.243	19.7138	19.1811	19.2289	30020760.0
2012-12-05 16:30:00	AAPL	Stock	19.2289	19.6795	19.1882	19.1968	2220120.0
2012-12-05 17:00:00	AAPL	Stock	19.2054	19.3922	19.1393	19.1618	1866172.0
2012-12-05 17:30:00	AAPL	Stock	19.1536	19.2432	19.1429	19.1582	3320520.0
2012-12-05 18:00:00	AAPL	Stock	19.1521	19.1711	19.1507	19.1679	398972.0
2012-12-05 18:30:00	AAPL	Stock	19.1607	19.1736	19.1571	19.1732	548408.0
2012-12-05 19:00:00	AAPL	Stock	19.1675	19.1746	19.1607	19.1679	184128.0
2012-12-05 19:30:00	AAPL	Stock	19.1707	19.1732	19.1411	19.1429	725424.0
2012-12-05 06:30:00	MSFT	Stock	26.49	26.52	26.49	26.52	1000.0
2012-12-05 07:00:00	MSFT	Stock	26.49	26.49	26.38	26.43	4500.0
2012-12-05 07:30:00	MSFT	Stock	26.43	26.45	26.43	26.45	4800.0
2012-12-05 08:00:00	MSFT	Stock	26.42	26.45	26.39	26.45	17808.0
2012-12-05 08:30:00	MSFT	Stock	26.45	26.45	26.43	26.45	15550.0
2012-12-05 09:00:00	MSFT	Stock	26.45	26.45	26.37	26.4	108791.0
2012-12-05 09:30:00	MSFT	Stock	26.4	26.49	26.35	26.43	5766162.0
2012-12-05 10:00:00	MSFT	Stock	26.43	26.45	26.37	26.38	4811047.0
2012-12-05 10:30:00	MSFT	Stock	26.38	26.41	26.26	26.32	4380840.0
2012-12-05 11:00:00	MSFT	Stock	26.31	26.36	26.3	26.3	3255984.0
2012-12-05 11:30:00	MSFT	Stock	26.305	26.525	26.3	26.48	4429756.0
2012-12-05 12:00:00	MSFT	Stock	26.48	26.72	26.48	26.67	5425080.0
2012-12-05 12:30:00	MSFT	Stock	26.673	26.93	26.67	26.75	5556456.0
2012-12-05 13:00:00	MSFT	Stock	26.755	26.755	26.68	26.7	2331528.0
2012-12-05 13:30:00	MSFT	Stock	26.7	26.745	26.68	26.68	1890307.0
2012-12-05 14:00:00	MSFT	Stock	26.69	26.73	26.66	26.72	2176205.0
2012-12-05 14:30:00	MSFT	Stock	26.72	26.76	26.71	26.74	2272740.0
2012-12-05 15:00:00	MSFT	Stock	26.73	26.85	26.72	26.74	3367339.0

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

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