PREVIEW / stock_30min / 2012-02-01

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-01.parquet
  size:    1.5 MB
  rows:    78,465
  symbols: 3,544

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-01 04:00:00	AAPL	Stock	16.3214	16.3707	16.3214	16.3707	5600.0
2012-02-01 04:30:00	AAPL	Stock	16.3929	16.4075	16.3896	16.4075	46480.0
2012-02-01 05:00:00	AAPL	Stock	16.4286	16.4286	16.4	16.4	50680.0
2012-02-01 05:30:00	AAPL	Stock	16.4	16.4	16.3982	16.3982	26040.0
2012-02-01 06:00:00	AAPL	Stock	16.3964	16.3964	16.3929	16.3929	14700.0
2012-02-01 06:30:00	AAPL	Stock	16.3925	16.3964	16.3914	16.3929	50120.0
2012-02-01 07:00:00	AAPL	Stock	16.3914	16.3914	16.3593	16.3804	350448.0
2012-02-01 07:30:00	AAPL	Stock	16.38	16.3882	16.3743	16.3786	323344.0
2012-02-01 08:00:00	AAPL	Stock	16.3743	16.3768	16.35	16.3725	897708.0
2012-02-01 08:30:00	AAPL	Stock	16.3725	16.3779	16.3575	16.3675	676928.0
2012-02-01 09:00:00	AAPL	Stock	16.3693	16.3754	16.3429	16.3714	1991892.0
2012-02-01 09:30:00	AAPL	Stock	16.375	16.3925	16.3029	16.3314	45996888.0
2012-02-01 10:00:00	AAPL	Stock	16.3296	16.3375	16.2696	16.2871	35026600.0
2012-02-01 10:30:00	AAPL	Stock	16.2857	16.3164	16.2721	16.3135	21832720.0
2012-02-01 11:00:00	AAPL	Stock	16.3136	16.3311	16.2775	16.3096	23566200.0
2012-02-01 11:30:00	AAPL	Stock	16.3096	16.3118	16.2819	16.3011	17034444.0
2012-02-01 12:00:00	AAPL	Stock	16.3004	16.3204	16.2917	16.3104	10897152.0
2012-02-01 12:30:00	AAPL	Stock	16.31	16.3304	16.3064	16.3236	11824008.0
2012-02-01 13:00:00	AAPL	Stock	16.323	16.3296	16.3111	16.3225	8633660.0
2012-02-01 13:30:00	AAPL	Stock	16.3236	16.3275	16.3061	16.3096	11489548.0
2012-02-01 14:00:00	AAPL	Stock	16.3104	16.3161	16.2968	16.3107	11357612.0
2012-02-01 14:30:00	AAPL	Stock	16.3104	16.3157	16.2946	16.3021	11136636.0
2012-02-01 15:00:00	AAPL	Stock	16.3025	16.3075	16.2929	16.2986	13123012.0
2012-02-01 15:30:00	AAPL	Stock	16.2987	16.3096	16.2768	16.2925	28877660.0
2012-02-01 16:00:00	AAPL	Stock	16.2919	16.3203	16.2846	16.3	6507312.0
2012-02-01 16:30:00	AAPL	Stock	16.3018	16.3036	16.2925	16.3011	893480.0
2012-02-01 17:00:00	AAPL	Stock	16.3018	16.3082	16.3018	16.3082	85372.0
2012-02-01 17:30:00	AAPL	Stock	16.3068	16.3214	16.295	16.3082	311864.0
2012-02-01 18:00:00	AAPL	Stock	16.3089	16.3214	16.3071	16.3207	54656.0
2012-02-01 18:30:00	AAPL	Stock	16.3189	16.3193	16.3189	16.3193	14000.0
2012-02-01 19:00:00	AAPL	Stock	16.3189	16.3214	16.3175	16.3214	114296.0
2012-02-01 19:30:00	AAPL	Stock	16.3214	16.3304	16.3214	16.3304	425040.0
2012-02-01 06:30:00	MSFT	Stock	29.65	29.72	29.65	29.72	2200.0
2012-02-01 07:00:00	MSFT	Stock	29.82	29.82	29.75	29.76	5100.0
2012-02-01 07:30:00	MSFT	Stock	29.76	29.8	29.71	29.73	34175.0
2012-02-01 08:00:00	MSFT	Stock	29.66	29.7	29.63	29.64	22120.0
2012-02-01 08:30:00	MSFT	Stock	29.67	29.69	29.53	29.69	79604.0
2012-02-01 09:00:00	MSFT	Stock	29.69	29.82	29.69	29.8	65797.0
2012-02-01 09:30:00	MSFT	Stock	29.8	29.9	29.76	29.9	6059522.0
2012-02-01 10:00:00	MSFT	Stock	29.9	29.98	29.84	29.97	4916703.0
2012-02-01 10:30:00	MSFT	Stock	29.97	30.0	29.94	30.0	6056127.0
2012-02-01 11:00:00	MSFT	Stock	29.995	30.0	29.98	30.0	4185681.0
2012-02-01 11:30:00	MSFT	Stock	29.992	30.05	29.91	29.99	10440140.0
2012-02-01 12:00:00	MSFT	Stock	30.0	30.04	29.94	29.97	4363488.0
2012-02-01 12:30:00	MSFT	Stock	29.965	30.03	29.92	29.96	3504486.0
2012-02-01 13:00:00	MSFT	Stock	29.956	30.05	29.95	30.0	1977953.0
2012-02-01 13:30:00	MSFT	Stock	30.004	30.05	29.96	29.999	2981524.0
2012-02-01 14:00:00	MSFT	Stock	30.0	30.04	29.99	30.0	3131284.0
2012-02-01 14:30:00	MSFT	Stock	29.993	30.01	29.96	29.97	2501976.0
2012-02-01 15:00:00	MSFT	Stock	29.965	30.03	29.96	30.004	3469451.0

> showing 50 of 78,465 rows — these rows as CSV

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