PREVIEW / stock_30min / 2011-02-04

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-04.parquet
  size:    1.4 MB
  rows:    76,293
  symbols: 3,521

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-02-04 05:00:00	AAPL	Stock	12.2979	12.2979	12.2979	12.2979	6020.0
2011-02-04 05:30:00	AAPL	Stock	12.2979	12.2979	12.2979	12.2979	3220.0
2011-02-04 06:00:00	AAPL	Stock	12.2946	12.2946	12.2946	12.2946	14000.0
2011-02-04 07:00:00	AAPL	Stock	12.2911	12.2911	12.2761	12.2786	86800.0
2011-02-04 07:30:00	AAPL	Stock	12.2857	12.3282	12.2857	12.3164	206444.0
2011-02-04 08:00:00	AAPL	Stock	12.315	12.3179	12.2782	12.3025	1332128.0
2011-02-04 08:30:00	AAPL	Stock	12.3	12.3139	12.26	12.2875	2235912.0
2011-02-04 09:00:00	AAPL	Stock	12.2911	12.2964	12.2664	12.2718	1196524.0
2011-02-04 09:30:00	AAPL	Stock	12.2732	12.3571	12.2682	12.3571	69004404.0
2011-02-04 10:00:00	AAPL	Stock	12.3554	12.3714	12.3304	12.3614	39502820.0
2011-02-04 10:30:00	AAPL	Stock	12.3607	12.3654	12.3043	12.3172	30388428.0
2011-02-04 11:00:00	AAPL	Stock	12.3186	12.3482	12.3032	12.3429	23732324.0
2011-02-04 11:30:00	AAPL	Stock	12.345	12.3504	12.3221	12.3277	10570280.0
2011-02-04 12:00:00	AAPL	Stock	12.3275	12.3368	12.3232	12.3293	7555716.0
2011-02-04 12:30:00	AAPL	Stock	12.3289	12.3482	12.325	12.3454	8571640.0
2011-02-04 13:00:00	AAPL	Stock	12.3464	12.3675	12.3364	12.357	18136692.0
2011-02-04 13:30:00	AAPL	Stock	12.3579	12.365	12.3525	12.3607	9897216.0
2011-02-04 14:00:00	AAPL	Stock	12.3625	12.3625	12.3443	12.3575	11454128.0
2011-02-04 14:30:00	AAPL	Stock	12.3568	12.3625	12.3432	12.3575	10775268.0
2011-02-04 15:00:00	AAPL	Stock	12.3582	12.3821	12.3571	12.3701	24423392.0
2011-02-04 15:30:00	AAPL	Stock	12.3696	12.3786	12.3596	12.375	36349236.0
2011-02-04 16:00:00	AAPL	Stock	12.375	12.3786	12.3445	12.3761	8244880.0
2011-02-04 16:30:00	AAPL	Stock	12.375	12.3764	12.3664	12.3725	554400.0
2011-02-04 17:00:00	AAPL	Stock	12.2657	12.3736	12.2657	12.3736	89684.0
2011-02-04 17:30:00	AAPL	Stock	12.3743	12.3743	12.3718	12.3718	49364.0
2011-02-04 18:00:00	AAPL	Stock	12.375	12.375	12.3721	12.3721	81648.0
2011-02-04 18:30:00	AAPL	Stock	12.3732	12.375	12.3714	12.3714	95200.0
2011-02-04 19:00:00	AAPL	Stock	12.3718	12.3718	12.3668	12.3696	125300.0
2011-02-04 19:30:00	AAPL	Stock	12.3696	12.375	12.3696	12.3743	102144.0
2011-02-04 07:00:00	MSFT	Stock	27.71	27.71	27.71	27.71	400.0
2011-02-04 07:30:00	MSFT	Stock	27.72	27.75	27.72	27.75	600.0
2011-02-04 08:00:00	MSFT	Stock	27.75	27.75	27.72	27.73	4700.0
2011-02-04 08:30:00	MSFT	Stock	27.71	27.74	27.66	27.7	29976.0
2011-02-04 09:00:00	MSFT	Stock	27.7	27.76	27.67	27.7	147046.0
2011-02-04 09:30:00	MSFT	Stock	27.7	27.74	27.51	27.63	6593484.0
2011-02-04 10:00:00	MSFT	Stock	27.625	27.69	27.61	27.68	4306241.0
2011-02-04 10:30:00	MSFT	Stock	27.68	27.71	27.58	27.651	3881887.0
2011-02-04 11:00:00	MSFT	Stock	27.648	27.74	27.58	27.725	3113765.0
2011-02-04 11:30:00	MSFT	Stock	27.725	27.77	27.68	27.69	2251620.0
2011-02-04 12:00:00	MSFT	Stock	27.7	27.73	27.63	27.695	1796889.0
2011-02-04 12:30:00	MSFT	Stock	27.69	27.76	27.68	27.758	1726004.0
2011-02-04 13:00:00	MSFT	Stock	27.76	27.84	27.74	27.78	2311137.0
2011-02-04 13:30:00	MSFT	Stock	27.78	27.8	27.72	27.772	1971779.0
2011-02-04 14:00:00	MSFT	Stock	27.775	27.78	27.7	27.747	1791951.0
2011-02-04 14:30:00	MSFT	Stock	27.75	27.76	27.72	27.76	1759227.0
2011-02-04 15:00:00	MSFT	Stock	27.751	27.79	27.72	27.74	2284917.0
2011-02-04 15:30:00	MSFT	Stock	27.739	27.78	27.71	27.775	4765186.0
2011-02-04 16:00:00	MSFT	Stock	27.77	27.775	27.693	27.75	1371489.0
2011-02-04 16:30:00	MSFT	Stock	27.72	27.77	27.72	27.74	112175.0
2011-02-04 17:00:00	MSFT	Stock	27.65	27.77	27.625	27.77	6274.0

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

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