PREVIEW / stock_30min / 2014-01-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-07.parquet
  size:    1.6 MB
  rows:    81,435
  symbols: 3,530

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
2014-01-07 04:00:00	AAPL	Stock	19.4446	19.4446	19.4446	19.4446	13300.0
2014-01-07 04:30:00	AAPL	Stock	19.4643	19.4643	19.4643	19.4643	2800.0
2014-01-07 05:00:00	AAPL	Stock	19.4764	19.4839	19.4746	19.4839	22568.0
2014-01-07 05:30:00	AAPL	Stock	19.4839	19.4839	19.4436	19.4436	40768.0
2014-01-07 06:00:00	AAPL	Stock	19.4957	19.4964	19.4882	19.4882	11200.0
2014-01-07 06:30:00	AAPL	Stock	19.4654	19.4732	19.4618	19.4732	39200.0
2014-01-07 07:00:00	AAPL	Stock	19.475	19.4925	19.475	19.4825	56560.0
2014-01-07 07:30:00	AAPL	Stock	19.4832	19.4964	19.4721	19.4846	147084.0
2014-01-07 08:00:00	AAPL	Stock	19.4925	19.4992	19.4554	19.4679	912128.0
2014-01-07 08:30:00	AAPL	Stock	19.4661	19.4786	19.4575	19.4643	954184.0
2014-01-07 09:00:00	AAPL	Stock	19.4646	19.4661	19.4164	19.4318	1032920.0
2014-01-07 09:30:00	AAPL	Stock	19.44	19.4454	19.2825	19.3671	54764892.0
2014-01-07 10:00:00	AAPL	Stock	19.3714	19.4986	19.3671	19.4336	35592228.0
2014-01-07 10:30:00	AAPL	Stock	19.4345	19.4696	19.3771	19.3997	13547940.0
2014-01-07 11:00:00	AAPL	Stock	19.405	19.4171	19.325	19.3483	11950148.0
2014-01-07 11:30:00	AAPL	Stock	19.35	19.3661	19.3107	19.32	11143132.0
2014-01-07 12:00:00	AAPL	Stock	19.3168	19.3359	19.285	19.3136	10869404.0
2014-01-07 12:30:00	AAPL	Stock	19.3127	19.3464	19.2939	19.3204	7116648.0
2014-01-07 13:00:00	AAPL	Stock	19.3219	19.3279	19.2946	19.3206	6605284.0
2014-01-07 13:30:00	AAPL	Stock	19.3214	19.3354	19.2543	19.2723	15856708.0
2014-01-07 14:00:00	AAPL	Stock	19.2754	19.2964	19.2116	19.2425	21798028.0
2014-01-07 14:30:00	AAPL	Stock	19.2429	19.3029	19.2393	19.2961	14108780.0
2014-01-07 15:00:00	AAPL	Stock	19.2964	19.33	19.2839	19.3184	12207664.0
2014-01-07 15:30:00	AAPL	Stock	19.3182	19.3407	19.2704	19.2868	26707660.0
2014-01-07 16:00:00	AAPL	Stock	19.2904	19.336	19.2607	19.2821	14994280.0
2014-01-07 16:30:00	AAPL	Stock	19.2818	19.3143	19.2732	19.2732	226296.0
2014-01-07 17:00:00	AAPL	Stock	19.2739	19.2904	19.2696	19.2782	1229144.0
2014-01-07 17:30:00	AAPL	Stock	19.2782	19.2782	19.2686	19.2696	59528.0
2014-01-07 18:00:00	AAPL	Stock	19.2696	19.2904	19.2286	19.2293	144424.0
2014-01-07 18:30:00	AAPL	Stock	19.2332	19.2393	19.2321	19.2321	30800.0
2014-01-07 19:00:00	AAPL	Stock	19.2343	19.2429	19.2339	19.2339	28532.0
2014-01-07 19:30:00	AAPL	Stock	19.24	19.25	19.2364	19.2364	118440.0
2014-01-07 05:30:00	MSFT	Stock	36.32	36.49	36.32	36.43	2000.0
2014-01-07 06:00:00	MSFT	Stock	36.48	36.51	36.48	36.51	756.0
2014-01-07 06:30:00	MSFT	Stock	36.55	36.6	36.55	36.58	3700.0
2014-01-07 07:00:00	MSFT	Stock	36.58	36.6	36.49	36.49	8214.0
2014-01-07 07:30:00	MSFT	Stock	36.49	36.49	36.46	36.49	2211.0
2014-01-07 08:00:00	MSFT	Stock	36.49	36.5	36.4	36.41	17649.0
2014-01-07 08:30:00	MSFT	Stock	36.39	36.42	36.34	36.37	8646.0
2014-01-07 09:00:00	MSFT	Stock	36.37	36.4	36.28	36.32	25809.0
2014-01-07 09:30:00	MSFT	Stock	36.33	36.36	36.21	36.34	5266732.0
2014-01-07 10:00:00	MSFT	Stock	36.345	36.47	36.34	36.39	3313109.0
2014-01-07 10:30:00	MSFT	Stock	36.385	36.4	36.31	36.37	2236866.0
2014-01-07 11:00:00	MSFT	Stock	36.37	36.39	36.325	36.345	1554387.0
2014-01-07 11:30:00	MSFT	Stock	36.35	36.37	36.28	36.303	1643288.0
2014-01-07 12:00:00	MSFT	Stock	36.305	36.36	36.26	36.32	1987253.0
2014-01-07 12:30:00	MSFT	Stock	36.315	36.39	36.31	36.385	1185986.0
2014-01-07 13:00:00	MSFT	Stock	36.388	36.4	36.35	36.395	1068501.0
2014-01-07 13:30:00	MSFT	Stock	36.392	36.4	36.35	36.35	1340108.0
2014-01-07 14:00:00	MSFT	Stock	36.35	36.36	36.29	36.335	1689575.0

> showing 50 of 81,435 rows — these rows as CSV

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