PREVIEW / stock_30min / 2012-10-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-17.parquet
  size:    1.4 MB
  rows:    72,875
  symbols: 3,458

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
2012-10-17 04:00:00	AAPL	Stock	23.2143	23.2321	23.2143	23.2143	64260.0
2012-10-17 04:30:00	AAPL	Stock	23.2221	23.2221	23.1964	23.1964	32340.0
2012-10-17 05:00:00	AAPL	Stock	23.1964	23.2143	23.1911	23.2143	156800.0
2012-10-17 05:30:00	AAPL	Stock	23.2143	23.2446	23.2129	23.2446	72128.0
2012-10-17 06:00:00	AAPL	Stock	23.2446	23.2857	23.2446	23.2857	51800.0
2012-10-17 06:30:00	AAPL	Stock	23.2857	23.2857	23.25	23.25	65800.0
2012-10-17 07:00:00	AAPL	Stock	23.2393	23.2539	23.1571	23.1571	404292.0
2012-10-17 07:30:00	AAPL	Stock	23.1679	23.205	23.1571	23.1571	448028.0
2012-10-17 08:00:00	AAPL	Stock	23.1607	23.2004	23.1521	23.1607	585956.0
2012-10-17 08:30:00	AAPL	Stock	23.1739	23.1761	23.1143	23.1675	703668.0
2012-10-17 09:00:00	AAPL	Stock	23.16	23.1893	23.1004	23.1739	1920828.0
2012-10-17 09:30:00	AAPL	Stock	23.1739	23.3139	23.0982	23.2011	88321072.0
2012-10-17 10:00:00	AAPL	Stock	23.2011	23.2354	23.0807	23.1356	40319972.0
2012-10-17 10:30:00	AAPL	Stock	23.1396	23.1607	23.075	23.1457	25381720.0
2012-10-17 11:00:00	AAPL	Stock	23.1461	23.1493	23.0821	23.1204	14029680.0
2012-10-17 11:30:00	AAPL	Stock	23.1161	23.2321	23.1082	23.182	21973196.0
2012-10-17 12:00:00	AAPL	Stock	23.1784	23.2104	23.1189	23.1357	13166104.0
2012-10-17 12:30:00	AAPL	Stock	23.1354	23.175	23.1231	23.1591	10106376.0
2012-10-17 13:00:00	AAPL	Stock	23.1554	23.16	23.0871	23.0871	12337948.0
2012-10-17 13:30:00	AAPL	Stock	23.0864	23.0954	23.0	23.0536	26276880.0
2012-10-17 14:00:00	AAPL	Stock	23.0535	23.1111	23.0447	23.0864	12392772.0
2012-10-17 14:30:00	AAPL	Stock	23.0866	23.0971	23.0143	23.0479	16044476.0
2012-10-17 15:00:00	AAPL	Stock	23.0504	23.205	23.0504	23.1229	38401636.0
2012-10-17 15:30:00	AAPL	Stock	23.125	23.1318	23.0129	23.0189	37704660.0
2012-10-17 16:00:00	AAPL	Stock	23.0193	23.1401	23.0186	23.0243	14539840.0
2012-10-17 16:30:00	AAPL	Stock	23.0357	23.0496	23.0218	23.0411	304080.0
2012-10-17 17:00:00	AAPL	Stock	23.0411	23.0429	23.0357	23.0357	80584.0
2012-10-17 17:30:00	AAPL	Stock	23.0325	23.0514	23.0325	23.0507	182112.0
2012-10-17 18:00:00	AAPL	Stock	23.0511	23.0518	23.0446	23.05	46788.0
2012-10-17 18:30:00	AAPL	Stock	23.0504	23.0504	23.0357	23.0429	58184.0
2012-10-17 19:00:00	AAPL	Stock	23.0368	23.0425	23.0346	23.0346	42980.0
2012-10-17 19:30:00	AAPL	Stock	23.0357	23.0621	23.0357	23.0621	200312.0
2012-10-17 06:30:00	MSFT	Stock	29.58	29.58	29.51	29.51	300.0
2012-10-17 07:00:00	MSFT	Stock	29.4	29.4	29.4	29.4	1000.0
2012-10-17 07:30:00	MSFT	Stock	29.41	29.41	29.4	29.4	3100.0
2012-10-17 08:00:00	MSFT	Stock	29.39	29.4	29.3	29.3	21300.0
2012-10-17 08:30:00	MSFT	Stock	29.39	29.39	29.33	29.33	27177.0
2012-10-17 09:00:00	MSFT	Stock	29.33	29.42	29.24	29.25	103808.0
2012-10-17 09:30:00	MSFT	Stock	29.26	29.49	29.09	29.47	6941267.0
2012-10-17 10:00:00	MSFT	Stock	29.46	29.51	29.42	29.48	3821790.0
2012-10-17 10:30:00	MSFT	Stock	29.485	29.5	29.37	29.42	2584421.0
2012-10-17 11:00:00	MSFT	Stock	29.42	29.47	29.37	29.45	2279693.0
2012-10-17 11:30:00	MSFT	Stock	29.45	29.64	29.45	29.55	3485288.0
2012-10-17 12:00:00	MSFT	Stock	29.55	29.595	29.52	29.575	1927929.0
2012-10-17 12:30:00	MSFT	Stock	29.57	29.6	29.56	29.575	1866000.0
2012-10-17 13:00:00	MSFT	Stock	29.57	29.61	29.56	29.58	2225809.0
2012-10-17 13:30:00	MSFT	Stock	29.585	29.61	29.53	29.54	2134657.0
2012-10-17 14:00:00	MSFT	Stock	29.54	29.55	29.51	29.54	1434985.0
2012-10-17 14:30:00	MSFT	Stock	29.543	29.57	29.53	29.555	1868133.0
2012-10-17 15:00:00	MSFT	Stock	29.555	29.62	29.55	29.615	2425852.0

> showing 50 of 72,875 rows — these rows as CSV

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