PREVIEW / stock_30min / 2011-09-12

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-12.parquet
  size:    1.4 MB
  rows:    76,655
  symbols: 3,517

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-09-12 04:00:00	AAPL	Stock	13.3929	13.3929	13.3929	13.3929	5600.0
2011-09-12 04:30:00	AAPL	Stock	13.3393	13.3393	13.3393	13.3393	2800.0
2011-09-12 05:30:00	AAPL	Stock	13.3214	13.3393	13.3214	13.3393	11200.0
2011-09-12 06:00:00	AAPL	Stock	13.3214	13.3214	13.3125	13.3214	22400.0
2011-09-12 06:30:00	AAPL	Stock	13.3036	13.3036	13.3036	13.3036	7700.0
2011-09-12 07:00:00	AAPL	Stock	13.3179	13.3643	13.2946	13.3357	331800.0
2011-09-12 07:30:00	AAPL	Stock	13.3461	13.3571	13.3036	13.3196	414792.0
2011-09-12 08:00:00	AAPL	Stock	13.3204	13.3254	13.2357	13.2929	2234736.0
2011-09-12 08:30:00	AAPL	Stock	13.2864	13.3375	13.2864	13.3357	1530536.0
2011-09-12 09:00:00	AAPL	Stock	13.3293	13.3714	13.3218	13.3239	1856932.0
2011-09-12 09:30:00	AAPL	Stock	13.3239	13.5625	13.3214	13.555	68447540.0
2011-09-12 10:00:00	AAPL	Stock	13.5539	13.6029	13.5098	13.5161	46282292.0
2011-09-12 10:30:00	AAPL	Stock	13.5164	13.5382	13.4018	13.4079	32094356.0
2011-09-12 11:00:00	AAPL	Stock	13.4076	13.4975	13.4021	13.4884	25668496.0
2011-09-12 11:30:00	AAPL	Stock	13.4861	13.5179	13.45	13.4546	19726756.0
2011-09-12 12:00:00	AAPL	Stock	13.4536	13.4714	13.4036	13.4375	18553976.0
2011-09-12 12:30:00	AAPL	Stock	13.4375	13.4418	13.375	13.4032	17010952.0
2011-09-12 13:00:00	AAPL	Stock	13.4032	13.4254	13.3507	13.3525	17606960.0
2011-09-12 13:30:00	AAPL	Stock	13.3561	13.3575	13.3183	13.3368	27711152.0
2011-09-12 14:00:00	AAPL	Stock	13.3403	13.3457	13.2821	13.336	29402296.0
2011-09-12 14:30:00	AAPL	Stock	13.3364	13.4746	13.3296	13.3943	46874380.0
2011-09-12 15:00:00	AAPL	Stock	13.3943	13.4096	13.3439	13.3932	34841688.0
2011-09-12 15:30:00	AAPL	Stock	13.395	13.5696	13.3924	13.5696	62234704.0
2011-09-12 16:00:00	AAPL	Stock	13.5664	13.5982	13.4391	13.5696	7243320.0
2011-09-12 16:30:00	AAPL	Stock	13.5696	13.6071	13.3195	13.5946	1217860.0
2011-09-12 17:00:00	AAPL	Stock	13.6004	13.6161	13.5696	13.6	613788.0
2011-09-12 17:30:00	AAPL	Stock	13.5954	13.5961	13.5768	13.5839	357588.0
2011-09-12 18:00:00	AAPL	Stock	13.5839	13.5989	13.5693	13.5964	112812.0
2011-09-12 18:30:00	AAPL	Stock	13.5961	13.5964	13.5946	13.5961	28700.0
2011-09-12 19:00:00	AAPL	Stock	13.5961	13.5968	13.5875	13.5893	123396.0
2011-09-12 19:30:00	AAPL	Stock	13.5911	13.5954	13.5875	13.5936	147196.0
2011-09-12 04:00:00	MSFT	Stock	25.59	25.59	25.5	25.5	2815.0
2011-09-12 06:30:00	MSFT	Stock	25.44	25.44	25.44	25.44	100.0
2011-09-12 07:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	100.0
2011-09-12 07:30:00	MSFT	Stock	25.4	25.42	25.39	25.42	2000.0
2011-09-12 08:00:00	MSFT	Stock	25.42	25.43	25.32	25.35	18353.0
2011-09-12 08:30:00	MSFT	Stock	25.36	25.5	25.36	25.49	12119.0
2011-09-12 09:00:00	MSFT	Stock	25.51	25.55	25.41	25.44	20652.0
2011-09-12 09:30:00	MSFT	Stock	25.42	25.76	25.42	25.66	5304467.0
2011-09-12 10:00:00	MSFT	Stock	25.66	25.75	25.61	25.68	3886321.0
2011-09-12 10:30:00	MSFT	Stock	25.675	25.73	25.57	25.57	3240847.0
2011-09-12 11:00:00	MSFT	Stock	25.57	25.735	25.57	25.66	2159624.0
2011-09-12 11:30:00	MSFT	Stock	25.66	25.7	25.57	25.597	2809708.0
2011-09-12 12:00:00	MSFT	Stock	25.6	25.6	25.44	25.5	3432219.0
2011-09-12 12:30:00	MSFT	Stock	25.5	25.51	25.4	25.47	2808604.0
2011-09-12 13:00:00	MSFT	Stock	25.47	25.56	25.42	25.43	2389385.0
2011-09-12 13:30:00	MSFT	Stock	25.43	25.44	25.34	25.409	2266777.0
2011-09-12 14:00:00	MSFT	Stock	25.409	25.41	25.27	25.35	3333901.0
2011-09-12 14:30:00	MSFT	Stock	25.35	25.59	25.321	25.47	5157530.0
2011-09-12 15:00:00	MSFT	Stock	25.47	25.549	25.41	25.53	3470792.0

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

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