PREVIEW / stock_30min / 2014-01-24

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-24.parquet
  size:    1.7 MB
  rows:    84,280
  symbols: 3,540

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-01-24 04:00:00	AAPL	Stock	19.8632	19.8632	19.7514	19.7607	22400.0
2014-01-24 04:30:00	AAPL	Stock	19.7718	19.85	19.7718	19.8368	75600.0
2014-01-24 05:00:00	AAPL	Stock	19.8025	19.8036	19.7143	19.7289	89600.0
2014-01-24 05:30:00	AAPL	Stock	19.7146	19.7289	19.7146	19.7271	40068.0
2014-01-24 06:00:00	AAPL	Stock	19.7143	19.7321	19.6964	19.6964	71120.0
2014-01-24 06:30:00	AAPL	Stock	19.6968	19.7211	19.6968	19.7054	19600.0
2014-01-24 07:00:00	AAPL	Stock	19.7307	19.7618	19.7143	19.7289	259532.0
2014-01-24 07:30:00	AAPL	Stock	19.7254	19.775	19.725	19.75	380492.0
2014-01-24 08:00:00	AAPL	Stock	19.7582	19.7943	19.7143	19.7943	810264.0
2014-01-24 08:30:00	AAPL	Stock	19.7818	19.7954	19.75	19.7696	897764.0
2014-01-24 09:00:00	AAPL	Stock	19.7629	19.8086	19.7571	19.7661	1246672.0
2014-01-24 09:30:00	AAPL	Stock	19.7857	19.8436	19.6643	19.6643	52041360.0
2014-01-24 10:00:00	AAPL	Stock	19.6718	19.7818	19.6629	19.7543	31669372.0
2014-01-24 10:30:00	AAPL	Stock	19.76	19.7625	19.6632	19.7095	23113216.0
2014-01-24 11:00:00	AAPL	Stock	19.7071	19.7136	19.5871	19.6143	27740832.0
2014-01-24 11:30:00	AAPL	Stock	19.6143	19.7014	19.5917	19.6964	25408404.0
2014-01-24 12:00:00	AAPL	Stock	19.6964	19.7436	19.6914	19.7057	28769720.0
2014-01-24 12:30:00	AAPL	Stock	19.7054	19.7143	19.6614	19.6829	16490740.0
2014-01-24 13:00:00	AAPL	Stock	19.6815	19.6964	19.6429	19.6504	12389748.0
2014-01-24 13:30:00	AAPL	Stock	19.65	19.6704	19.6071	19.6211	12462016.0
2014-01-24 14:00:00	AAPL	Stock	19.6175	19.6307	19.5686	19.6014	20623484.0
2014-01-24 14:30:00	AAPL	Stock	19.5993	19.6225	19.5475	19.5527	16895284.0
2014-01-24 15:00:00	AAPL	Stock	19.55	19.5564	19.4839	19.5025	27792828.0
2014-01-24 15:30:00	AAPL	Stock	19.5018	19.575	19.4554	19.5071	53535552.0
2014-01-24 16:00:00	AAPL	Stock	19.5068	19.6398	19.4893	19.5	15316700.0
2014-01-24 16:30:00	AAPL	Stock	19.6802	19.6802	19.4918	19.4918	1048292.0
2014-01-24 17:00:00	AAPL	Stock	19.4875	19.5071	19.4729	19.5043	586012.0
2014-01-24 17:30:00	AAPL	Stock	19.5	19.5475	19.5	19.5475	255640.0
2014-01-24 18:00:00	AAPL	Stock	19.5464	19.5464	19.5025	19.5182	300580.0
2014-01-24 18:30:00	AAPL	Stock	19.5179	19.5336	19.5179	19.5179	129332.0
2014-01-24 19:00:00	AAPL	Stock	19.5179	19.5357	19.5179	19.5268	182532.0
2014-01-24 19:30:00	AAPL	Stock	19.5321	19.5443	19.5286	19.5439	328972.0
2014-01-24 04:00:00	MSFT	Stock	37.3	37.35	37.3	37.35	900.0
2014-01-24 04:30:00	MSFT	Stock	37.31	37.31	37.29	37.31	346.0
2014-01-24 05:00:00	MSFT	Stock	37.26	37.26	37.26	37.26	200.0
2014-01-24 05:30:00	MSFT	Stock	37.17	37.28	37.17	37.2	5278.0
2014-01-24 06:00:00	MSFT	Stock	37.17	37.19	37.08	37.08	7943.0
2014-01-24 06:30:00	MSFT	Stock	37.09	37.1	36.8	36.91	57955.0
2014-01-24 07:00:00	MSFT	Stock	36.99	37.09	36.98	37.08	71286.0
2014-01-24 07:30:00	MSFT	Stock	37.08	37.29	37.08	37.1	180809.0
2014-01-24 08:00:00	MSFT	Stock	37.15	37.31	36.85	37.3	536207.0
2014-01-24 08:30:00	MSFT	Stock	37.3	37.38	37.2	37.35	236571.0
2014-01-24 09:00:00	MSFT	Stock	37.36	37.55	37.25	37.46	588294.0
2014-01-24 09:30:00	MSFT	Stock	37.45	37.55	37.0	37.12	13757043.0
2014-01-24 10:00:00	MSFT	Stock	37.12	37.29	36.75	36.84	7729445.0
2014-01-24 10:30:00	MSFT	Stock	36.85	36.9	36.65	36.77	4420973.0
2014-01-24 11:00:00	MSFT	Stock	36.76	36.82	36.53	36.6	4490636.0
2014-01-24 11:30:00	MSFT	Stock	36.6	36.82	36.55	36.76	4462532.0
2014-01-24 12:00:00	MSFT	Stock	36.76	37.11	36.71	37.06	4855445.0
2014-01-24 12:30:00	MSFT	Stock	37.07	37.17	37.01	37.099	3703791.0

> showing 50 of 84,280 rows — these rows as CSV

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