PREVIEW / stock_30min / 2012-12-06

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-06.parquet
  size:    1.4 MB
  rows:    75,144
  symbols: 3,494

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
2012-12-06 04:00:00	AAPL	Stock	19.1786	19.2143	19.1643	19.2143	126196.0
2012-12-06 04:30:00	AAPL	Stock	19.2	19.2107	19.1964	19.2107	27860.0
2012-12-06 05:00:00	AAPL	Stock	19.1975	19.2107	19.1875	19.1875	37408.0
2012-12-06 05:30:00	AAPL	Stock	19.1875	19.2054	19.1875	19.1875	11200.0
2012-12-06 06:00:00	AAPL	Stock	19.2032	19.2143	19.1993	19.2104	84924.0
2012-12-06 06:30:00	AAPL	Stock	19.1893	19.1893	19.1429	19.15	110964.0
2012-12-06 07:00:00	AAPL	Stock	19.1518	19.1768	19.1464	19.1682	216972.0
2012-12-06 07:30:00	AAPL	Stock	19.1661	19.1875	19.1518	19.1875	562268.0
2012-12-06 08:00:00	AAPL	Stock	19.1786	19.1857	18.975	19.0368	5815404.0
2012-12-06 08:30:00	AAPL	Stock	19.0518	19.1025	18.9514	19.005	4677764.0
2012-12-06 09:00:00	AAPL	Stock	19.0039	19.0068	18.8571	18.8893	10103576.0
2012-12-06 09:30:00	AAPL	Stock	18.8857	19.2289	18.5225	19.0375	297718316.0
2012-12-06 10:00:00	AAPL	Stock	19.0432	19.3036	19.0293	19.2471	120391824.0
2012-12-06 10:30:00	AAPL	Stock	19.2464	19.5957	19.2004	19.5467	128313080.0
2012-12-06 11:00:00	AAPL	Stock	19.5479	19.6207	19.4682	19.575	60091248.0
2012-12-06 11:30:00	AAPL	Stock	19.5714	19.7611	19.5429	19.7009	66792236.0
2012-12-06 12:00:00	AAPL	Stock	19.7039	19.7589	19.4439	19.4921	64487192.0
2012-12-06 12:30:00	AAPL	Stock	19.4871	19.5939	19.4721	19.4782	40300316.0
2012-12-06 13:00:00	AAPL	Stock	19.48	19.5618	19.3329	19.4682	53397204.0
2012-12-06 13:30:00	AAPL	Stock	19.4643	19.625	19.4357	19.6239	35105532.0
2012-12-06 14:00:00	AAPL	Stock	19.625	19.6429	19.3954	19.5346	45067428.0
2012-12-06 14:30:00	AAPL	Stock	19.5314	19.5678	19.3446	19.413	49259028.0
2012-12-06 15:00:00	AAPL	Stock	19.4189	19.5246	19.3414	19.3693	43775060.0
2012-12-06 15:30:00	AAPL	Stock	19.375	19.5854	19.3107	19.5443	84210728.0
2012-12-06 16:00:00	AAPL	Stock	19.5446	19.5718	19.288	19.52	43438108.0
2012-12-06 16:30:00	AAPL	Stock	19.5457	19.6772	19.3756	19.5357	3209836.0
2012-12-06 17:00:00	AAPL	Stock	19.5357	19.5457	19.5321	19.5346	329224.0
2012-12-06 17:30:00	AAPL	Stock	19.5357	19.5532	19.5354	19.5393	202664.0
2012-12-06 18:00:00	AAPL	Stock	19.5489	19.5496	19.5361	19.5446	122444.0
2012-12-06 18:30:00	AAPL	Stock	19.5418	19.5446	19.5396	19.5429	65380.0
2012-12-06 19:00:00	AAPL	Stock	19.5418	19.5625	19.5418	19.5625	191968.0
2012-12-06 19:30:00	AAPL	Stock	19.5589	19.5893	19.5589	19.5854	361116.0
2012-12-06 06:00:00	MSFT	Stock	26.74	26.74	26.74	26.74	1500.0
2012-12-06 07:30:00	MSFT	Stock	26.74	26.75	26.74	26.75	888.0
2012-12-06 08:00:00	MSFT	Stock	26.79	26.84	26.75	26.8	46750.0
2012-12-06 08:30:00	MSFT	Stock	26.75	26.8	26.68	26.76	9789.0
2012-12-06 09:00:00	MSFT	Stock	26.72	26.82	26.7	26.8	46202.0
2012-12-06 09:30:00	MSFT	Stock	26.79	26.98	26.715	26.75	6454109.0
2012-12-06 10:00:00	MSFT	Stock	26.75	26.825	26.71	26.73	3304442.0
2012-12-06 10:30:00	MSFT	Stock	26.73	26.88	26.71	26.845	2188657.0
2012-12-06 11:00:00	MSFT	Stock	26.84	26.85	26.75	26.77	2179057.0
2012-12-06 11:30:00	MSFT	Stock	26.77	26.85	26.74	26.76	1798578.0
2012-12-06 12:00:00	MSFT	Stock	26.755	26.84	26.715	26.72	1924109.0
2012-12-06 12:30:00	MSFT	Stock	26.715	26.73	26.62	26.72	2404788.0
2012-12-06 13:00:00	MSFT	Stock	26.715	26.79	26.7	26.77	1428236.0
2012-12-06 13:30:00	MSFT	Stock	26.77	26.79	26.72	26.78	1260752.0
2012-12-06 14:00:00	MSFT	Stock	26.78	26.79	26.72	26.747	1505166.0
2012-12-06 14:30:00	MSFT	Stock	26.75	26.775	26.66	26.69	2888868.0
2012-12-06 15:00:00	MSFT	Stock	26.7	26.73	26.61	26.63	2248811.0
2012-12-06 15:30:00	MSFT	Stock	26.639	26.755	26.62	26.73	6448779.0

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

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