PREVIEW / stock_30min / 2011-11-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-28.parquet
  size:    1.4 MB
  rows:    76,958
  symbols: 3,538

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-11-28 04:00:00	AAPL	Stock	13.2561	13.2857	13.2536	13.2857	28000.0
2011-11-28 04:30:00	AAPL	Stock	13.3214	13.3214	13.2857	13.3036	10080.0
2011-11-28 05:00:00	AAPL	Stock	13.3254	13.3304	13.3254	13.3304	8400.0
2011-11-28 05:30:00	AAPL	Stock	13.3304	13.3432	13.3304	13.3429	17360.0
2011-11-28 06:00:00	AAPL	Stock	13.3571	13.3571	13.3036	13.3036	78960.0
2011-11-28 06:30:00	AAPL	Stock	13.3532	13.3643	13.3257	13.3257	35700.0
2011-11-28 07:00:00	AAPL	Stock	13.3393	13.3532	13.2882	13.3225	459144.0
2011-11-28 07:30:00	AAPL	Stock	13.3211	13.3464	13.3107	13.3304	755104.0
2011-11-28 08:00:00	AAPL	Stock	13.3336	13.3568	13.2857	13.2971	1630104.0
2011-11-28 08:30:00	AAPL	Stock	13.2911	13.3054	13.2604	13.3004	1858752.0
2011-11-28 09:00:00	AAPL	Stock	13.3011	13.3071	13.2929	13.3036	1897980.0
2011-11-28 09:30:00	AAPL	Stock	13.2982	13.3393	13.2261	13.3214	73173744.0
2011-11-28 10:00:00	AAPL	Stock	13.3196	13.3536	13.3107	13.3264	28475524.0
2011-11-28 10:30:00	AAPL	Stock	13.3282	13.3429	13.3043	13.3286	19400948.0
2011-11-28 11:00:00	AAPL	Stock	13.3282	13.3707	13.3175	13.3686	19997096.0
2011-11-28 11:30:00	AAPL	Stock	13.3686	13.3929	13.3643	13.3775	16395596.0
2011-11-28 12:00:00	AAPL	Stock	13.3786	13.4018	13.3688	13.3829	15018192.0
2011-11-28 12:30:00	AAPL	Stock	13.3825	13.3879	13.3614	13.3743	10445092.0
2011-11-28 13:00:00	AAPL	Stock	13.3739	13.4071	13.3629	13.4036	11573996.0
2011-11-28 13:30:00	AAPL	Stock	13.4035	13.4364	13.3996	13.4036	16524956.0
2011-11-28 14:00:00	AAPL	Stock	13.4021	13.4543	13.3986	13.4457	16907968.0
2011-11-28 14:30:00	AAPL	Stock	13.4461	13.4482	13.3882	13.4082	17801700.0
2011-11-28 15:00:00	AAPL	Stock	13.4079	13.4218	13.3614	13.3636	19702032.0
2011-11-28 15:30:00	AAPL	Stock	13.3643	13.4357	13.3486	13.4293	41271272.0
2011-11-28 16:00:00	AAPL	Stock	13.4301	13.4364	13.3556	13.4257	28239232.0
2011-11-28 16:30:00	AAPL	Stock	13.4214	13.4375	13.3357	13.4332	386512.0
2011-11-28 17:00:00	AAPL	Stock	13.4286	13.4357	13.4214	13.4357	47040.0
2011-11-28 17:30:00	AAPL	Stock	13.4286	13.4339	13.4286	13.4321	44912.0
2011-11-28 18:00:00	AAPL	Stock	13.43	13.4357	13.4286	13.4293	185584.0
2011-11-28 18:30:00	AAPL	Stock	13.4286	13.4321	13.4179	13.4196	71512.0
2011-11-28 19:00:00	AAPL	Stock	13.4239	13.4286	13.4196	13.4214	93044.0
2011-11-28 19:30:00	AAPL	Stock	13.4214	13.4321	13.4214	13.4268	84252.0
2011-11-28 06:30:00	MSFT	Stock	25.0	25.0	25.0	25.0	600.0
2011-11-28 07:00:00	MSFT	Stock	24.96	24.96	24.93	24.93	1300.0
2011-11-28 07:30:00	MSFT	Stock	24.86	24.86	24.78	24.81	5975.0
2011-11-28 08:00:00	MSFT	Stock	24.8	24.92	24.3	24.78	56070.0
2011-11-28 08:30:00	MSFT	Stock	24.83	24.87	24.78	24.8	21960.0
2011-11-28 09:00:00	MSFT	Stock	24.81	24.95	24.77	24.92	105856.0
2011-11-28 09:30:00	MSFT	Stock	24.94	24.97	24.693	24.81	4904778.0
2011-11-28 10:00:00	MSFT	Stock	24.81	24.88	24.8	24.88	2699962.0
2011-11-28 10:30:00	MSFT	Stock	24.89	24.95	24.8	24.84	3333724.0
2011-11-28 11:00:00	MSFT	Stock	24.836	24.87	24.75	24.845	3119170.0
2011-11-28 11:30:00	MSFT	Stock	24.85	24.88	24.795	24.81	3335903.0
2011-11-28 12:00:00	MSFT	Stock	24.8	24.84	24.77	24.79	2023730.0
2011-11-28 12:30:00	MSFT	Stock	24.788	24.81	24.76	24.782	1590439.0
2011-11-28 13:00:00	MSFT	Stock	24.78	24.89	24.77	24.87	1609403.0
2011-11-28 13:30:00	MSFT	Stock	24.878	24.89	24.79	24.81	1528747.0
2011-11-28 14:00:00	MSFT	Stock	24.8	24.895	24.79	24.82	1623352.0
2011-11-28 14:30:00	MSFT	Stock	24.82	24.86	24.75	24.79	2120362.0
2011-11-28 15:00:00	MSFT	Stock	24.78	24.82	24.69	24.755	3083748.0

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

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