PREVIEW / stock_30min / 2011-06-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-07.parquet
  size:    1.4 MB
  rows:    74,814
  symbols: 3,543

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
2011-06-07 04:00:00	AAPL	Stock	12.1107	12.1107	12.1107	12.1107	2800.0
2011-06-07 04:30:00	AAPL	Stock	12.1425	12.1425	12.1425	12.1425	5600.0
2011-06-07 06:00:00	AAPL	Stock	12.1382	12.1425	12.1354	12.1354	16800.0
2011-06-07 07:00:00	AAPL	Stock	12.1107	12.1143	12.0893	12.1071	124348.0
2011-06-07 07:30:00	AAPL	Stock	12.1071	12.1332	12.0936	12.1161	492044.0
2011-06-07 08:00:00	AAPL	Stock	12.1175	12.1214	12.0929	12.1014	575708.0
2011-06-07 08:30:00	AAPL	Stock	12.0964	12.1204	12.0932	12.1114	974428.0
2011-06-07 09:00:00	AAPL	Stock	12.1118	12.1243	12.0725	12.0786	2158520.0
2011-06-07 09:30:00	AAPL	Stock	12.0786	12.0793	11.9046	11.9229	121887080.0
2011-06-07 10:00:00	AAPL	Stock	11.9214	11.9939	11.9075	11.9557	56008428.0
2011-06-07 10:30:00	AAPL	Stock	11.9543	11.9779	11.9361	11.94	25276804.0
2011-06-07 11:00:00	AAPL	Stock	11.9396	11.9457	11.8929	11.9054	36225224.0
2011-06-07 11:30:00	AAPL	Stock	11.9061	11.945	11.8811	11.9232	29640212.0
2011-06-07 12:00:00	AAPL	Stock	11.9229	11.9268	11.8893	11.8989	15674204.0
2011-06-07 12:30:00	AAPL	Stock	11.9	11.9179	11.8714	11.9031	24794224.0
2011-06-07 13:00:00	AAPL	Stock	11.9057	11.9579	11.9007	11.9196	27927340.0
2011-06-07 13:30:00	AAPL	Stock	11.9204	11.9368	11.9107	11.916	20662208.0
2011-06-07 14:00:00	AAPL	Stock	11.9168	12.0	11.915	11.9689	32262496.0
2011-06-07 14:30:00	AAPL	Stock	11.9675	11.9675	11.9036	11.9182	27268332.0
2011-06-07 15:00:00	AAPL	Stock	11.9161	11.9336	11.8929	11.9143	27022184.0
2011-06-07 15:30:00	AAPL	Stock	11.9136	11.9243	11.8536	11.8539	53255132.0
2011-06-07 16:00:00	AAPL	Stock	11.8539	11.9384	11.8504	11.8668	19399884.0
2011-06-07 16:30:00	AAPL	Stock	11.8664	11.9127	11.8664	11.8796	262052.0
2011-06-07 17:00:00	AAPL	Stock	11.9144	11.9144	11.8754	11.8804	122836.0
2011-06-07 17:30:00	AAPL	Stock	11.8804	11.8925	11.8786	11.8925	139580.0
2011-06-07 18:00:00	AAPL	Stock	11.8929	11.8964	11.8586	11.8946	258132.0
2011-06-07 18:30:00	AAPL	Stock	11.8929	11.8961	11.8893	11.8929	106064.0
2011-06-07 19:00:00	AAPL	Stock	11.8929	11.8946	11.8925	11.8946	14784.0
2011-06-07 19:30:00	AAPL	Stock	11.8893	11.8957	11.8886	11.8957	66668.0
2011-06-07 04:30:00	MSFT	Stock	24.2	24.2	24.2	24.2	400.0
2011-06-07 05:30:00	MSFT	Stock	24.2	24.2	24.2	24.2	200.0
2011-06-07 06:30:00	MSFT	Stock	24.19	24.19	24.19	24.19	600.0
2011-06-07 07:00:00	MSFT	Stock	24.1	24.1	24.1	24.1	700.0
2011-06-07 07:30:00	MSFT	Stock	24.1	24.1	24.08	24.08	1125.0
2011-06-07 08:00:00	MSFT	Stock	24.06	24.09	24.05	24.06	16605.0
2011-06-07 08:30:00	MSFT	Stock	24.06	24.14	24.06	24.13	47499.0
2011-06-07 09:00:00	MSFT	Stock	24.13	24.16	24.05	24.08	82391.0
2011-06-07 09:30:00	MSFT	Stock	24.09	24.17	23.98	24.02	4616616.0
2011-06-07 10:00:00	MSFT	Stock	24.03	24.04	23.94	23.985	4680312.0
2011-06-07 10:30:00	MSFT	Stock	23.985	24.14	23.985	24.097	2883086.0
2011-06-07 11:00:00	MSFT	Stock	24.09	24.1	23.95	23.96	2404544.0
2011-06-07 11:30:00	MSFT	Stock	23.96	23.985	23.9	23.978	1955245.0
2011-06-07 12:00:00	MSFT	Stock	23.98	23.98	23.93	23.96	1526590.0
2011-06-07 12:30:00	MSFT	Stock	23.96	24.01	23.93	23.995	1408268.0
2011-06-07 13:00:00	MSFT	Stock	24.0	24.08	23.99	24.04	1467294.0
2011-06-07 13:30:00	MSFT	Stock	24.035	24.07	24.02	24.049	1247255.0
2011-06-07 14:00:00	MSFT	Stock	24.045	24.1	24.04	24.071	1164087.0
2011-06-07 14:30:00	MSFT	Stock	24.08	24.08	24.02	24.04	2150738.0
2011-06-07 15:00:00	MSFT	Stock	24.04	24.06	23.99	24.04	2140910.0
2011-06-07 15:30:00	MSFT	Stock	24.05	24.06	23.93	24.05	9726538.0

> showing 50 of 74,814 rows — these rows as CSV

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