PREVIEW / stock_30min / 2011-08-05

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-05.parquet
  size:    1.5 MB
  rows:    81,102
  symbols: 3,559

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
2011-08-05 04:00:00	AAPL	Stock	13.3929	13.3929	13.0236	13.0236	126000.0
2011-08-05 04:30:00	AAPL	Stock	13.0896	13.2382	13.0896	13.1607	369600.0
2011-08-05 05:00:00	AAPL	Stock	13.1846	13.2532	13.1846	13.2532	132160.0
2011-08-05 05:30:00	AAPL	Stock	13.2507	13.2568	13.1786	13.2029	553420.0
2011-08-05 06:00:00	AAPL	Stock	13.1929	13.2643	13.1929	13.25	282380.0
2011-08-05 06:30:00	AAPL	Stock	13.2607	13.3714	13.2607	13.3429	342188.0
2011-08-05 07:00:00	AAPL	Stock	13.3393	13.3661	13.3214	13.3425	632576.0
2011-08-05 07:30:00	AAPL	Stock	13.3543	13.3929	13.3229	13.3857	794416.0
2011-08-05 08:00:00	AAPL	Stock	13.3889	13.4196	13.2743	13.2946	3703896.0
2011-08-05 08:30:00	AAPL	Stock	13.3032	13.6232	13.2896	13.6071	16272200.0
2011-08-05 09:00:00	AAPL	Stock	13.6071	13.6607	13.5439	13.5904	7289268.0
2011-08-05 09:30:00	AAPL	Stock	13.5904	13.6964	13.2164	13.3196	201223148.0
2011-08-05 10:00:00	AAPL	Stock	13.3193	13.5536	13.2432	13.4681	127569288.0
2011-08-05 10:30:00	AAPL	Stock	13.4589	13.4704	13.3396	13.4536	74410784.0
2011-08-05 11:00:00	AAPL	Stock	13.4547	13.4589	13.2436	13.3214	77887852.0
2011-08-05 11:30:00	AAPL	Stock	13.32	13.365	12.9489	13.0804	98704480.0
2011-08-05 12:00:00	AAPL	Stock	13.0757	13.3571	13.0396	13.2036	113168524.0
2011-08-05 12:30:00	AAPL	Stock	13.2033	13.5282	13.1875	13.4689	108452344.0
2011-08-05 13:00:00	AAPL	Stock	13.4668	13.5	13.2589	13.4679	68553800.0
2011-08-05 13:30:00	AAPL	Stock	13.4679	13.5307	13.3929	13.4914	46865336.0
2011-08-05 14:00:00	AAPL	Stock	13.4954	13.5064	13.3929	13.4089	37298436.0
2011-08-05 14:30:00	AAPL	Stock	13.4089	13.4532	13.3289	13.3814	39844588.0
2011-08-05 15:00:00	AAPL	Stock	13.3848	13.3929	13.2096	13.2193	57814904.0
2011-08-05 15:30:00	AAPL	Stock	13.2193	13.3779	13.2143	13.3482	85647716.0
2011-08-05 16:00:00	AAPL	Stock	13.3521	13.3754	13.3054	13.3529	29308188.0
2011-08-05 16:30:00	AAPL	Stock	13.3529	13.3618	13.2174	13.3257	1690220.0
2011-08-05 17:00:00	AAPL	Stock	13.3354	13.3607	13.3289	13.3575	379876.0
2011-08-05 17:30:00	AAPL	Stock	13.3575	13.3714	13.3464	13.3618	106176.0
2011-08-05 18:00:00	AAPL	Stock	13.3732	13.3732	13.3436	13.3586	132748.0
2011-08-05 18:30:00	AAPL	Stock	13.3479	13.3607	13.3479	13.3536	38976.0
2011-08-05 19:00:00	AAPL	Stock	13.3539	13.3539	13.3304	13.3393	547372.0
2011-08-05 19:30:00	AAPL	Stock	13.3425	13.3607	13.3307	13.3607	218624.0
2011-08-05 04:00:00	MSFT	Stock	25.75	25.75	25.59	25.59	300.0
2011-08-05 04:30:00	MSFT	Stock	25.57	25.57	25.57	25.57	1000.0
2011-08-05 05:30:00	MSFT	Stock	25.22	25.57	25.22	25.57	765.0
2011-08-05 06:00:00	MSFT	Stock	25.42	25.42	25.41	25.41	400.0
2011-08-05 06:30:00	MSFT	Stock	25.55	25.68	25.55	25.68	12090.0
2011-08-05 07:00:00	MSFT	Stock	25.67	25.73	25.65	25.65	6850.0
2011-08-05 07:30:00	MSFT	Stock	25.69	25.99	25.66	25.82	17069.0
2011-08-05 08:00:00	MSFT	Stock	25.8	25.95	25.67	25.86	94837.0
2011-08-05 08:30:00	MSFT	Stock	25.92	26.19	25.9	25.95	72694.0
2011-08-05 09:00:00	MSFT	Stock	25.95	26.0	25.9	25.97	192245.0
2011-08-05 09:30:00	MSFT	Stock	25.97	26.0	25.31	25.403	16459133.0
2011-08-05 10:00:00	MSFT	Stock	25.4	25.99	25.31	25.82	11862361.0
2011-08-05 10:30:00	MSFT	Stock	25.82	25.82	25.49	25.69	6961383.0
2011-08-05 11:00:00	MSFT	Stock	25.69	25.695	25.36	25.57	6882792.0
2011-08-05 11:30:00	MSFT	Stock	25.571	25.66	25.23	25.28	7794066.0
2011-08-05 12:00:00	MSFT	Stock	25.28	25.771	25.23	25.53	8946243.0
2011-08-05 12:30:00	MSFT	Stock	25.53	26.1	25.52	25.895	8501878.0
2011-08-05 13:00:00	MSFT	Stock	25.9	26.04	25.62	25.93	5456107.0

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

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