PREVIEW / stock_30min / 2014-02-20

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-20.parquet
  size:    1.6 MB
  rows:    82,664
  symbols: 3,551

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
2014-02-20 04:00:00	AAPL	Stock	19.1068	19.1214	19.1068	19.1214	19600.0
2014-02-20 04:30:00	AAPL	Stock	19.1118	19.1518	19.1082	19.1518	33600.0
2014-02-20 05:30:00	AAPL	Stock	19.14	19.14	19.14	19.14	2800.0
2014-02-20 06:00:00	AAPL	Stock	19.125	19.125	18.9532	18.9532	325080.0
2014-02-20 06:30:00	AAPL	Stock	18.9557	19.0282	18.9557	19.0129	126700.0
2014-02-20 07:00:00	AAPL	Stock	19.0129	19.0357	18.9664	19.0	683676.0
2014-02-20 07:30:00	AAPL	Stock	19.0171	19.0171	18.9911	18.9911	636636.0
2014-02-20 08:00:00	AAPL	Stock	19.0086	19.0661	18.9821	19.0375	765044.0
2014-02-20 08:30:00	AAPL	Stock	19.0396	19.0532	19.0236	19.0446	1063776.0
2014-02-20 09:00:00	AAPL	Stock	19.0532	19.0807	19.0236	19.0239	1265236.0
2014-02-20 09:30:00	AAPL	Stock	19.0354	19.1786	18.9057	18.9675	62446860.0
2014-02-20 10:00:00	AAPL	Stock	18.9643	19.1071	18.9475	19.085	25986464.0
2014-02-20 10:30:00	AAPL	Stock	19.0836	19.1268	19.0364	19.048	15711360.0
2014-02-20 11:00:00	AAPL	Stock	19.0493	19.0693	18.9932	18.9971	14129528.0
2014-02-20 11:30:00	AAPL	Stock	18.9971	18.9986	18.9368	18.9818	18383064.0
2014-02-20 12:00:00	AAPL	Stock	18.9821	18.9989	18.9486	18.96	11395832.0
2014-02-20 12:30:00	AAPL	Stock	18.9596	18.9961	18.93	18.9504	12594764.0
2014-02-20 13:00:00	AAPL	Stock	18.9554	18.9696	18.9286	18.9386	10036656.0
2014-02-20 13:30:00	AAPL	Stock	18.9364	18.9904	18.9286	18.9596	13382124.0
2014-02-20 14:00:00	AAPL	Stock	18.96	18.9775	18.9292	18.9357	8758904.0
2014-02-20 14:30:00	AAPL	Stock	18.9355	18.9457	18.8936	18.8979	13175036.0
2014-02-20 15:00:00	AAPL	Stock	18.8986	18.9946	18.8929	18.9662	14529704.0
2014-02-20 15:30:00	AAPL	Stock	18.9668	18.9918	18.9589	18.9679	23461564.0
2014-02-20 16:00:00	AAPL	Stock	18.9664	18.993	18.9661	18.9839	6731368.0
2014-02-20 16:30:00	AAPL	Stock	18.975	19.0562	18.9696	18.9732	1042608.0
2014-02-20 17:00:00	AAPL	Stock	18.9804	18.9857	18.9696	18.9696	136556.0
2014-02-20 17:30:00	AAPL	Stock	18.9732	18.9793	18.9732	18.9761	19600.0
2014-02-20 18:00:00	AAPL	Stock	18.9743	18.9754	18.9696	18.9754	77924.0
2014-02-20 18:30:00	AAPL	Stock	18.9814	18.9814	18.9732	18.9786	16800.0
2014-02-20 19:00:00	AAPL	Stock	18.9768	18.9768	18.9721	18.9721	15176.0
2014-02-20 19:30:00	AAPL	Stock	18.9746	18.9857	18.9746	18.9857	63476.0
2014-02-20 07:00:00	MSFT	Stock	37.35	37.35	37.35	37.35	200.0
2014-02-20 08:00:00	MSFT	Stock	37.32	37.34	37.32	37.33	6600.0
2014-02-20 08:30:00	MSFT	Stock	37.42	37.48	37.42	37.48	850.0
2014-02-20 09:00:00	MSFT	Stock	37.47	37.7	37.41	37.65	8058.0
2014-02-20 09:30:00	MSFT	Stock	37.57	37.82	37.48	37.495	4434672.0
2014-02-20 10:00:00	MSFT	Stock	37.495	37.6	37.395	37.55	2319679.0
2014-02-20 10:30:00	MSFT	Stock	37.55	37.6	37.52	37.55	1919540.0
2014-02-20 11:00:00	MSFT	Stock	37.55	37.57	37.5	37.57	1198587.0
2014-02-20 11:30:00	MSFT	Stock	37.57	37.74	37.56	37.68	1984547.0
2014-02-20 12:00:00	MSFT	Stock	37.68	37.745	37.62	37.74	1078873.0
2014-02-20 12:30:00	MSFT	Stock	37.74	37.79	37.72	37.775	1339706.0
2014-02-20 13:00:00	MSFT	Stock	37.775	37.79	37.73	37.76	760088.0
2014-02-20 13:30:00	MSFT	Stock	37.75	37.76	37.69	37.74	1013841.0
2014-02-20 14:00:00	MSFT	Stock	37.735	37.77	37.67	37.73	1174441.0
2014-02-20 14:30:00	MSFT	Stock	37.73	37.78	37.71	37.779	1105370.0
2014-02-20 15:00:00	MSFT	Stock	37.775	37.83	37.75	37.83	1765496.0
2014-02-20 15:30:00	MSFT	Stock	37.83	37.87	37.74	37.74	3728342.0
2014-02-20 16:00:00	MSFT	Stock	37.74	37.811	37.688	37.719	2401668.0
2014-02-20 16:30:00	MSFT	Stock	37.75	37.771	37.551	37.75	113728.0

> showing 50 of 82,664 rows — these rows as CSV

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