PREVIEW / stock_30min / 2011-01-26

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-26.parquet
  size:    1.4 MB
  rows:    77,067
  symbols: 3,516

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-01-26 04:00:00	AAPL	Stock	12.2457	12.2857	12.2457	12.2507	13300.0
2011-01-26 04:30:00	AAPL	Stock	12.2804	12.3161	12.2804	12.3071	25200.0
2011-01-26 05:00:00	AAPL	Stock	12.3079	12.3079	12.2893	12.3071	64400.0
2011-01-26 05:30:00	AAPL	Stock	12.3079	12.3161	12.3079	12.3161	15260.0
2011-01-26 06:00:00	AAPL	Stock	12.3125	12.3129	12.3036	12.3036	19600.0
2011-01-26 06:30:00	AAPL	Stock	12.3036	12.3036	12.3	12.3	19600.0
2011-01-26 07:00:00	AAPL	Stock	12.2857	12.3	12.2607	12.275	217140.0
2011-01-26 07:30:00	AAPL	Stock	12.2757	12.2829	12.2729	12.2796	107352.0
2011-01-26 08:00:00	AAPL	Stock	12.2796	12.2804	12.2357	12.2507	2257080.0
2011-01-26 08:30:00	AAPL	Stock	12.2586	12.2629	12.2421	12.25	958356.0
2011-01-26 09:00:00	AAPL	Stock	12.2504	12.2611	12.2329	12.2475	1323644.0
2011-01-26 09:30:00	AAPL	Stock	12.2471	12.2614	12.1964	12.2311	71507604.0
2011-01-26 10:00:00	AAPL	Stock	12.2307	12.325	12.2182	12.3214	79594704.0
2011-01-26 10:30:00	AAPL	Stock	12.3204	12.3386	12.2864	12.2961	52078656.0
2011-01-26 11:00:00	AAPL	Stock	12.2964	12.3154	12.2786	12.2793	24846192.0
2011-01-26 11:30:00	AAPL	Stock	12.2786	12.3154	12.2682	12.2986	22344056.0
2011-01-26 12:00:00	AAPL	Stock	12.2989	12.3164	12.2971	12.3135	12425252.0
2011-01-26 12:30:00	AAPL	Stock	12.3135	12.3375	12.3114	12.3218	26803616.0
2011-01-26 13:00:00	AAPL	Stock	12.3219	12.3236	12.2936	12.3129	22877176.0
2011-01-26 13:30:00	AAPL	Stock	12.3132	12.3311	12.3079	12.3171	20911660.0
2011-01-26 14:00:00	AAPL	Stock	12.3168	12.3321	12.2814	12.3	29950060.0
2011-01-26 14:30:00	AAPL	Stock	12.2975	12.3304	12.2857	12.3271	29013292.0
2011-01-26 15:00:00	AAPL	Stock	12.3232	12.3429	12.315	12.3396	35196336.0
2011-01-26 15:30:00	AAPL	Stock	12.3395	12.3407	12.2786	12.2811	48552252.0
2011-01-26 16:00:00	AAPL	Stock	12.2821	12.3099	12.2796	12.2857	8045268.0
2011-01-26 16:30:00	AAPL	Stock	12.2854	12.3402	12.2829	12.2875	204316.0
2011-01-26 17:00:00	AAPL	Stock	12.2846	12.3129	12.2804	12.2804	395976.0
2011-01-26 17:30:00	AAPL	Stock	12.2904	12.2904	12.2857	12.2857	87836.0
2011-01-26 18:00:00	AAPL	Stock	12.2875	12.2879	12.2804	12.2839	144956.0
2011-01-26 18:30:00	AAPL	Stock	12.2839	12.29	12.2825	12.2857	73696.0
2011-01-26 19:00:00	AAPL	Stock	12.2907	12.2907	12.2861	12.2893	212380.0
2011-01-26 19:30:00	AAPL	Stock	12.2832	12.2861	12.2679	12.2857	102340.0
2011-01-26 04:30:00	MSFT	Stock	28.45	28.45	28.45	28.45	100.0
2011-01-26 06:00:00	MSFT	Stock	28.45	28.45	28.45	28.45	200.0
2011-01-26 06:30:00	MSFT	Stock	28.45	28.45	28.45	28.45	400.0
2011-01-26 07:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	100.0
2011-01-26 07:30:00	MSFT	Stock	28.56	28.56	28.56	28.56	600.0
2011-01-26 08:00:00	MSFT	Stock	28.52	28.58	28.52	28.57	29965.0
2011-01-26 08:30:00	MSFT	Stock	28.55	28.56	28.52	28.53	6509.0
2011-01-26 09:00:00	MSFT	Stock	28.52	28.54	28.48	28.52	87695.0
2011-01-26 09:30:00	MSFT	Stock	28.51	28.8	28.5	28.8	9086488.0
2011-01-26 10:00:00	MSFT	Stock	28.79	28.98	28.72	28.98	10726697.0
2011-01-26 10:30:00	MSFT	Stock	28.98	28.99	28.9	28.958	6911910.0
2011-01-26 11:00:00	MSFT	Stock	28.955	28.96	28.78	28.78	5051154.0
2011-01-26 11:30:00	MSFT	Stock	28.785	28.84	28.73	28.77	3744227.0
2011-01-26 12:00:00	MSFT	Stock	28.77	28.81	28.76	28.794	2606500.0
2011-01-26 12:30:00	MSFT	Stock	28.8	28.88	28.73	28.845	4327751.0
2011-01-26 13:00:00	MSFT	Stock	28.84	28.87	28.77	28.81	2274472.0
2011-01-26 13:30:00	MSFT	Stock	28.81	28.93	28.8	28.895	3326234.0
2011-01-26 14:00:00	MSFT	Stock	28.89	28.92	28.85	28.9	5746673.0

> showing 50 of 77,067 rows — these rows as CSV

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