PREVIEW / stock_30min / 2013-02-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-26.parquet
  size:    1.4 MB
  rows:    75,908
  symbols: 3,475

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-02-26 04:00:00	AAPL	Stock	15.8571	15.8571	15.8571	15.8571	2800.0
2013-02-26 04:30:00	AAPL	Stock	15.8714	15.8714	15.8714	15.8714	25060.0
2013-02-26 05:30:00	AAPL	Stock	15.8393	15.8393	15.8304	15.8321	8400.0
2013-02-26 06:30:00	AAPL	Stock	15.8446	15.8568	15.8446	15.8568	5600.0
2013-02-26 07:00:00	AAPL	Stock	15.875	15.8932	15.8614	15.875	143360.0
2013-02-26 07:30:00	AAPL	Stock	15.8714	15.8929	15.8636	15.8661	184996.0
2013-02-26 08:00:00	AAPL	Stock	15.8679	15.8907	15.8071	15.8571	725228.0
2013-02-26 08:30:00	AAPL	Stock	15.855	15.8671	15.8411	15.8629	678076.0
2013-02-26 09:00:00	AAPL	Stock	15.8671	15.8829	15.8411	15.8411	1102164.0
2013-02-26 09:30:00	AAPL	Stock	15.8414	15.8821	15.7054	15.8268	65169608.0
2013-02-26 10:00:00	AAPL	Stock	15.8225	15.8604	15.6896	15.6896	48141072.0
2013-02-26 10:30:00	AAPL	Stock	15.6896	15.7821	15.6732	15.7118	30901920.0
2013-02-26 11:00:00	AAPL	Stock	15.7093	15.7286	15.6575	15.6743	27362860.0
2013-02-26 11:30:00	AAPL	Stock	15.6718	15.6982	15.6307	15.6913	25236708.0
2013-02-26 12:00:00	AAPL	Stock	15.6929	15.7139	15.6571	15.6925	14418264.0
2013-02-26 12:30:00	AAPL	Stock	15.6925	15.7275	15.6682	15.6989	17592820.0
2013-02-26 13:00:00	AAPL	Stock	15.6982	15.7275	15.6779	15.6957	13461056.0
2013-02-26 13:30:00	AAPL	Stock	15.6957	16.0039	15.6904	15.9514	62177864.0
2013-02-26 14:00:00	AAPL	Stock	15.9521	16.0487	15.925	16.0071	49573832.0
2013-02-26 14:30:00	AAPL	Stock	16.0064	16.1043	15.9821	16.0946	40280128.0
2013-02-26 15:00:00	AAPL	Stock	16.0921	16.1264	15.9732	16.0068	46082120.0
2013-02-26 15:30:00	AAPL	Stock	16.0064	16.0871	15.9882	16.0336	39054372.0
2013-02-26 16:00:00	AAPL	Stock	16.0321	16.0357	15.8607	16.0093	12834612.0
2013-02-26 16:30:00	AAPL	Stock	16.0071	16.014	15.6972	16.0071	364448.0
2013-02-26 17:00:00	AAPL	Stock	16.0079	16.0346	16.0	16.0	266140.0
2013-02-26 17:30:00	AAPL	Stock	16.0	16.0321	15.9968	16.0025	215880.0
2013-02-26 18:00:00	AAPL	Stock	16.0	16.0018	15.9864	15.9929	418712.0
2013-02-26 18:30:00	AAPL	Stock	15.9886	16.0	15.9832	15.9886	183932.0
2013-02-26 19:00:00	AAPL	Stock	15.9982	16.0107	15.9982	16.0046	102172.0
2013-02-26 19:30:00	AAPL	Stock	16.0025	16.0068	15.9929	15.9929	404852.0
2013-02-26 07:30:00	MSFT	Stock	27.37	27.37	27.37	27.37	300.0
2013-02-26 08:00:00	MSFT	Stock	27.33	27.45	27.33	27.41	7067.0
2013-02-26 08:30:00	MSFT	Stock	27.44	27.49	27.41	27.49	2017.0
2013-02-26 09:00:00	MSFT	Stock	27.49	27.51	27.37	27.37	73685.0
2013-02-26 09:30:00	MSFT	Stock	27.39	27.55	27.36	27.54	4069154.0
2013-02-26 10:00:00	MSFT	Stock	27.55	27.6	27.445	27.48	4212498.0
2013-02-26 10:30:00	MSFT	Stock	27.475	27.54	27.45	27.45	3316575.0
2013-02-26 11:00:00	MSFT	Stock	27.455	27.485	27.38	27.44	3188651.0
2013-02-26 11:30:00	MSFT	Stock	27.43	27.475	27.38	27.42	2517351.0
2013-02-26 12:00:00	MSFT	Stock	27.422	27.44	27.37	27.38	3116042.0
2013-02-26 12:30:00	MSFT	Stock	27.38	27.43	27.38	27.39	4837027.0
2013-02-26 13:00:00	MSFT	Stock	27.39	27.41	27.34	27.36	4116632.0
2013-02-26 13:30:00	MSFT	Stock	27.365	27.393	27.34	27.365	2464904.0
2013-02-26 14:00:00	MSFT	Stock	27.37	27.44	27.35	27.4	2074182.0
2013-02-26 14:30:00	MSFT	Stock	27.405	27.41	27.35	27.39	3038426.0
2013-02-26 15:00:00	MSFT	Stock	27.39	27.39	27.34	27.389	4040779.0
2013-02-26 15:30:00	MSFT	Stock	27.39	27.43	27.35	27.37	4968460.0
2013-02-26 16:00:00	MSFT	Stock	27.38	27.411	27.35	27.37	2976463.0
2013-02-26 16:30:00	MSFT	Stock	27.36	27.4	27.36	27.4	21626.0
2013-02-26 17:00:00	MSFT	Stock	27.37	27.37	27.37	27.37	14350.0

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

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