PREVIEW / stock_30min / 2012-08-21

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-21.parquet
  size:    1.4 MB
  rows:    74,888
  symbols: 3,463

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-08-21 04:00:00	AAPL	Stock	23.8714	23.9286	23.8232	23.8475	200900.0
2012-08-21 04:30:00	AAPL	Stock	23.8464	23.8518	23.8282	23.85	34160.0
2012-08-21 05:00:00	AAPL	Stock	23.8614	23.8696	23.8614	23.8696	26600.0
2012-08-21 05:30:00	AAPL	Stock	23.8696	23.8818	23.8643	23.8679	101360.0
2012-08-21 06:00:00	AAPL	Stock	23.8679	23.8929	23.8679	23.8857	92400.0
2012-08-21 06:30:00	AAPL	Stock	23.8857	23.9075	23.8839	23.8929	61600.0
2012-08-21 07:00:00	AAPL	Stock	23.8929	23.9232	23.8682	23.8804	509404.0
2012-08-21 07:30:00	AAPL	Stock	23.8768	23.9089	23.8696	23.9011	625128.0
2012-08-21 08:00:00	AAPL	Stock	23.9014	23.9675	23.8464	23.9464	4090940.0
2012-08-21 08:30:00	AAPL	Stock	23.9493	23.9757	23.9446	23.9661	1716680.0
2012-08-21 09:00:00	AAPL	Stock	23.9643	23.965	23.9289	23.9586	2594844.0
2012-08-21 09:30:00	AAPL	Stock	23.9579	24.1029	23.8704	23.9754	132508376.0
2012-08-21 10:00:00	AAPL	Stock	23.9784	24.0054	23.9221	23.9879	46460260.0
2012-08-21 10:30:00	AAPL	Stock	23.9879	23.9964	23.5839	23.6284	94892420.0
2012-08-21 11:00:00	AAPL	Stock	23.6277	23.73	23.4825	23.5786	96634608.0
2012-08-21 11:30:00	AAPL	Stock	23.5747	23.6818	23.554	23.5643	43657012.0
2012-08-21 12:00:00	AAPL	Stock	23.5675	23.5811	23.4286	23.4975	50900304.0
2012-08-21 12:30:00	AAPL	Stock	23.5014	23.5404	23.3218	23.4218	43554476.0
2012-08-21 13:00:00	AAPL	Stock	23.4214	23.4457	23.2925	23.3139	33165860.0
2012-08-21 13:30:00	AAPL	Stock	23.3139	23.3636	23.2261	23.3611	45792880.0
2012-08-21 14:00:00	AAPL	Stock	23.3636	23.5725	23.3443	23.5553	70690760.0
2012-08-21 14:30:00	AAPL	Stock	23.555	23.5714	23.4154	23.44	31986220.0
2012-08-21 15:00:00	AAPL	Stock	23.4436	23.4639	23.3036	23.4418	38830456.0
2012-08-21 15:30:00	AAPL	Stock	23.4382	23.5268	23.3964	23.4357	50395240.0
2012-08-21 16:00:00	AAPL	Stock	23.4364	23.7624	23.4236	23.4646	9133208.0
2012-08-21 16:30:00	AAPL	Stock	23.4593	23.4854	23.4366	23.4782	1170036.0
2012-08-21 17:00:00	AAPL	Stock	23.4366	23.4929	23.4307	23.4714	2525404.0
2012-08-21 17:30:00	AAPL	Stock	23.4746	23.5382	23.4596	23.4596	570052.0
2012-08-21 18:00:00	AAPL	Stock	23.4596	23.4629	23.4364	23.4389	154784.0
2012-08-21 18:30:00	AAPL	Stock	23.4407	23.4454	23.4286	23.4286	262304.0
2012-08-21 19:00:00	AAPL	Stock	23.4357	23.4429	23.4286	23.4375	219800.0
2012-08-21 19:30:00	AAPL	Stock	23.4371	23.4371	23.3929	23.4	313908.0
2012-08-21 07:30:00	MSFT	Stock	30.81	30.82	30.81	30.82	478.0
2012-08-21 08:00:00	MSFT	Stock	30.82	30.82	30.82	30.82	622.0
2012-08-21 08:30:00	MSFT	Stock	30.82	30.85	30.82	30.85	6217.0
2012-08-21 09:00:00	MSFT	Stock	30.88	30.88	30.74	30.79	48179.0
2012-08-21 09:30:00	MSFT	Stock	30.76	30.87	30.61	30.84	3520642.0
2012-08-21 10:00:00	MSFT	Stock	30.85	30.88	30.8	30.86	1952963.0
2012-08-21 10:30:00	MSFT	Stock	30.855	30.94	30.85	30.92	2676260.0
2012-08-21 11:00:00	MSFT	Stock	30.92	30.96	30.87	30.9	1913177.0
2012-08-21 11:30:00	MSFT	Stock	30.89	30.92	30.79	30.809	1727826.0
2012-08-21 12:00:00	MSFT	Stock	30.81	30.81	30.75	30.8	1331646.0
2012-08-21 12:30:00	MSFT	Stock	30.81	30.828	30.77	30.8	811262.0
2012-08-21 13:00:00	MSFT	Stock	30.79	30.83	30.735	30.805	1219492.0
2012-08-21 13:30:00	MSFT	Stock	30.805	30.82	30.74	30.76	1895772.0
2012-08-21 14:00:00	MSFT	Stock	30.76	30.8	30.74	30.774	1658514.0
2012-08-21 14:30:00	MSFT	Stock	30.78	30.8	30.74	30.78	907794.0
2012-08-21 15:00:00	MSFT	Stock	30.771	30.775	30.68	30.711	1960721.0
2012-08-21 15:30:00	MSFT	Stock	30.715	30.81	30.71	30.81	3671139.0
2012-08-21 16:00:00	MSFT	Stock	30.8	30.84	30.63	30.7	2182804.0

> showing 50 of 74,888 rows — these rows as CSV

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