PREVIEW / stock_30min / 2013-02-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-22.parquet
  size:    1.4 MB
  rows:    75,579
  symbols: 3,467

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
2013-02-22 04:00:00	AAPL	Stock	15.9946	16.035	15.9946	16.0171	11200.0
2013-02-22 04:30:00	AAPL	Stock	15.9875	15.9875	15.9875	15.9875	8036.0
2013-02-22 05:00:00	AAPL	Stock	16.0214	16.0214	16.0214	16.0214	2800.0
2013-02-22 06:00:00	AAPL	Stock	15.9789	15.9789	15.9732	15.9732	19656.0
2013-02-22 06:30:00	AAPL	Stock	16.0	16.0357	16.0	16.0357	68600.0
2013-02-22 07:00:00	AAPL	Stock	16.0357	16.0714	16.0179	16.0714	346304.0
2013-02-22 07:30:00	AAPL	Stock	16.0679	16.0889	16.0321	16.0675	684068.0
2013-02-22 08:00:00	AAPL	Stock	16.0582	16.0857	15.9286	16.0571	1641332.0
2013-02-22 08:30:00	AAPL	Stock	16.0521	16.0775	16.0214	16.0357	1380428.0
2013-02-22 09:00:00	AAPL	Stock	16.0357	16.0557	16.0182	16.0446	1197644.0
2013-02-22 09:30:00	AAPL	Stock	16.0418	16.1286	15.9661	15.9807	61214636.0
2013-02-22 10:00:00	AAPL	Stock	15.9879	16.0143	15.95	15.9671	31103044.0
2013-02-22 10:30:00	AAPL	Stock	15.9625	16.0393	15.9554	16.0114	28130032.0
2013-02-22 11:00:00	AAPL	Stock	16.0114	16.0289	15.9775	16.0057	17785600.0
2013-02-22 11:30:00	AAPL	Stock	16.0064	16.0421	15.9986	16.0061	15579452.0
2013-02-22 12:00:00	AAPL	Stock	16.0079	16.0232	15.99	15.9918	12538512.0
2013-02-22 12:30:00	AAPL	Stock	15.9939	16.0496	15.9918	16.0432	12219704.0
2013-02-22 13:00:00	AAPL	Stock	16.0459	16.0696	16.0357	16.0546	16144128.0
2013-02-22 13:30:00	AAPL	Stock	16.0514	16.0814	16.025	16.0745	15883924.0
2013-02-22 14:00:00	AAPL	Stock	16.075	16.0768	16.0371	16.0557	10711428.0
2013-02-22 14:30:00	AAPL	Stock	16.0568	16.0661	16.0446	16.0586	11005512.0
2013-02-22 15:00:00	AAPL	Stock	16.0593	16.0804	16.04	16.0789	18687452.0
2013-02-22 15:30:00	AAPL	Stock	16.0804	16.1071	16.0593	16.0939	43013292.0
2013-02-22 16:00:00	AAPL	Stock	16.0964	16.1025	16.0355	16.0807	12159308.0
2013-02-22 16:30:00	AAPL	Stock	16.0821	16.1004	15.9996	16.0857	789544.0
2013-02-22 17:00:00	AAPL	Stock	16.0875	16.1004	16.0868	16.0954	275296.0
2013-02-22 17:30:00	AAPL	Stock	16.0982	16.0982	16.0918	16.0954	78064.0
2013-02-22 18:00:00	AAPL	Stock	16.0982	16.1	16.0982	16.0989	29400.0
2013-02-22 18:30:00	AAPL	Stock	16.0982	16.0986	16.0982	16.0982	18200.0
2013-02-22 19:00:00	AAPL	Stock	16.0982	16.1	16.0957	16.1	59640.0
2013-02-22 19:30:00	AAPL	Stock	16.1011	16.1018	16.1	16.1018	212044.0
2013-02-22 07:00:00	MSFT	Stock	27.62	27.65	27.62	27.65	1100.0
2013-02-22 07:30:00	MSFT	Stock	27.66	27.66	27.63	27.63	3300.0
2013-02-22 08:00:00	MSFT	Stock	27.62	27.67	27.45	27.64	14850.0
2013-02-22 08:30:00	MSFT	Stock	27.64	27.69	27.49	27.66	104000.0
2013-02-22 09:00:00	MSFT	Stock	27.65	27.71	27.64	27.65	22498.0
2013-02-22 09:30:00	MSFT	Stock	27.68	27.69	27.48	27.52	4415760.0
2013-02-22 10:00:00	MSFT	Stock	27.53	27.65	27.5	27.55	2878631.0
2013-02-22 10:30:00	MSFT	Stock	27.55	27.635	27.53	27.57	2079681.0
2013-02-22 11:00:00	MSFT	Stock	27.56	27.63	27.53	27.605	1820804.0
2013-02-22 11:30:00	MSFT	Stock	27.605	27.62	27.55	27.575	1531249.0
2013-02-22 12:00:00	MSFT	Stock	27.58	27.63	27.57	27.593	1181630.0
2013-02-22 12:30:00	MSFT	Stock	27.59	27.685	27.58	27.666	1101565.0
2013-02-22 13:00:00	MSFT	Stock	27.664	27.67	27.61	27.622	1055633.0
2013-02-22 13:30:00	MSFT	Stock	27.62	27.69	27.61	27.669	1440414.0
2013-02-22 14:00:00	MSFT	Stock	27.665	27.67	27.59	27.65	1894623.0
2013-02-22 14:30:00	MSFT	Stock	27.65	27.66	27.63	27.645	1081635.0
2013-02-22 15:00:00	MSFT	Stock	27.64	27.69	27.63	27.66	1945966.0
2013-02-22 15:30:00	MSFT	Stock	27.668	27.76	27.66	27.75	4903257.0
2013-02-22 16:00:00	MSFT	Stock	27.76	27.76	27.528	27.76	3474929.0

> showing 50 of 75,579 rows — these rows as CSV

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