PREVIEW / stock_30min / 2014-12-02

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-02.parquet
  size:    1.6 MB
  rows:    85,268
  symbols: 3,558

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-12-02 04:00:00	AAPL	Stock	28.775	28.95	28.775	28.95	34716.0
2014-12-02 04:30:00	AAPL	Stock	28.95	28.995	28.9325	28.98	52304.0
2014-12-02 05:00:00	AAPL	Stock	28.94	28.9675	28.925	28.9625	50872.0
2014-12-02 05:30:00	AAPL	Stock	28.9375	28.9375	28.875	28.875	53612.0
2014-12-02 06:00:00	AAPL	Stock	28.865	28.9	28.815	28.8325	171128.0
2014-12-02 06:30:00	AAPL	Stock	28.83	28.9025	28.815	28.9025	35900.0
2014-12-02 07:00:00	AAPL	Stock	28.885	28.9475	28.8625	28.9	203360.0
2014-12-02 07:30:00	AAPL	Stock	28.9125	28.9125	28.555	28.635	437004.0
2014-12-02 08:00:00	AAPL	Stock	28.645	28.9375	28.505	28.5625	2202628.0
2014-12-02 08:30:00	AAPL	Stock	28.565	28.7675	28.475	28.5	2201344.0
2014-12-02 09:00:00	AAPL	Stock	28.4875	28.535	28.355	28.375	2640300.0
2014-12-02 09:30:00	AAPL	Stock	28.375	28.61	28.1875	28.4838	56785680.0
2014-12-02 10:00:00	AAPL	Stock	28.48	28.7625	28.465	28.7378	25293188.0
2014-12-02 10:30:00	AAPL	Stock	28.7378	28.87	28.645	28.7612	20018344.0
2014-12-02 11:00:00	AAPL	Stock	28.76	28.7975	28.64	28.755	11457704.0
2014-12-02 11:30:00	AAPL	Stock	28.7562	28.9175	28.735	28.9	10317796.0
2014-12-02 12:00:00	AAPL	Stock	28.8975	28.9375	28.805	28.8675	10109012.0
2014-12-02 12:30:00	AAPL	Stock	28.8675	28.8748	28.6725	28.8325	9184728.0
2014-12-02 13:00:00	AAPL	Stock	28.83	28.845	28.7625	28.8038	5873980.0
2014-12-02 13:30:00	AAPL	Stock	28.8025	28.835	28.7412	28.765	5705800.0
2014-12-02 14:00:00	AAPL	Stock	28.765	28.7775	28.6875	28.7225	5923856.0
2014-12-02 14:30:00	AAPL	Stock	28.7238	28.8	28.7115	28.78	5907624.0
2014-12-02 15:00:00	AAPL	Stock	28.7812	28.81	28.6425	28.6625	9125004.0
2014-12-02 15:30:00	AAPL	Stock	28.6625	28.7175	28.5875	28.655	17293404.0
2014-12-02 16:00:00	AAPL	Stock	28.6575	28.8205	28.5975	28.65	7986508.0
2014-12-02 16:30:00	AAPL	Stock	28.6475	28.795	28.6475	28.72	162736.0
2014-12-02 17:00:00	AAPL	Stock	28.6575	28.6925	28.6575	28.6625	217680.0
2014-12-02 17:30:00	AAPL	Stock	28.6575	28.675	28.6325	28.6325	241464.0
2014-12-02 18:00:00	AAPL	Stock	28.6375	28.6375	28.5925	28.6	104620.0
2014-12-02 18:30:00	AAPL	Stock	28.6575	28.6575	28.58	28.5975	69564.0
2014-12-02 19:00:00	AAPL	Stock	28.5975	28.6125	28.5875	28.595	66952.0
2014-12-02 19:30:00	AAPL	Stock	28.595	28.625	28.5925	28.625	51492.0
2014-12-02 05:30:00	MSFT	Stock	48.79	48.84	48.76	48.76	2800.0
2014-12-02 06:00:00	MSFT	Stock	48.78	48.8	48.78	48.8	1300.0
2014-12-02 06:30:00	MSFT	Stock	48.79	48.79	48.78	48.78	300.0
2014-12-02 07:00:00	MSFT	Stock	48.78	48.83	48.76	48.83	2692.0
2014-12-02 07:30:00	MSFT	Stock	48.81	48.89	48.81	48.88	5800.0
2014-12-02 08:00:00	MSFT	Stock	48.9	49.02	48.76	48.94	10038.0
2014-12-02 08:30:00	MSFT	Stock	48.91	48.91	48.62	48.9	10921.0
2014-12-02 09:00:00	MSFT	Stock	48.88	48.9	48.8	48.9	6090.0
2014-12-02 09:30:00	MSFT	Stock	48.9	49.05	48.6	48.67	3756602.0
2014-12-02 10:00:00	MSFT	Stock	48.67	48.83	48.63	48.67	2021384.0
2014-12-02 10:30:00	MSFT	Stock	48.67	48.68	48.38	48.41	1917969.0
2014-12-02 11:00:00	MSFT	Stock	48.41	48.455	48.345	48.43	1440389.0
2014-12-02 11:30:00	MSFT	Stock	48.43	48.51	48.38	48.46	1174262.0
2014-12-02 12:00:00	MSFT	Stock	48.46	48.5	48.37	48.39	868364.0
2014-12-02 12:30:00	MSFT	Stock	48.38	48.42	48.3	48.32	858653.0
2014-12-02 13:00:00	MSFT	Stock	48.32	48.39	48.2	48.39	3589728.0
2014-12-02 13:30:00	MSFT	Stock	48.39	48.41	48.34	48.405	997782.0
2014-12-02 14:00:00	MSFT	Stock	48.41	48.42	48.34	48.415	736969.0

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

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