PREVIEW / stock_30min / 2011-09-22

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-22.parquet
  size:    1.5 MB
  rows:    80,700
  symbols: 3,542

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-22 04:00:00	AAPL	Stock	14.525	14.5386	14.4643	14.5296	61096.0
2011-09-22 04:30:00	AAPL	Stock	14.5196	14.5196	14.4896	14.4896	27300.0
2011-09-22 05:00:00	AAPL	Stock	14.4893	14.4893	14.4643	14.4643	100800.0
2011-09-22 05:30:00	AAPL	Stock	14.4679	14.4893	14.4679	14.4757	39200.0
2011-09-22 06:00:00	AAPL	Stock	14.4643	14.5107	14.4643	14.5107	28000.0
2011-09-22 06:30:00	AAPL	Stock	14.4929	14.4929	14.4286	14.4286	173516.0
2011-09-22 07:00:00	AAPL	Stock	14.4286	14.4679	14.4239	14.4471	843584.0
2011-09-22 07:30:00	AAPL	Stock	14.4511	14.5179	14.4357	14.5089	1498812.0
2011-09-22 08:00:00	AAPL	Stock	14.5079	14.5536	14.45	14.5279	4210304.0
2011-09-22 08:30:00	AAPL	Stock	14.5311	14.5357	14.3304	14.3682	9349872.0
2011-09-22 09:00:00	AAPL	Stock	14.3679	14.4064	14.3071	14.3282	7748272.0
2011-09-22 09:30:00	AAPL	Stock	14.3282	14.49	14.2857	14.3732	151129664.0
2011-09-22 10:00:00	AAPL	Stock	14.3732	14.6021	14.3546	14.5532	105586488.0
2011-09-22 10:30:00	AAPL	Stock	14.5532	14.6364	14.5239	14.5239	60806816.0
2011-09-22 11:00:00	AAPL	Stock	14.5243	14.5489	14.4475	14.4804	46644668.0
2011-09-22 11:30:00	AAPL	Stock	14.4782	14.58	14.4696	14.4739	42058548.0
2011-09-22 12:00:00	AAPL	Stock	14.4739	14.4982	14.3689	14.4325	48594840.0
2011-09-22 12:30:00	AAPL	Stock	14.4325	14.4975	14.4171	14.475	40436956.0
2011-09-22 13:00:00	AAPL	Stock	14.4721	14.4814	14.3643	14.3864	34279616.0
2011-09-22 13:30:00	AAPL	Stock	14.3852	14.3929	14.2321	14.2321	83054888.0
2011-09-22 14:00:00	AAPL	Stock	14.2368	14.4	14.2104	14.3571	94380020.0
2011-09-22 14:30:00	AAPL	Stock	14.3636	14.375	14.2536	14.255	55300784.0
2011-09-22 15:00:00	AAPL	Stock	14.2589	14.2957	14.1679	14.2525	62608252.0
2011-09-22 15:30:00	AAPL	Stock	14.2525	14.4214	14.2179	14.3507	93805544.0
2011-09-22 16:00:00	AAPL	Stock	14.3742	14.393	14.2904	14.3479	15175860.0
2011-09-22 16:30:00	AAPL	Stock	14.3393	14.3932	14.2567	14.3929	2976316.0
2011-09-22 17:00:00	AAPL	Stock	14.5355	14.5355	14.3507	14.3929	697088.0
2011-09-22 17:30:00	AAPL	Stock	14.4029	14.4029	14.375	14.375	337232.0
2011-09-22 18:00:00	AAPL	Stock	14.3929	14.3961	14.3507	14.3929	256536.0
2011-09-22 18:30:00	AAPL	Stock	14.3929	14.3982	14.375	14.375	168700.0
2011-09-22 19:00:00	AAPL	Stock	14.3864	14.3868	14.3571	14.3754	110796.0
2011-09-22 19:30:00	AAPL	Stock	14.3818	14.3929	14.3711	14.3875	430864.0
2011-09-22 04:00:00	MSFT	Stock	25.77	25.77	25.77	25.77	100.0
2011-09-22 04:30:00	MSFT	Stock	25.57	25.57	25.57	25.57	300.0
2011-09-22 05:00:00	MSFT	Stock	25.6	25.6	25.6	25.6	650.0
2011-09-22 06:30:00	MSFT	Stock	25.55	25.55	25.35	25.35	12435.0
2011-09-22 07:00:00	MSFT	Stock	25.34	25.41	25.31	25.38	14615.0
2011-09-22 07:30:00	MSFT	Stock	25.42	25.52	25.42	25.43	6628.0
2011-09-22 08:00:00	MSFT	Stock	25.44	25.52	25.4	25.42	34514.0
2011-09-22 08:30:00	MSFT	Stock	25.48	25.51	25.25	25.26	30512.0
2011-09-22 09:00:00	MSFT	Stock	25.28	25.52	25.16	25.36	203602.0
2011-09-22 09:30:00	MSFT	Stock	25.37	25.65	25.18	25.25	8534790.0
2011-09-22 10:00:00	MSFT	Stock	25.24	25.45	25.24	25.342	6097832.0
2011-09-22 10:30:00	MSFT	Stock	25.345	25.51	25.3	25.31	5049230.0
2011-09-22 11:00:00	MSFT	Stock	25.3	25.35	25.15	25.16	6622368.0
2011-09-22 11:30:00	MSFT	Stock	25.17	25.27	25.07	25.11	5188375.0
2011-09-22 12:00:00	MSFT	Stock	25.11	25.17	25.03	25.12	4048126.0
2011-09-22 12:30:00	MSFT	Stock	25.12	25.24	25.09	25.185	3038968.0
2011-09-22 13:00:00	MSFT	Stock	25.19	25.2	25.01	25.04	3403997.0
2011-09-22 13:30:00	MSFT	Stock	25.04	25.08	24.71	24.72	6857241.0

> showing 50 of 80,700 rows — these rows as CSV

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