PREVIEW / stock_30min / 2013-10-28

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-28.parquet
  size:    1.5 MB
  rows:    80,743
  symbols: 3,528

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
2013-10-28 04:00:00	AAPL	Stock	18.8518	18.8857	18.8518	18.8854	19600.0
2013-10-28 04:30:00	AAPL	Stock	18.9036	18.9286	18.9036	18.9286	81368.0
2013-10-28 05:00:00	AAPL	Stock	18.9314	18.9429	18.9214	18.9214	19600.0
2013-10-28 05:30:00	AAPL	Stock	18.9068	18.9286	18.9018	18.9286	93100.0
2013-10-28 06:00:00	AAPL	Stock	18.9268	18.9268	18.8571	18.8696	130900.0
2013-10-28 06:30:00	AAPL	Stock	18.9025	18.9025	18.8607	18.8607	66416.0
2013-10-28 07:00:00	AAPL	Stock	18.8571	18.8786	18.8393	18.8779	289548.0
2013-10-28 07:30:00	AAPL	Stock	18.8786	18.8893	18.8393	18.8814	250096.0
2013-10-28 08:00:00	AAPL	Stock	18.8807	18.8946	18.8321	18.8604	962668.0
2013-10-28 08:30:00	AAPL	Stock	18.8596	18.8929	18.8479	18.8896	1090684.0
2013-10-28 09:00:00	AAPL	Stock	18.8889	18.9025	18.8646	18.9025	1622880.0
2013-10-28 09:30:00	AAPL	Stock	18.8932	18.9414	18.6861	18.7239	59987508.0
2013-10-28 10:00:00	AAPL	Stock	18.7189	18.8261	18.7161	18.7535	28063756.0
2013-10-28 10:30:00	AAPL	Stock	18.7566	18.7979	18.7339	18.7939	18896752.0
2013-10-28 11:00:00	AAPL	Stock	18.7944	18.8379	18.7593	18.8378	20355272.0
2013-10-28 11:30:00	AAPL	Stock	18.8314	18.8378	18.7739	18.7839	13504876.0
2013-10-28 12:00:00	AAPL	Stock	18.7857	18.8607	18.7714	18.8607	16849588.0
2013-10-28 12:30:00	AAPL	Stock	18.8607	18.8996	18.8575	18.8861	25582760.0
2013-10-28 13:00:00	AAPL	Stock	18.8861	18.8929	18.8521	18.8709	14615244.0
2013-10-28 13:30:00	AAPL	Stock	18.8707	18.9179	18.8436	18.9106	19030704.0
2013-10-28 14:00:00	AAPL	Stock	18.9107	18.9643	18.9057	18.9629	32623696.0
2013-10-28 14:30:00	AAPL	Stock	18.9604	18.9632	18.9314	18.9596	22398040.0
2013-10-28 15:00:00	AAPL	Stock	18.9596	18.9596	18.8607	18.8996	35388948.0
2013-10-28 15:30:00	AAPL	Stock	18.8975	18.9286	18.8393	18.91	56412104.0
2013-10-28 16:00:00	AAPL	Stock	18.91	18.9746	18.822	18.9643	14282996.0
2013-10-28 16:30:00	AAPL	Stock	18.9657	19.3571	17.9646	18.4839	75100088.0
2013-10-28 17:00:00	AAPL	Stock	18.4821	18.9064	18.3179	18.6857	26867764.0
2013-10-28 17:30:00	AAPL	Stock	18.6986	19.2029	18.5718	18.9	33975172.0
2013-10-28 18:00:00	AAPL	Stock	18.9107	18.9143	18.8168	18.8996	5428108.0
2013-10-28 18:30:00	AAPL	Stock	18.8996	18.9354	18.8357	18.8536	1745072.0
2013-10-28 19:00:00	AAPL	Stock	18.8521	18.9064	18.7536	18.7768	1904476.0
2013-10-28 19:30:00	AAPL	Stock	18.7768	18.7821	18.6786	18.6939	2155860.0
2013-10-28 06:00:00	MSFT	Stock	35.9	35.9	35.84	35.9	2100.0
2013-10-28 06:30:00	MSFT	Stock	35.9	36.02	35.9	35.98	900.0
2013-10-28 07:00:00	MSFT	Stock	35.98	35.98	35.85	35.85	5799.0
2013-10-28 07:30:00	MSFT	Stock	35.8	35.8	35.8	35.8	1350.0
2013-10-28 08:00:00	MSFT	Stock	35.76	35.94	35.73	35.73	26797.0
2013-10-28 08:30:00	MSFT	Stock	35.73	35.77	35.73	35.73	7100.0
2013-10-28 09:00:00	MSFT	Stock	35.75	35.75	35.63	35.63	31581.0
2013-10-28 09:30:00	MSFT	Stock	35.66	35.73	35.31	35.321	6398934.0
2013-10-28 10:00:00	MSFT	Stock	35.32	35.38	35.27	35.33	3885719.0
2013-10-28 10:30:00	MSFT	Stock	35.325	35.4	35.31	35.33	2449706.0
2013-10-28 11:00:00	MSFT	Stock	35.329	35.38	35.29	35.365	1862160.0
2013-10-28 11:30:00	MSFT	Stock	35.37	35.49	35.36	35.453	2394480.0
2013-10-28 12:00:00	MSFT	Stock	35.45	35.54	35.44	35.505	2179892.0
2013-10-28 12:30:00	MSFT	Stock	35.505	35.53	35.45	35.5	1350184.0
2013-10-28 13:00:00	MSFT	Stock	35.5	35.52	35.46	35.48	1857398.0
2013-10-28 13:30:00	MSFT	Stock	35.49	35.54	35.47	35.505	1532889.0
2013-10-28 14:00:00	MSFT	Stock	35.5	35.58	35.48	35.53	1893878.0
2013-10-28 14:30:00	MSFT	Stock	35.53	35.587	35.5	35.52	1983923.0

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

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