PREVIEW / stock_30min / 2013-08-29

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-29.parquet
  size:    1.5 MB
  rows:    78,166
  symbols: 3,519

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-08-29 04:00:00	AAPL	Stock	17.5821	17.5821	17.5821	17.5821	8400.0
2013-08-29 04:30:00	AAPL	Stock	17.5896	17.6464	17.5896	17.6429	66640.0
2013-08-29 05:00:00	AAPL	Stock	17.6136	17.6136	17.6136	17.6136	8400.0
2013-08-29 05:30:00	AAPL	Stock	17.6071	17.6071	17.5821	17.5821	5600.0
2013-08-29 07:00:00	AAPL	Stock	17.6036	17.6214	17.5893	17.6171	49840.0
2013-08-29 07:30:00	AAPL	Stock	17.6229	17.6786	17.6229	17.6589	204736.0
2013-08-29 08:00:00	AAPL	Stock	17.66	17.6607	17.5893	17.6354	805224.0
2013-08-29 08:30:00	AAPL	Stock	17.6346	17.66	17.6275	17.6393	784084.0
2013-08-29 09:00:00	AAPL	Stock	17.6389	17.6457	17.5439	17.5582	2239104.0
2013-08-29 09:30:00	AAPL	Stock	17.5661	17.7321	17.5561	17.7125	54084576.0
2013-08-29 10:00:00	AAPL	Stock	17.7139	17.7321	17.6468	17.6582	26065340.0
2013-08-29 10:30:00	AAPL	Stock	17.6568	17.7035	17.6461	17.6516	15849036.0
2013-08-29 11:00:00	AAPL	Stock	17.6536	17.7033	17.65	17.6918	10760036.0
2013-08-29 11:30:00	AAPL	Stock	17.6914	17.7275	17.6614	17.7232	15022084.0
2013-08-29 12:00:00	AAPL	Stock	17.7236	17.7261	17.6607	17.6786	10154984.0
2013-08-29 12:30:00	AAPL	Stock	17.6779	17.6821	17.6504	17.6646	8706544.0
2013-08-29 13:00:00	AAPL	Stock	17.6643	17.6861	17.6286	17.6386	13220284.0
2013-08-29 13:30:00	AAPL	Stock	17.6386	17.6407	17.6129	17.6357	10848236.0
2013-08-29 14:00:00	AAPL	Stock	17.635	17.6557	17.6196	17.6314	9837268.0
2013-08-29 14:30:00	AAPL	Stock	17.6314	17.6568	17.6254	17.6389	9013312.0
2013-08-29 15:00:00	AAPL	Stock	17.6379	17.6386	17.5614	17.57	16323888.0
2013-08-29 15:30:00	AAPL	Stock	17.57	17.5928	17.5404	17.5579	24504620.0
2013-08-29 16:00:00	AAPL	Stock	17.5618	17.6501	17.5411	17.5411	5407304.0
2013-08-29 16:30:00	AAPL	Stock	17.5514	17.6726	17.55	17.5679	1986768.0
2013-08-29 17:00:00	AAPL	Stock	17.5579	17.5682	17.5579	17.5682	198688.0
2013-08-29 17:30:00	AAPL	Stock	17.5632	17.5689	17.5632	17.5689	11228.0
2013-08-29 18:00:00	AAPL	Stock	17.5711	17.5814	17.57	17.5757	161448.0
2013-08-29 18:30:00	AAPL	Stock	17.5757	17.5804	17.5729	17.5743	58772.0
2013-08-29 19:00:00	AAPL	Stock	17.5768	17.5821	17.5768	17.5821	86912.0
2013-08-29 19:30:00	AAPL	Stock	17.5825	17.5857	17.5818	17.5818	116732.0
2013-08-29 07:30:00	MSFT	Stock	33.24	33.26	33.05	33.05	3000.0
2013-08-29 08:00:00	MSFT	Stock	33.25	33.25	33.12	33.12	1980.0
2013-08-29 08:30:00	MSFT	Stock	33.12	33.14	33.1	33.1	10400.0
2013-08-29 09:00:00	MSFT	Stock	33.1	33.12	32.91	32.94	93013.0
2013-08-29 09:30:00	MSFT	Stock	32.93	33.27	32.8	33.21	6109875.0
2013-08-29 10:00:00	MSFT	Stock	33.2	33.28	33.18	33.24	4160392.0
2013-08-29 10:30:00	MSFT	Stock	33.23	33.35	33.23	33.291	2213527.0
2013-08-29 11:00:00	MSFT	Stock	33.3	33.4	33.26	33.39	1844476.0
2013-08-29 11:30:00	MSFT	Stock	33.39	33.6	33.387	33.503	3878099.0
2013-08-29 12:00:00	MSFT	Stock	33.51	33.51	33.33	33.385	2375506.0
2013-08-29 12:30:00	MSFT	Stock	33.39	33.43	33.3	33.405	1419250.0
2013-08-29 13:00:00	MSFT	Stock	33.41	33.42	33.27	33.31	1776184.0
2013-08-29 13:30:00	MSFT	Stock	33.31	33.36	33.27	33.35	1699864.0
2013-08-29 14:00:00	MSFT	Stock	33.35	33.44	33.34	33.41	3434398.0
2013-08-29 14:30:00	MSFT	Stock	33.41	33.45	33.37	33.41	1786962.0
2013-08-29 15:00:00	MSFT	Stock	33.41	33.44	33.36	33.385	3064572.0
2013-08-29 15:30:00	MSFT	Stock	33.389	33.56	33.33	33.55	8479193.0
2013-08-29 16:00:00	MSFT	Stock	33.56	33.6	33.338	33.54	1632789.0
2013-08-29 16:30:00	MSFT	Stock	33.392	33.557	33.39	33.5	532405.0
2013-08-29 17:00:00	MSFT	Stock	33.5	33.52	33.5	33.52	2100.0

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

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