PREVIEW / stock_30min / 2014-02-19

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-19.parquet
  size:    1.6 MB
  rows:    82,748
  symbols: 3,542

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-02-19 04:00:00	AAPL	Stock	19.5	19.5089	19.5	19.5089	16520.0
2014-02-19 05:30:00	AAPL	Stock	19.4925	19.4925	19.4911	19.4911	8400.0
2014-02-19 06:00:00	AAPL	Stock	19.4521	19.4521	19.4243	19.4243	5600.0
2014-02-19 06:30:00	AAPL	Stock	19.4207	19.4286	19.4136	19.4171	14532.0
2014-02-19 07:00:00	AAPL	Stock	19.4196	19.4464	19.4196	19.4464	98840.0
2014-02-19 07:30:00	AAPL	Stock	19.4375	19.4625	19.4375	19.4589	98644.0
2014-02-19 08:00:00	AAPL	Stock	19.4643	19.4821	19.4286	19.4779	259588.0
2014-02-19 08:30:00	AAPL	Stock	19.4604	19.4796	19.4486	19.4796	220360.0
2014-02-19 09:00:00	AAPL	Stock	19.4682	19.4871	19.4293	19.4464	527128.0
2014-02-19 09:30:00	AAPL	Stock	19.4554	19.5318	19.3579	19.4475	37193352.0
2014-02-19 10:00:00	AAPL	Stock	19.4493	19.4564	19.3607	19.4139	25575004.0
2014-02-19 10:30:00	AAPL	Stock	19.4139	19.4196	19.3411	19.3607	14334852.0
2014-02-19 11:00:00	AAPL	Stock	19.3589	19.365	19.2657	19.2868	22059968.0
2014-02-19 11:30:00	AAPL	Stock	19.2839	19.3263	19.2339	19.2339	16733752.0
2014-02-19 12:00:00	AAPL	Stock	19.2339	19.2411	19.0839	19.125	30686628.0
2014-02-19 12:30:00	AAPL	Stock	19.1246	19.2271	19.1221	19.1964	18326728.0
2014-02-19 13:00:00	AAPL	Stock	19.1982	19.2657	19.1557	19.2596	13164480.0
2014-02-19 13:30:00	AAPL	Stock	19.2614	19.2639	19.1936	19.1943	10289776.0
2014-02-19 14:00:00	AAPL	Stock	19.197	19.265	19.1786	19.2221	11142404.0
2014-02-19 14:30:00	AAPL	Stock	19.2225	19.2289	19.1486	19.1668	11909128.0
2014-02-19 15:00:00	AAPL	Stock	19.1714	19.2004	19.1357	19.1607	14615020.0
2014-02-19 15:30:00	AAPL	Stock	19.1618	19.1936	19.1429	19.1925	22455748.0
2014-02-19 16:00:00	AAPL	Stock	19.1918	19.2724	19.1677	19.1918	11579680.0
2014-02-19 16:30:00	AAPL	Stock	19.2232	19.3493	19.2011	19.2321	146300.0
2014-02-19 17:00:00	AAPL	Stock	19.2321	19.2368	19.1918	19.2339	1777440.0
2014-02-19 17:30:00	AAPL	Stock	19.225	19.2257	19.2071	19.2071	73528.0
2014-02-19 18:00:00	AAPL	Stock	19.2168	19.2193	19.1918	19.1918	265552.0
2014-02-19 18:30:00	AAPL	Stock	19.2154	19.2232	19.2079	19.2079	28504.0
2014-02-19 19:00:00	AAPL	Stock	19.2143	19.2204	19.2071	19.2204	28280.0
2014-02-19 19:30:00	AAPL	Stock	19.2196	19.2196	19.2075	19.2168	49000.0
2014-02-19 07:00:00	MSFT	Stock	37.28	37.28	37.28	37.28	200.0
2014-02-19 08:00:00	MSFT	Stock	37.3	37.3	37.2	37.23	4300.0
2014-02-19 08:30:00	MSFT	Stock	37.22	37.3	37.22	37.3	4215.0
2014-02-19 09:00:00	MSFT	Stock	37.32	37.35	37.15	37.21	30414.0
2014-02-19 09:30:00	MSFT	Stock	37.21	37.49	37.21	37.37	3694569.0
2014-02-19 10:00:00	MSFT	Stock	37.37	37.57	37.22	37.56	2879248.0
2014-02-19 10:30:00	MSFT	Stock	37.55	37.68	37.54	37.61	2270329.0
2014-02-19 11:00:00	MSFT	Stock	37.615	37.72	37.61	37.685	1681453.0
2014-02-19 11:30:00	MSFT	Stock	37.69	37.75	37.64	37.64	1581102.0
2014-02-19 12:00:00	MSFT	Stock	37.64	37.645	37.42	37.424	2609086.0
2014-02-19 12:30:00	MSFT	Stock	37.42	37.53	37.42	37.48	1222097.0
2014-02-19 13:00:00	MSFT	Stock	37.48	37.65	37.48	37.641	1504787.0
2014-02-19 13:30:00	MSFT	Stock	37.643	37.69	37.59	37.59	1154520.0
2014-02-19 14:00:00	MSFT	Stock	37.593	37.72	37.56	37.62	1487611.0
2014-02-19 14:30:00	MSFT	Stock	37.62	37.63	37.49	37.525	1436630.0
2014-02-19 15:00:00	MSFT	Stock	37.525	37.56	37.45	37.48	1878584.0
2014-02-19 15:30:00	MSFT	Stock	37.485	37.52	37.412	37.51	3732762.0
2014-02-19 16:00:00	MSFT	Stock	37.51	37.785	37.45	37.51	1440421.0
2014-02-19 16:30:00	MSFT	Stock	37.51	37.541	37.49	37.51	829.0
2014-02-19 17:00:00	MSFT	Stock	37.51	37.55	37.49	37.55	4550.0

> showing 50 of 82,748 rows — these rows as CSV

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