PREVIEW / stock_30min / 2012-02-08

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-08.parquet
  size:    1.4 MB
  rows:    76,908
  symbols: 3,557

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-02-08 04:00:00	AAPL	Stock	16.8093	16.8686	16.8093	16.8471	85652.0
2012-02-08 04:30:00	AAPL	Stock	16.8393	16.8589	16.8393	16.8589	21700.0
2012-02-08 05:00:00	AAPL	Stock	16.8286	16.8286	16.8036	16.8036	51240.0
2012-02-08 05:30:00	AAPL	Stock	16.8214	16.8214	16.8204	16.8204	5600.0
2012-02-08 06:00:00	AAPL	Stock	16.8321	16.8343	16.8264	16.8343	39060.0
2012-02-08 06:30:00	AAPL	Stock	16.8214	16.8275	16.8146	16.8214	44800.0
2012-02-08 07:00:00	AAPL	Stock	16.8179	16.8207	16.7864	16.8036	139804.0
2012-02-08 07:30:00	AAPL	Stock	16.8	16.8232	16.8	16.8121	354424.0
2012-02-08 08:00:00	AAPL	Stock	16.8175	16.8214	16.7143	16.8064	1397032.0
2012-02-08 08:30:00	AAPL	Stock	16.8071	16.8107	16.7946	16.8018	609896.0
2012-02-08 09:00:00	AAPL	Stock	16.8018	16.8107	16.7857	16.8096	1404088.0
2012-02-08 09:30:00	AAPL	Stock	16.8036	16.8907	16.775	16.8875	61331480.0
2012-02-08 10:00:00	AAPL	Stock	16.8889	16.9364	16.8786	16.9161	49964992.0
2012-02-08 10:30:00	AAPL	Stock	16.9156	16.9157	16.8482	16.8729	37173248.0
2012-02-08 11:00:00	AAPL	Stock	16.8739	16.8804	16.8189	16.8293	36027180.0
2012-02-08 11:30:00	AAPL	Stock	16.8296	16.8854	16.8071	16.8814	27533268.0
2012-02-08 12:00:00	AAPL	Stock	16.8806	16.8857	16.8489	16.875	14405860.0
2012-02-08 12:30:00	AAPL	Stock	16.8739	16.9057	16.8682	16.9027	14324744.0
2012-02-08 13:00:00	AAPL	Stock	16.9032	16.9171	16.8882	16.9157	11320736.0
2012-02-08 13:30:00	AAPL	Stock	16.9154	16.9354	16.9054	16.9181	16524116.0
2012-02-08 14:00:00	AAPL	Stock	16.9179	16.9564	16.9125	16.951	22178044.0
2012-02-08 14:30:00	AAPL	Stock	16.9507	16.9696	16.9375	16.9621	27864788.0
2012-02-08 15:00:00	AAPL	Stock	16.9629	16.9982	16.9586	16.99	26819884.0
2012-02-08 15:30:00	AAPL	Stock	16.9917	17.0282	16.9746	17.0239	42876988.0
2012-02-08 16:00:00	AAPL	Stock	17.0229	17.0589	16.8247	17.0504	6803972.0
2012-02-08 16:30:00	AAPL	Stock	17.0507	17.0607	16.99	17.0571	674268.0
2012-02-08 17:00:00	AAPL	Stock	17.0446	17.0529	17.0225	17.0246	396536.0
2012-02-08 17:30:00	AAPL	Stock	17.025	17.0314	17.0179	17.0214	239008.0
2012-02-08 18:00:00	AAPL	Stock	17.0232	17.0232	17.0021	17.0118	209580.0
2012-02-08 18:30:00	AAPL	Stock	17.0118	17.0321	17.0118	17.0286	175308.0
2012-02-08 19:00:00	AAPL	Stock	17.0214	17.0286	17.0214	17.0286	47040.0
2012-02-08 19:30:00	AAPL	Stock	17.0275	17.0321	17.0079	17.0218	412524.0
2012-02-08 04:30:00	MSFT	Stock	30.4	30.55	30.4	30.55	300.0
2012-02-08 05:00:00	MSFT	Stock	30.49	30.49	30.49	30.49	200.0
2012-02-08 06:00:00	MSFT	Stock	30.49	30.49	30.49	30.49	100.0
2012-02-08 08:00:00	MSFT	Stock	30.36	30.42	30.35	30.38	39736.0
2012-02-08 08:30:00	MSFT	Stock	30.4	30.4	30.36	30.4	6150.0
2012-02-08 09:00:00	MSFT	Stock	30.38	30.38	30.23	30.25	26113.0
2012-02-08 09:30:00	MSFT	Stock	30.27	30.4	30.22	30.37	4406111.0
2012-02-08 10:00:00	MSFT	Stock	30.375	30.48	30.37	30.465	3517192.0
2012-02-08 10:30:00	MSFT	Stock	30.465	30.48	30.38	30.395	3449495.0
2012-02-08 11:00:00	MSFT	Stock	30.395	30.425	30.34	30.36	5101870.0
2012-02-08 11:30:00	MSFT	Stock	30.365	30.4	30.32	30.352	3817698.0
2012-02-08 12:00:00	MSFT	Stock	30.356	30.403	30.35	30.375	1607345.0
2012-02-08 12:30:00	MSFT	Stock	30.37	30.47	30.36	30.462	2774667.0
2012-02-08 13:00:00	MSFT	Stock	30.47	30.49	30.41	30.485	2464018.0
2012-02-08 13:30:00	MSFT	Stock	30.49	30.49	30.46	30.46	1556557.0
2012-02-08 14:00:00	MSFT	Stock	30.46	30.5	30.45	30.5	2640097.0
2012-02-08 14:30:00	MSFT	Stock	30.49	30.56	30.47	30.56	2662965.0
2012-02-08 15:00:00	MSFT	Stock	30.555	30.58	30.51	30.57	4798584.0

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

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