PREVIEW / stock_30min / 2013-09-06

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-06.parquet
  size:    1.5 MB
  rows:    78,236
  symbols: 3,507

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-09-06 05:00:00	AAPL	Stock	17.7696	17.7696	17.7696	17.7696	12040.0
2013-09-06 05:30:00	AAPL	Stock	17.7607	17.7661	17.7607	17.7657	11200.0
2013-09-06 06:00:00	AAPL	Stock	17.7661	17.7814	17.7661	17.7814	5600.0
2013-09-06 07:00:00	AAPL	Stock	17.7996	17.8357	17.7857	17.8032	356748.0
2013-09-06 07:30:00	AAPL	Stock	17.8036	17.8479	17.8029	17.8393	376320.0
2013-09-06 08:00:00	AAPL	Stock	17.8393	17.8532	17.7686	17.8036	1703688.0
2013-09-06 08:30:00	AAPL	Stock	17.7946	17.8321	17.7696	17.8218	2194780.0
2013-09-06 09:00:00	AAPL	Stock	17.8218	17.8264	17.7904	17.805	1662304.0
2013-09-06 09:30:00	AAPL	Stock	17.8046	17.8196	17.5739	17.5893	70735644.0
2013-09-06 10:00:00	AAPL	Stock	17.5861	17.6536	17.4982	17.6275	50267308.0
2013-09-06 10:30:00	AAPL	Stock	17.6275	17.7418	17.6107	17.73	29602048.0
2013-09-06 11:00:00	AAPL	Stock	17.725	17.7618	17.6871	17.6964	19373844.0
2013-09-06 11:30:00	AAPL	Stock	17.6986	17.7311	17.6864	17.7218	10942428.0
2013-09-06 12:00:00	AAPL	Stock	17.7243	17.7779	17.7214	17.7657	11952920.0
2013-09-06 12:30:00	AAPL	Stock	17.7664	17.775	17.7239	17.7479	10206000.0
2013-09-06 13:00:00	AAPL	Stock	17.7436	17.75	17.7307	17.7459	7226100.0
2013-09-06 13:30:00	AAPL	Stock	17.7471	17.7857	17.7396	17.7686	13046376.0
2013-09-06 14:00:00	AAPL	Stock	17.7686	17.7854	17.7472	17.7686	10097136.0
2013-09-06 14:30:00	AAPL	Stock	17.7691	17.8196	17.7691	17.7916	18568760.0
2013-09-06 15:00:00	AAPL	Stock	17.7921	17.7943	17.7075	17.7417	20030164.0
2013-09-06 15:30:00	AAPL	Stock	17.7404	17.835	17.7146	17.7943	57215144.0
2013-09-06 16:00:00	AAPL	Stock	17.7925	17.8739	17.5937	17.7936	16423988.0
2013-09-06 16:30:00	AAPL	Stock	17.8618	17.8693	17.7429	17.8586	2003148.0
2013-09-06 17:00:00	AAPL	Stock	17.8589	17.8632	17.7936	17.8571	1267420.0
2013-09-06 17:30:00	AAPL	Stock	17.8607	17.8607	17.8543	17.8571	227584.0
2013-09-06 18:00:00	AAPL	Stock	17.8543	17.8804	17.8536	17.8804	437276.0
2013-09-06 18:30:00	AAPL	Stock	17.8818	17.8886	17.8589	17.8611	320320.0
2013-09-06 19:00:00	AAPL	Stock	17.8639	17.875	17.8639	17.875	211624.0
2013-09-06 19:30:00	AAPL	Stock	17.8782	17.8925	17.8782	17.8857	349412.0
2013-09-06 06:30:00	MSFT	Stock	31.3	31.3	31.3	31.3	800.0
2013-09-06 07:00:00	MSFT	Stock	31.34	31.35	31.34	31.35	3500.0
2013-09-06 07:30:00	MSFT	Stock	31.35	31.47	31.35	31.36	13900.0
2013-09-06 08:00:00	MSFT	Stock	31.39	31.4	31.32	31.33	33670.0
2013-09-06 08:30:00	MSFT	Stock	31.33	31.39	31.32	31.35	244101.0
2013-09-06 09:00:00	MSFT	Stock	31.34	31.36	31.28	31.3	220638.0
2013-09-06 09:30:00	MSFT	Stock	31.3	31.39	31.21	31.265	14226292.0
2013-09-06 10:00:00	MSFT	Stock	31.27	31.32	31.13	31.21	9760358.0
2013-09-06 10:30:00	MSFT	Stock	31.21	31.3	31.2	31.3	4995163.0
2013-09-06 11:00:00	MSFT	Stock	31.3	31.37	31.23	31.29	3445374.0
2013-09-06 11:30:00	MSFT	Stock	31.29	31.31	31.21	31.25	3150871.0
2013-09-06 12:00:00	MSFT	Stock	31.25	31.29	31.23	31.25	2588996.0
2013-09-06 12:30:00	MSFT	Stock	31.25	31.27	31.21	31.26	4241684.0
2013-09-06 13:00:00	MSFT	Stock	31.26	31.27	31.21	31.236	2615216.0
2013-09-06 13:30:00	MSFT	Stock	31.235	31.31	31.22	31.277	3763151.0
2013-09-06 14:00:00	MSFT	Stock	31.277	31.29	31.25	31.27	1915100.0
2013-09-06 14:30:00	MSFT	Stock	31.27	31.29	31.22	31.25	3601606.0
2013-09-06 15:00:00	MSFT	Stock	31.26	31.26	31.21	31.239	10086610.0
2013-09-06 15:30:00	MSFT	Stock	31.24	31.25	31.15	31.16	5577713.0
2013-09-06 16:00:00	MSFT	Stock	31.15	31.282	31.1	31.19	1728628.0
2013-09-06 16:30:00	MSFT	Stock	31.16	31.24	31.154	31.17	21331.0

> showing 50 of 78,236 rows — these rows as CSV

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