PREVIEW / stock_30min / 2014-06-20

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-20.parquet
  size:    1.7 MB
  rows:    85,462
  symbols: 3,584

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
2014-06-20 04:00:00	AAPL	Stock	22.925	22.93	22.925	22.93	3920.0
2014-06-20 04:30:00	AAPL	Stock	22.945	22.945	22.945	22.945	400.0
2014-06-20 05:00:00	AAPL	Stock	22.935	22.945	22.935	22.945	5600.0
2014-06-20 05:30:00	AAPL	Stock	22.945	22.9475	22.94	22.9475	10752.0
2014-06-20 06:30:00	AAPL	Stock	22.9575	22.9575	22.94	22.94	4300.0
2014-06-20 07:00:00	AAPL	Stock	22.95	22.965	22.94	22.95	28868.0
2014-06-20 07:30:00	AAPL	Stock	22.95	22.99	22.9425	22.97	79764.0
2014-06-20 08:00:00	AAPL	Stock	22.9625	22.985	22.9325	22.9325	98564.0
2014-06-20 08:30:00	AAPL	Stock	22.9375	22.9625	22.9325	22.955	165584.0
2014-06-20 09:00:00	AAPL	Stock	22.9625	23.0	22.9025	22.9775	2785736.0
2014-06-20 09:30:00	AAPL	Stock	22.9625	23.1375	22.87	23.1	73681092.0
2014-06-20 10:00:00	AAPL	Stock	23.1	23.1325	23.0325	23.0472	19641260.0
2014-06-20 10:30:00	AAPL	Stock	23.045	23.0625	22.975	23.0025	12023016.0
2014-06-20 11:00:00	AAPL	Stock	23.0025	23.0625	23.0	23.005	7853308.0
2014-06-20 11:30:00	AAPL	Stock	23.0025	23.025	22.9525	22.975	8777432.0
2014-06-20 12:00:00	AAPL	Stock	22.975	22.975	22.9075	22.9275	7623940.0
2014-06-20 12:30:00	AAPL	Stock	22.9275	22.995	22.9175	22.9775	6989496.0
2014-06-20 13:00:00	AAPL	Stock	22.9775	23.0	22.95	22.9562	5613392.0
2014-06-20 13:30:00	AAPL	Stock	22.9562	22.96	22.93	22.9498	4799904.0
2014-06-20 14:00:00	AAPL	Stock	22.9475	22.9725	22.9425	22.965	5387236.0
2014-06-20 14:30:00	AAPL	Stock	22.965	22.9675	22.925	22.9262	6210876.0
2014-06-20 15:00:00	AAPL	Stock	22.925	22.9275	22.9	22.903	10303392.0
2014-06-20 15:30:00	AAPL	Stock	22.905	22.945	22.725	22.725	55840100.0
2014-06-20 16:00:00	AAPL	Stock	22.7325	22.954	22.705	22.8575	123490308.0
2014-06-20 16:30:00	AAPL	Stock	22.8525	23.0258	22.7252	22.855	35905308.0
2014-06-20 17:00:00	AAPL	Stock	22.8525	22.8625	22.7275	22.8175	1650528.0
2014-06-20 17:30:00	AAPL	Stock	22.8125	22.8125	22.7248	22.795	940044.0
2014-06-20 18:00:00	AAPL	Stock	22.795	22.81	22.7275	22.8075	195520.0
2014-06-20 18:30:00	AAPL	Stock	22.805	22.8175	22.8025	22.815	45260.0
2014-06-20 19:00:00	AAPL	Stock	22.815	22.845	22.81	22.8375	107296.0
2014-06-20 19:30:00	AAPL	Stock	22.835	22.865	22.835	22.855	116412.0
2014-06-20 06:30:00	MSFT	Stock	41.53	41.53	41.53	41.53	300.0
2014-06-20 07:30:00	MSFT	Stock	41.48	41.48	41.48	41.48	200.0
2014-06-20 08:00:00	MSFT	Stock	41.5	41.5	41.49	41.49	900.0
2014-06-20 08:30:00	MSFT	Stock	41.5	41.51	41.49	41.49	3658.0
2014-06-20 09:00:00	MSFT	Stock	41.48	41.5	41.38	41.47	450704.0
2014-06-20 09:30:00	MSFT	Stock	41.47	41.83	41.38	41.76	19647379.0
2014-06-20 10:00:00	MSFT	Stock	41.76	41.79	41.7	41.709	2208972.0
2014-06-20 10:30:00	MSFT	Stock	41.7	41.795	41.63	41.76	1618204.0
2014-06-20 11:00:00	MSFT	Stock	41.77	41.82	41.73	41.786	1144938.0
2014-06-20 11:30:00	MSFT	Stock	41.79	41.8	41.73	41.73	1501032.0
2014-06-20 12:00:00	MSFT	Stock	41.73	41.736	41.59	41.665	1115024.0
2014-06-20 12:30:00	MSFT	Stock	41.67	41.73	41.64	41.72	754514.0
2014-06-20 13:00:00	MSFT	Stock	41.73	41.78	41.71	41.73	1061130.0
2014-06-20 13:30:00	MSFT	Stock	41.725	41.725	41.67	41.67	553807.0
2014-06-20 14:00:00	MSFT	Stock	41.675	41.75	41.67	41.75	741986.0
2014-06-20 14:30:00	MSFT	Stock	41.745	41.75	41.71	41.725	601105.0
2014-06-20 15:00:00	MSFT	Stock	41.725	41.78	41.7	41.778	1322912.0
2014-06-20 15:30:00	MSFT	Stock	41.77	41.83	41.66	41.67	6958626.0
2014-06-20 16:00:00	MSFT	Stock	41.67	41.78	41.63	41.63	6427163.0

> showing 50 of 85,462 rows — these rows as CSV

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