PREVIEW / stock_30min / 2012-02-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-17.parquet
  size:    1.4 MB
  rows:    76,862
  symbols: 3,561

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
2012-02-17 04:00:00	AAPL	Stock	18.0443	18.1068	18.0443	18.1025	64400.0
2012-02-17 04:30:00	AAPL	Stock	18.0857	18.1071	18.0518	18.0518	195020.0
2012-02-17 05:00:00	AAPL	Stock	18.0604	18.0604	18.0204	18.0204	84364.0
2012-02-17 05:30:00	AAPL	Stock	18.0275	18.0275	18.0239	18.0268	18200.0
2012-02-17 06:00:00	AAPL	Stock	18.0357	18.0446	18.0357	18.0446	28000.0
2012-02-17 06:30:00	AAPL	Stock	18.0393	18.0393	18.0268	18.0268	68460.0
2012-02-17 07:00:00	AAPL	Stock	18.0179	18.05	17.9875	18.0411	393708.0
2012-02-17 07:30:00	AAPL	Stock	18.0386	18.05	18.0029	18.0186	342720.0
2012-02-17 08:00:00	AAPL	Stock	18.0232	18.0468	17.9643	18.0029	1422764.0
2012-02-17 08:30:00	AAPL	Stock	18.0032	18.0154	17.9786	18.0057	1455776.0
2012-02-17 09:00:00	AAPL	Stock	18.0064	18.0357	17.9661	17.9686	3412696.0
2012-02-17 09:30:00	AAPL	Stock	17.9686	18.1346	17.9179	18.0571	138271028.0
2012-02-17 10:00:00	AAPL	Stock	18.0582	18.095	18.0179	18.0589	40491948.0
2012-02-17 10:30:00	AAPL	Stock	18.0607	18.0804	18.0214	18.0411	30558584.0
2012-02-17 11:00:00	AAPL	Stock	18.0432	18.0432	17.875	17.9221	57228304.0
2012-02-17 11:30:00	AAPL	Stock	17.9225	17.9968	17.9021	17.9696	26996816.0
2012-02-17 12:00:00	AAPL	Stock	17.9714	18.0096	17.9304	17.9609	24930080.0
2012-02-17 12:30:00	AAPL	Stock	17.9629	17.9921	17.9464	17.9607	13082188.0
2012-02-17 13:00:00	AAPL	Stock	17.9606	17.9785	17.9514	17.9639	10306688.0
2012-02-17 13:30:00	AAPL	Stock	17.9632	17.9732	17.9546	17.9617	12483156.0
2012-02-17 14:00:00	AAPL	Stock	17.9618	17.9671	17.9046	17.9307	19610080.0
2012-02-17 14:30:00	AAPL	Stock	17.9311	17.9339	17.8829	17.8964	18710356.0
2012-02-17 15:00:00	AAPL	Stock	17.895	17.9729	17.8679	17.9654	33635588.0
2012-02-17 15:30:00	AAPL	Stock	17.9686	17.9721	17.87	17.9321	70296128.0
2012-02-17 16:00:00	AAPL	Stock	17.9329	17.9825	17.9089	17.9575	13470296.0
2012-02-17 16:30:00	AAPL	Stock	17.9554	17.98	17.9486	17.98	3038756.0
2012-02-17 17:00:00	AAPL	Stock	17.9818	17.9879	17.9346	17.975	473368.0
2012-02-17 17:30:00	AAPL	Stock	17.9786	17.9786	17.9329	17.9714	148316.0
2012-02-17 18:00:00	AAPL	Stock	17.9736	17.9821	17.9539	17.9621	275240.0
2012-02-17 18:30:00	AAPL	Stock	17.955	17.96	17.9536	17.9593	219968.0
2012-02-17 19:00:00	AAPL	Stock	17.9636	17.9743	17.9636	17.965	128100.0
2012-02-17 19:30:00	AAPL	Stock	17.9661	17.9768	17.9579	17.975	310072.0
2012-02-17 07:00:00	MSFT	Stock	31.27	31.27	31.25	31.25	4260.0
2012-02-17 07:30:00	MSFT	Stock	31.3	31.3	31.27	31.27	2995.0
2012-02-17 08:00:00	MSFT	Stock	31.28	31.3	31.2	31.2	21028.0
2012-02-17 08:30:00	MSFT	Stock	31.24	31.29	31.22	31.25	2200.0
2012-02-17 09:00:00	MSFT	Stock	31.22	31.29	31.19	31.22	140560.0
2012-02-17 09:30:00	MSFT	Stock	31.19	31.32	31.11	31.133	6788841.0
2012-02-17 10:00:00	MSFT	Stock	31.139	31.225	31.08	31.19	5857738.0
2012-02-17 10:30:00	MSFT	Stock	31.19	31.28	31.17	31.27	4323622.0
2012-02-17 11:00:00	MSFT	Stock	31.264	31.27	31.11	31.13	4301090.0
2012-02-17 11:30:00	MSFT	Stock	31.135	31.18	31.03	31.08	4098926.0
2012-02-17 12:00:00	MSFT	Stock	31.08	31.09	30.95	31.0	4148794.0
2012-02-17 12:30:00	MSFT	Stock	30.992	31.085	30.99	31.073	2762361.0
2012-02-17 13:00:00	MSFT	Stock	31.078	31.08	30.99	31.05	2250155.0
2012-02-17 13:30:00	MSFT	Stock	31.043	31.08	31.03	31.05	1985117.0
2012-02-17 14:00:00	MSFT	Stock	31.055	31.22	31.05	31.21	4663076.0
2012-02-17 14:30:00	MSFT	Stock	31.21	31.22	31.15	31.175	2291133.0
2012-02-17 15:00:00	MSFT	Stock	31.18	31.262	31.17	31.23	3609254.0
2012-02-17 15:30:00	MSFT	Stock	31.235	31.27	31.18	31.26	9687636.0

> showing 50 of 76,862 rows — these rows as CSV

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