PREVIEW / stock_30min / 2012-10-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-12.parquet
  size:    1.3 MB
  rows:    71,459
  symbols: 3,441

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-10-12 06:30:00	AAPL	Stock	22.4886	22.5107	22.4886	22.5107	25452.0
2012-10-12 07:00:00	AAPL	Stock	22.5107	22.5107	22.4668	22.5071	80220.0
2012-10-12 07:30:00	AAPL	Stock	22.4857	22.5804	22.4857	22.5786	586208.0
2012-10-12 08:00:00	AAPL	Stock	22.5821	22.5996	22.5214	22.5357	1307180.0
2012-10-12 08:30:00	AAPL	Stock	22.5393	22.5536	22.4818	22.4996	1060052.0
2012-10-12 09:00:00	AAPL	Stock	22.4936	22.51	22.4546	22.4961	1988560.0
2012-10-12 09:30:00	AAPL	Stock	22.4843	22.5657	22.3321	22.5657	87479868.0
2012-10-12 10:00:00	AAPL	Stock	22.5657	22.6904	22.5232	22.615	66870412.0
2012-10-12 10:30:00	AAPL	Stock	22.62	22.6921	22.6018	22.6436	34981464.0
2012-10-12 11:00:00	AAPL	Stock	22.6437	22.6589	22.4857	22.5396	38159744.0
2012-10-12 11:30:00	AAPL	Stock	22.5404	22.6061	22.4786	22.5829	26090372.0
2012-10-12 12:00:00	AAPL	Stock	22.5805	22.6243	22.5429	22.5564	15056440.0
2012-10-12 12:30:00	AAPL	Stock	22.554	22.6054	22.4857	22.4893	15110984.0
2012-10-12 13:00:00	AAPL	Stock	22.4929	22.4939	22.4107	22.4536	28851928.0
2012-10-12 13:30:00	AAPL	Stock	22.4554	22.5161	22.4286	22.4873	16426144.0
2012-10-12 14:00:00	AAPL	Stock	22.4914	22.57	22.4357	22.5529	17331272.0
2012-10-12 14:30:00	AAPL	Stock	22.5515	22.5696	22.51	22.5429	18676252.0
2012-10-12 15:00:00	AAPL	Stock	22.5443	22.5475	22.4771	22.4893	20076672.0
2012-10-12 15:30:00	AAPL	Stock	22.4896	22.5132	22.4529	22.4843	33950980.0
2012-10-12 16:00:00	AAPL	Stock	22.4943	22.5223	22.4107	22.4818	20841856.0
2012-10-12 16:30:00	AAPL	Stock	22.4825	22.512	22.4661	22.4768	1290408.0
2012-10-12 17:00:00	AAPL	Stock	22.4736	22.4804	22.4668	22.4804	131600.0
2012-10-12 17:30:00	AAPL	Stock	22.4775	22.4804	22.4654	22.4661	106652.0
2012-10-12 18:00:00	AAPL	Stock	22.4732	22.4786	22.4721	22.4736	71176.0
2012-10-12 18:30:00	AAPL	Stock	22.4782	22.4846	22.4779	22.4821	118356.0
2012-10-12 19:00:00	AAPL	Stock	22.4821	22.4832	22.4718	22.4771	86772.0
2012-10-12 19:30:00	AAPL	Stock	22.4707	22.4707	22.4643	22.4643	96964.0
2012-10-12 07:00:00	MSFT	Stock	29.05	29.17	29.05	29.17	1200.0
2012-10-12 07:30:00	MSFT	Stock	29.02	29.02	29.02	29.02	2000.0
2012-10-12 08:00:00	MSFT	Stock	29.03	29.04	29.01	29.02	5249.0
2012-10-12 08:30:00	MSFT	Stock	29.04	29.04	28.98	28.98	7019.0
2012-10-12 09:00:00	MSFT	Stock	28.98	29.03	28.9	28.97	68072.0
2012-10-12 09:30:00	MSFT	Stock	28.97	29.1	28.8	29.08	6705264.0
2012-10-12 10:00:00	MSFT	Stock	29.09	29.13	29.025	29.038	3124374.0
2012-10-12 10:30:00	MSFT	Stock	29.03	29.07	28.995	29.02	2733501.0
2012-10-12 11:00:00	MSFT	Stock	29.025	29.038	28.88	28.955	2889061.0
2012-10-12 11:30:00	MSFT	Stock	28.95	28.96	28.86	28.91	1984915.0
2012-10-12 12:00:00	MSFT	Stock	28.91	28.99	28.89	28.972	2171750.0
2012-10-12 12:30:00	MSFT	Stock	28.98	29.05	28.98	29.05	1367679.0
2012-10-12 13:00:00	MSFT	Stock	29.047	29.09	29.02	29.065	2205106.0
2012-10-12 13:30:00	MSFT	Stock	29.062	29.22	29.06	29.21	2968980.0
2012-10-12 14:00:00	MSFT	Stock	29.21	29.26	29.17	29.22	3066404.0
2012-10-12 14:30:00	MSFT	Stock	29.22	29.25	29.18	29.248	1466717.0
2012-10-12 15:00:00	MSFT	Stock	29.24	29.32	29.21	29.26	4589389.0
2012-10-12 15:30:00	MSFT	Stock	29.255	29.27	29.18	29.2	5796645.0
2012-10-12 16:00:00	MSFT	Stock	29.2	29.27	28.926	29.2	3185285.0
2012-10-12 16:30:00	MSFT	Stock	29.24	29.24	28.969	29.24	56933.0
2012-10-12 17:00:00	MSFT	Stock	29.24	29.24	29.24	29.24	1522.0
2012-10-12 18:00:00	MSFT	Stock	29.21	29.21	29.2	29.21	2505.0
2012-10-12 18:30:00	MSFT	Stock	29.24	29.24	29.24	29.24	1100.0

> showing 50 of 71,459 rows — these rows as CSV

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