PREVIEW / stock_30min / 2012-12-31

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-31.parquet
  size:    1.5 MB
  rows:    77,717
  symbols: 3,523

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-31 06:30:00	AAPL	Stock	18.15	18.1732	18.15	18.1732	19600.0
2012-12-31 07:00:00	AAPL	Stock	18.15	18.175	18.0893	18.1071	138208.0
2012-12-31 07:30:00	AAPL	Stock	18.125	18.1429	18.0971	18.115	133168.0
2012-12-31 08:00:00	AAPL	Stock	18.1268	18.1689	18.0075	18.16	1285928.0
2012-12-31 08:30:00	AAPL	Stock	18.1679	18.3146	18.1579	18.2864	2963772.0
2012-12-31 09:00:00	AAPL	Stock	18.2857	18.2964	18.2143	18.2257	1550276.0
2012-12-31 09:30:00	AAPL	Stock	18.2332	18.7286	18.1786	18.7118	95853912.0
2012-12-31 10:00:00	AAPL	Stock	18.7118	18.7675	18.6304	18.7546	61721660.0
2012-12-31 10:30:00	AAPL	Stock	18.7557	18.8293	18.7197	18.7554	45622640.0
2012-12-31 11:00:00	AAPL	Stock	18.7571	18.8	18.6468	18.6789	33546128.0
2012-12-31 11:30:00	AAPL	Stock	18.6789	18.7632	18.6554	18.755	27895308.0
2012-12-31 12:00:00	AAPL	Stock	18.7589	18.7757	18.6386	18.7401	28216356.0
2012-12-31 12:30:00	AAPL	Stock	18.7411	18.8768	18.7307	18.7918	47672324.0
2012-12-31 13:00:00	AAPL	Stock	18.7925	18.8661	18.7264	18.8243	30232048.0
2012-12-31 13:30:00	AAPL	Stock	18.8246	18.9107	18.7496	18.7686	38185392.0
2012-12-31 14:00:00	AAPL	Stock	18.7714	18.9282	18.7679	18.9268	28270312.0
2012-12-31 14:30:00	AAPL	Stock	18.9268	19.1179	18.8964	19.0795	59190124.0
2012-12-31 15:00:00	AAPL	Stock	19.0739	19.1214	18.9832	18.9907	46582172.0
2012-12-31 15:30:00	AAPL	Stock	18.9932	19.1168	18.9543	19.035	68001528.0
2012-12-31 16:00:00	AAPL	Stock	19.0311	19.0518	18.7955	19.0018	20425608.0
2012-12-31 16:30:00	AAPL	Stock	19.0054	19.0578	18.8709	19.0143	2658432.0
2012-12-31 17:00:00	AAPL	Stock	19.0089	19.0261	19.0089	19.0243	170744.0
2012-12-31 17:30:00	AAPL	Stock	19.0239	19.0368	19.0179	19.03	503216.0
2012-12-31 18:00:00	AAPL	Stock	19.0336	19.0368	19.0225	19.0225	291116.0
2012-12-31 18:30:00	AAPL	Stock	19.0225	19.0246	19.0129	19.0196	122220.0
2012-12-31 19:00:00	AAPL	Stock	19.0143	19.0211	19.01	19.0143	119056.0
2012-12-31 19:30:00	AAPL	Stock	19.0143	19.0357	19.01	19.0143	374220.0
2012-12-31 07:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	4950.0
2012-12-31 08:00:00	MSFT	Stock	26.5	26.72	26.42	26.5	8735.0
2012-12-31 08:30:00	MSFT	Stock	26.52	26.65	26.52	26.64	13100.0
2012-12-31 09:00:00	MSFT	Stock	26.65	26.67	26.51	26.58	43748.0
2012-12-31 09:30:00	MSFT	Stock	26.58	26.67	26.5	26.583	3596135.0
2012-12-31 10:00:00	MSFT	Stock	26.584	26.6	26.5	26.51	3137767.0
2012-12-31 10:30:00	MSFT	Stock	26.51	26.54	26.4	26.42	2500733.0
2012-12-31 11:00:00	MSFT	Stock	26.416	26.49	26.37	26.4	2509285.0
2012-12-31 11:30:00	MSFT	Stock	26.39	26.45	26.39	26.43	1789329.0
2012-12-31 12:00:00	MSFT	Stock	26.43	26.49	26.42	26.481	1428664.0
2012-12-31 12:30:00	MSFT	Stock	26.48	26.68	26.48	26.53	3345846.0
2012-12-31 13:00:00	MSFT	Stock	26.54	26.62	26.46	26.585	2130861.0
2012-12-31 13:30:00	MSFT	Stock	26.58	26.65	26.48	26.533	2723068.0
2012-12-31 14:00:00	MSFT	Stock	26.535	26.59	26.52	26.545	1836335.0
2012-12-31 14:30:00	MSFT	Stock	26.55	26.73	26.53	26.71	3161612.0
2012-12-31 15:00:00	MSFT	Stock	26.715	26.75	26.55	26.6	3038524.0
2012-12-31 15:30:00	MSFT	Stock	26.606	26.77	26.6	26.72	7404079.0
2012-12-31 16:00:00	MSFT	Stock	26.72	26.79	26.44	26.76	3543782.0
2012-12-31 16:30:00	MSFT	Stock	26.76	26.78	26.219	26.77	40072.0
2012-12-31 17:00:00	MSFT	Stock	26.75	26.77	26.67	26.77	42013.0
2012-12-31 17:30:00	MSFT	Stock	26.75	26.78	26.72	26.72	7024.0
2012-12-31 18:00:00	MSFT	Stock	26.75	26.75	26.71	26.71	4250.0
2012-12-31 18:30:00	MSFT	Stock	26.72	26.72	26.72	26.72	1238.0

> showing 50 of 77,717 rows — these rows as CSV

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