PREVIEW / stock_30min / 2011-06-02

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-02.parquet
  size:    1.4 MB
  rows:    74,317
  symbols: 3,547

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-06-02 04:30:00	AAPL	Stock	12.3718	12.3929	12.3718	12.3929	42000.0
2011-06-02 05:00:00	AAPL	Stock	12.3729	12.3957	12.3718	12.3957	19600.0
2011-06-02 05:30:00	AAPL	Stock	12.3821	12.3857	12.3821	12.3857	5600.0
2011-06-02 06:00:00	AAPL	Stock	12.4107	12.4107	12.4107	12.4107	16800.0
2011-06-02 06:30:00	AAPL	Stock	12.3875	12.3929	12.3875	12.3929	11200.0
2011-06-02 07:00:00	AAPL	Stock	12.3757	12.3757	12.3589	12.3696	65800.0
2011-06-02 07:30:00	AAPL	Stock	12.3682	12.3821	12.3679	12.3714	155400.0
2011-06-02 08:00:00	AAPL	Stock	12.375	12.3814	12.3614	12.3643	648144.0
2011-06-02 08:30:00	AAPL	Stock	12.365	12.4129	12.365	12.4004	1790936.0
2011-06-02 09:00:00	AAPL	Stock	12.4018	12.4036	12.375	12.3768	555072.0
2011-06-02 09:30:00	AAPL	Stock	12.375	12.4125	12.3339	12.3821	59712828.0
2011-06-02 10:00:00	AAPL	Stock	12.3836	12.4079	12.3589	12.4032	35343364.0
2011-06-02 10:30:00	AAPL	Stock	12.4036	12.4279	12.3821	12.3886	30649948.0
2011-06-02 11:00:00	AAPL	Stock	12.3886	12.3986	12.3243	12.3305	22233764.0
2011-06-02 11:30:00	AAPL	Stock	12.3336	12.3536	12.2964	12.3464	33173420.0
2011-06-02 12:00:00	AAPL	Stock	12.3468	12.3636	12.3329	12.3475	12703460.0
2011-06-02 12:30:00	AAPL	Stock	12.3479	12.3636	12.3311	12.3507	14547428.0
2011-06-02 13:00:00	AAPL	Stock	12.3504	12.3846	12.3475	12.3726	19730816.0
2011-06-02 13:30:00	AAPL	Stock	12.3704	12.4004	12.3529	12.3961	15687448.0
2011-06-02 14:00:00	AAPL	Stock	12.3939	12.4096	12.3561	12.3829	22292564.0
2011-06-02 14:30:00	AAPL	Stock	12.3829	12.4025	12.37	12.3911	14111048.0
2011-06-02 15:00:00	AAPL	Stock	12.3918	12.3986	12.3643	12.3829	17798368.0
2011-06-02 15:30:00	AAPL	Stock	12.3821	12.3871	12.3436	12.355	25193560.0
2011-06-02 16:00:00	AAPL	Stock	12.3568	12.375	12.3393	12.3679	9299052.0
2011-06-02 16:30:00	AAPL	Stock	12.3668	12.3815	12.3668	12.3679	91112.0
2011-06-02 17:00:00	AAPL	Stock	12.3721	12.3732	12.3668	12.3729	181580.0
2011-06-02 17:30:00	AAPL	Stock	12.3714	12.3739	12.3696	12.3714	46620.0
2011-06-02 18:00:00	AAPL	Stock	12.3732	12.3732	12.3607	12.3714	57400.0
2011-06-02 18:30:00	AAPL	Stock	12.3714	12.3739	12.3639	12.3739	35000.0
2011-06-02 19:00:00	AAPL	Stock	12.3746	12.3746	12.3654	12.3654	37940.0
2011-06-02 19:30:00	AAPL	Stock	12.3668	12.3675	12.3661	12.3661	29120.0
2011-06-02 06:00:00	MSFT	Stock	24.54	24.54	24.54	24.54	100.0
2011-06-02 06:30:00	MSFT	Stock	24.54	24.54	24.54	24.54	100.0
2011-06-02 07:00:00	MSFT	Stock	24.54	24.55	24.54	24.55	3000.0
2011-06-02 07:30:00	MSFT	Stock	24.51	24.54	24.51	24.51	1022.0
2011-06-02 08:00:00	MSFT	Stock	24.54	24.55	24.46	24.47	7246.0
2011-06-02 08:30:00	MSFT	Stock	24.5	24.54	24.47	24.54	56844.0
2011-06-02 09:00:00	MSFT	Stock	24.53	24.54	24.42	24.5	100846.0
2011-06-02 09:30:00	MSFT	Stock	24.5	24.65	24.39	24.46	5211727.0
2011-06-02 10:00:00	MSFT	Stock	24.46	24.53	24.43	24.45	3861294.0
2011-06-02 10:30:00	MSFT	Stock	24.46	24.479	24.42	24.433	2297346.0
2011-06-02 11:00:00	MSFT	Stock	24.43	24.435	24.3	24.31	3349054.0
2011-06-02 11:30:00	MSFT	Stock	24.3	24.32	24.24	24.305	3570539.0
2011-06-02 12:00:00	MSFT	Stock	24.306	24.32	24.28	24.3	2604788.0
2011-06-02 12:30:00	MSFT	Stock	24.31	24.31	24.24	24.25	2506464.0
2011-06-02 13:00:00	MSFT	Stock	24.25	24.28	24.24	24.25	2845912.0
2011-06-02 13:30:00	MSFT	Stock	24.26	24.26	24.19	24.21	4021507.0
2011-06-02 14:00:00	MSFT	Stock	24.21	24.28	24.19	24.21	4053712.0
2011-06-02 14:30:00	MSFT	Stock	24.205	24.24	24.19	24.215	3747060.0
2011-06-02 15:00:00	MSFT	Stock	24.22	24.25	24.2	24.24	2709405.0

> showing 50 of 74,317 rows — these rows as CSV

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