PREVIEW / stock_30min / 2013-07-02

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-02.parquet
  size:    1.5 MB
  rows:    78,362
  symbols: 3,503

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-07-02 04:00:00	AAPL	Stock	14.6829	14.6829	14.6829	14.6829	16800.0
2013-07-02 04:30:00	AAPL	Stock	14.6875	14.6893	14.6875	14.6893	8400.0
2013-07-02 05:30:00	AAPL	Stock	14.6821	14.6821	14.6821	14.6821	2800.0
2013-07-02 06:00:00	AAPL	Stock	14.655	14.655	14.6518	14.655	11200.0
2013-07-02 06:30:00	AAPL	Stock	14.6779	14.6779	14.6779	14.6779	2800.0
2013-07-02 07:00:00	AAPL	Stock	14.6729	14.7311	14.6607	14.7307	368172.0
2013-07-02 07:30:00	AAPL	Stock	14.7311	14.7357	14.6632	14.6804	496384.0
2013-07-02 08:00:00	AAPL	Stock	14.6843	14.7321	14.5939	14.6107	1418648.0
2013-07-02 08:30:00	AAPL	Stock	14.5971	14.6375	14.5875	14.6375	1183364.0
2013-07-02 09:00:00	AAPL	Stock	14.6375	14.6589	14.6143	14.6364	1456168.0
2013-07-02 09:30:00	AAPL	Stock	14.6364	14.9139	14.6239	14.9007	90899788.0
2013-07-02 10:00:00	AAPL	Stock	14.9029	14.9811	14.8846	14.9507	57175104.0
2013-07-02 10:30:00	AAPL	Stock	14.9579	14.9746	14.925	14.9654	30559060.0
2013-07-02 11:00:00	AAPL	Stock	14.9675	15.0239	14.9432	15.0039	28126644.0
2013-07-02 11:30:00	AAPL	Stock	15.0	15.0582	14.9957	15.0239	28421232.0
2013-07-02 12:00:00	AAPL	Stock	15.0235	15.0429	14.9582	14.9582	21737296.0
2013-07-02 12:30:00	AAPL	Stock	14.9582	14.9839	14.9346	14.9636	13883604.0
2013-07-02 13:00:00	AAPL	Stock	14.9622	14.9786	14.8672	14.91	23248792.0
2013-07-02 13:30:00	AAPL	Stock	14.9107	14.9107	14.8268	14.856	24660468.0
2013-07-02 14:00:00	AAPL	Stock	14.8543	14.8692	14.7768	14.81	25520516.0
2013-07-02 14:30:00	AAPL	Stock	14.8096	14.8668	14.7796	14.8421	26157628.0
2013-07-02 15:00:00	AAPL	Stock	14.8457	14.8796	14.8218	14.8483	16311792.0
2013-07-02 15:30:00	AAPL	Stock	14.8447	14.9786	14.8292	14.9468	52975132.0
2013-07-02 16:00:00	AAPL	Stock	14.9468	14.9626	14.8841	14.9439	18733008.0
2013-07-02 16:30:00	AAPL	Stock	14.9439	14.9625	14.8487	14.9625	297416.0
2013-07-02 17:00:00	AAPL	Stock	14.9621	14.9721	14.9468	14.9714	3095708.0
2013-07-02 17:30:00	AAPL	Stock	14.9714	14.9714	14.9643	14.9696	43484.0
2013-07-02 18:00:00	AAPL	Stock	14.9625	14.9679	14.9571	14.9643	111916.0
2013-07-02 18:30:00	AAPL	Stock	14.9696	14.9711	14.9643	14.9643	68656.0
2013-07-02 19:00:00	AAPL	Stock	14.9643	14.9671	14.9607	14.9646	55412.0
2013-07-02 19:30:00	AAPL	Stock	14.9593	14.9746	14.9589	14.9732	81732.0
2013-07-02 08:00:00	MSFT	Stock	34.41	34.41	34.18	34.29	1824.0
2013-07-02 08:30:00	MSFT	Stock	34.36	34.36	34.36	34.36	40400.0
2013-07-02 09:00:00	MSFT	Stock	34.26	34.48	34.26	34.41	16200.0
2013-07-02 09:30:00	MSFT	Stock	34.42	34.44	34.0	34.29	5882265.0
2013-07-02 10:00:00	MSFT	Stock	34.29	34.35	34.21	34.27	3162493.0
2013-07-02 10:30:00	MSFT	Stock	34.26	34.36	34.23	34.28	2528756.0
2013-07-02 11:00:00	MSFT	Stock	34.285	34.31	34.1	34.11	2027850.0
2013-07-02 11:30:00	MSFT	Stock	34.105	34.25	34.08	34.2	1596287.0
2013-07-02 12:00:00	MSFT	Stock	34.21	34.21	33.99	33.99	1344663.0
2013-07-02 12:30:00	MSFT	Stock	33.995	34.13	33.98	34.075	1550461.0
2013-07-02 13:00:00	MSFT	Stock	34.08	34.08	33.99	33.995	780274.0
2013-07-02 13:30:00	MSFT	Stock	33.99	34.01	33.83	33.889	2000780.0
2013-07-02 14:00:00	MSFT	Stock	33.89	33.895	33.65	33.695	2863140.0
2013-07-02 14:30:00	MSFT	Stock	33.69	33.79	33.63	33.765	2131848.0
2013-07-02 15:00:00	MSFT	Stock	33.76	33.865	33.75	33.83	2142304.0
2013-07-02 15:30:00	MSFT	Stock	33.825	34.0	33.76	33.95	5831933.0
2013-07-02 16:00:00	MSFT	Stock	33.96	34.256	33.87	33.96	2665413.0
2013-07-02 16:30:00	MSFT	Stock	33.96	33.96	33.75	33.94	25615.0
2013-07-02 17:00:00	MSFT	Stock	33.87	33.96	33.87	33.96	853570.0

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

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