PREVIEW / stock_30min / 2012-03-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-05.parquet
  size:    1.4 MB
  rows:    75,647
  symbols: 3,492

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-03-05 04:00:00	AAPL	Stock	19.4107	19.4107	19.4107	19.4107	2800.0
2012-03-05 04:30:00	AAPL	Stock	19.4436	19.4436	19.4436	19.4436	10220.0
2012-03-05 05:00:00	AAPL	Stock	19.4546	19.4621	19.4546	19.4621	19600.0
2012-03-05 05:30:00	AAPL	Stock	19.4643	19.4643	19.4643	19.4643	2800.0
2012-03-05 06:00:00	AAPL	Stock	19.4786	19.4904	19.4786	19.4904	17752.0
2012-03-05 06:30:00	AAPL	Stock	19.4821	19.4821	19.4679	19.4679	37800.0
2012-03-05 07:00:00	AAPL	Stock	19.4643	19.4643	19.4339	19.4407	211624.0
2012-03-05 07:30:00	AAPL	Stock	19.4429	19.4625	19.4429	19.4554	131964.0
2012-03-05 08:00:00	AAPL	Stock	19.4468	19.4789	19.4432	19.4561	2566004.0
2012-03-05 08:30:00	AAPL	Stock	19.4621	19.5057	19.4596	19.4929	1107176.0
2012-03-05 09:00:00	AAPL	Stock	19.4954	19.5179	19.4679	19.4857	2421272.0
2012-03-05 09:30:00	AAPL	Stock	19.4825	19.5529	19.4511	19.5052	65807476.0
2012-03-05 10:00:00	AAPL	Stock	19.506	19.5378	19.4321	19.4347	46569852.0
2012-03-05 10:30:00	AAPL	Stock	19.4375	19.4893	19.3968	19.4014	46909576.0
2012-03-05 11:00:00	AAPL	Stock	19.4035	19.4216	18.7857	19.18	190946028.0
2012-03-05 11:30:00	AAPL	Stock	19.1796	19.2582	19.0957	19.1943	86497824.0
2012-03-05 12:00:00	AAPL	Stock	19.1964	19.275	19.125	19.1339	52849496.0
2012-03-05 12:30:00	AAPL	Stock	19.1311	19.1786	19.0918	19.141	33431132.0
2012-03-05 13:00:00	AAPL	Stock	19.14	19.1814	19.1014	19.1544	26628784.0
2012-03-05 13:30:00	AAPL	Stock	19.1543	19.1593	18.9643	19.0271	47398988.0
2012-03-05 14:00:00	AAPL	Stock	19.0243	19.0804	18.9943	19.0382	34005328.0
2012-03-05 14:30:00	AAPL	Stock	19.0418	19.0536	18.9107	19.01	60392864.0
2012-03-05 15:00:00	AAPL	Stock	19.0104	19.1046	19.0	19.0746	46404988.0
2012-03-05 15:30:00	AAPL	Stock	19.0767	19.0832	18.9689	19.0486	53663596.0
2012-03-05 16:00:00	AAPL	Stock	19.0414	19.1779	19.0262	19.07	5172636.0
2012-03-05 16:30:00	AAPL	Stock	19.0457	19.0775	19.0085	19.075	603372.0
2012-03-05 17:00:00	AAPL	Stock	19.0732	19.0768	19.0414	19.0679	117544.0
2012-03-05 17:30:00	AAPL	Stock	19.0675	19.0675	19.0414	19.0464	727244.0
2012-03-05 18:00:00	AAPL	Stock	19.0529	19.0536	19.0418	19.0429	71512.0
2012-03-05 18:30:00	AAPL	Stock	19.0357	19.0414	19.0054	19.0071	205128.0
2012-03-05 19:00:00	AAPL	Stock	19.0071	19.0189	19.0043	19.0139	157584.0
2012-03-05 19:30:00	AAPL	Stock	19.0082	19.0139	18.9889	19.0071	759472.0
2012-03-05 04:00:00	MSFT	Stock	32.0	32.0	31.87	31.88	885.0
2012-03-05 07:00:00	MSFT	Stock	31.93	31.93	31.93	31.93	100.0
2012-03-05 07:30:00	MSFT	Stock	31.98	31.99	31.98	31.99	1400.0
2012-03-05 08:00:00	MSFT	Stock	31.99	32.15	31.98	32.05	6970.0
2012-03-05 08:30:00	MSFT	Stock	32.05	32.05	32.01	32.01	4002.0
2012-03-05 09:00:00	MSFT	Stock	32.05	32.05	31.98	32.02	11848.0
2012-03-05 09:30:00	MSFT	Stock	32.01	32.02	31.84	31.97	3601583.0
2012-03-05 10:00:00	MSFT	Stock	31.97	32.05	31.84	31.86	5717986.0
2012-03-05 10:30:00	MSFT	Stock	31.86	31.88	31.78	31.835	3352903.0
2012-03-05 11:00:00	MSFT	Stock	31.84	31.86	31.75	31.795	5040010.0
2012-03-05 11:30:00	MSFT	Stock	31.795	31.83	31.72	31.755	4527428.0
2012-03-05 12:00:00	MSFT	Stock	31.75	31.78	31.62	31.698	2533668.0
2012-03-05 12:30:00	MSFT	Stock	31.691	31.78	31.68	31.765	1694531.0
2012-03-05 13:00:00	MSFT	Stock	31.77	31.838	31.762	31.79	2110648.0
2012-03-05 13:30:00	MSFT	Stock	31.785	31.805	31.72	31.75	2119993.0
2012-03-05 14:00:00	MSFT	Stock	31.755	31.8	31.74	31.798	1516887.0
2012-03-05 14:30:00	MSFT	Stock	31.795	31.81	31.7	31.79	3009693.0
2012-03-05 15:00:00	MSFT	Stock	31.795	31.87	31.785	31.86	2639673.0

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

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