PREVIEW / stock_30min / 2011-11-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-08.parquet
  size:    1.4 MB
  rows:    75,642
  symbols: 3,524

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-08 04:00:00	AAPL	Stock	14.3214	14.3214	14.3214	14.3214	14000.0
2011-11-08 04:30:00	AAPL	Stock	14.3214	14.3214	14.3214	14.3214	5600.0
2011-11-08 07:00:00	AAPL	Stock	14.3293	14.3293	14.3196	14.325	42560.0
2011-11-08 07:30:00	AAPL	Stock	14.3354	14.3836	14.3354	14.3836	301728.0
2011-11-08 08:00:00	AAPL	Stock	14.3818	14.3818	14.3429	14.3543	874916.0
2011-11-08 08:30:00	AAPL	Stock	14.3543	14.3857	14.35	14.3839	715792.0
2011-11-08 09:00:00	AAPL	Stock	14.3789	14.3821	14.3561	14.3661	567532.0
2011-11-08 09:30:00	AAPL	Stock	14.3661	14.4911	14.3414	14.4846	92407560.0
2011-11-08 10:00:00	AAPL	Stock	14.4817	14.505	14.4429	14.4504	48953352.0
2011-11-08 10:30:00	AAPL	Stock	14.452	14.4936	14.4439	14.4757	27834772.0
2011-11-08 11:00:00	AAPL	Stock	14.4736	14.4925	14.3896	14.4318	32304860.0
2011-11-08 11:30:00	AAPL	Stock	14.4318	14.4507	14.4175	14.4368	13707092.0
2011-11-08 12:00:00	AAPL	Stock	14.4339	14.4464	14.4179	14.4357	8530844.0
2011-11-08 12:30:00	AAPL	Stock	14.4361	14.4764	14.4304	14.4343	14347704.0
2011-11-08 13:00:00	AAPL	Stock	14.4339	14.4743	14.4321	14.4718	10177356.0
2011-11-08 13:30:00	AAPL	Stock	14.4732	14.505	14.45	14.4964	25298728.0
2011-11-08 14:00:00	AAPL	Stock	14.4996	14.5107	14.4579	14.5107	21211680.0
2011-11-08 14:30:00	AAPL	Stock	14.51	14.5161	14.4836	14.505	17424428.0
2011-11-08 15:00:00	AAPL	Stock	14.5007	14.5146	14.4761	14.5139	22140188.0
2011-11-08 15:30:00	AAPL	Stock	14.5139	14.5714	14.4957	14.5004	47418420.0
2011-11-08 16:00:00	AAPL	Stock	14.5	14.5168	14.4396	14.5107	12605684.0
2011-11-08 16:30:00	AAPL	Stock	14.5143	14.525	14.455	14.5246	1175272.0
2011-11-08 17:00:00	AAPL	Stock	14.5257	14.5261	14.5189	14.5204	149016.0
2011-11-08 17:30:00	AAPL	Stock	14.5221	14.5268	14.5179	14.5268	94892.0
2011-11-08 18:00:00	AAPL	Stock	14.525	14.525	14.5082	14.5214	98000.0
2011-11-08 18:30:00	AAPL	Stock	14.5211	14.5329	14.5211	14.5321	394744.0
2011-11-08 19:00:00	AAPL	Stock	14.5286	14.5286	14.525	14.5286	49364.0
2011-11-08 19:30:00	AAPL	Stock	14.5289	14.5357	14.5268	14.5357	197204.0
2011-11-08 04:00:00	MSFT	Stock	26.86	26.86	26.86	26.86	7920.0
2011-11-08 06:30:00	MSFT	Stock	26.8	26.8	26.8	26.8	300.0
2011-11-08 07:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	1000.0
2011-11-08 07:30:00	MSFT	Stock	26.9	26.99	26.86	26.95	12593.0
2011-11-08 08:00:00	MSFT	Stock	26.94	26.99	26.9	26.98	31205.0
2011-11-08 08:30:00	MSFT	Stock	26.95	26.95	26.9	26.92	18812.0
2011-11-08 09:00:00	MSFT	Stock	26.92	27.09	26.92	27.03	66779.0
2011-11-08 09:30:00	MSFT	Stock	27.03	27.14	26.92	27.09	5141133.0
2011-11-08 10:00:00	MSFT	Stock	27.085	27.1	26.87	26.89	3780997.0
2011-11-08 10:30:00	MSFT	Stock	26.885	26.89	26.77	26.85	4946355.0
2011-11-08 11:00:00	MSFT	Stock	26.85	26.87	26.685	26.78	3194806.0
2011-11-08 11:30:00	MSFT	Stock	26.785	26.85	26.74	26.827	1990504.0
2011-11-08 12:00:00	MSFT	Stock	26.83	26.89	26.8	26.83	1313032.0
2011-11-08 12:30:00	MSFT	Stock	26.83	26.89	26.82	26.836	1540398.0
2011-11-08 13:00:00	MSFT	Stock	26.839	26.9	26.76	26.9	1646666.0
2011-11-08 13:30:00	MSFT	Stock	26.9	27.08	26.86	27.058	2802523.0
2011-11-08 14:00:00	MSFT	Stock	27.052	27.118	27.0	27.115	2467699.0
2011-11-08 14:30:00	MSFT	Stock	27.115	27.16	27.08	27.12	2254957.0
2011-11-08 15:00:00	MSFT	Stock	27.12	27.2	27.07	27.14	3086227.0
2011-11-08 15:30:00	MSFT	Stock	27.14	27.2	27.13	27.15	7695287.0
2011-11-08 16:00:00	MSFT	Stock	27.155	27.17	26.822	27.13	4540342.0
2011-11-08 16:30:00	MSFT	Stock	26.813	27.164	26.813	27.13	46600.0

> showing 50 of 75,642 rows — these rows as CSV

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