PREVIEW / stock_30min / 2011-03-22

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-22.parquet
  size:    1.4 MB
  rows:    73,498
  symbols: 3,498

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-03-22 04:00:00	AAPL	Stock	12.1429	12.1536	12.1429	12.15	22400.0
2011-03-22 04:30:00	AAPL	Stock	12.15	12.1675	12.15	12.1675	39200.0
2011-03-22 06:00:00	AAPL	Stock	12.1818	12.1818	12.1786	12.1786	16800.0
2011-03-22 06:30:00	AAPL	Stock	12.1768	12.1786	12.1607	12.1607	17220.0
2011-03-22 07:00:00	AAPL	Stock	12.1507	12.1893	12.1429	12.1714	203980.0
2011-03-22 07:30:00	AAPL	Stock	12.1696	12.2007	12.1643	12.1761	258328.0
2011-03-22 08:00:00	AAPL	Stock	12.1768	12.1782	12.1432	12.1643	879508.0
2011-03-22 08:30:00	AAPL	Stock	12.1607	12.2654	12.16	12.2357	3039484.0
2011-03-22 09:00:00	AAPL	Stock	12.2339	12.2411	12.2125	12.2361	1426880.0
2011-03-22 09:30:00	AAPL	Stock	12.2361	12.2364	12.1121	12.1786	71627500.0
2011-03-22 10:00:00	AAPL	Stock	12.1786	12.2171	12.1632	12.2119	32879392.0
2011-03-22 10:30:00	AAPL	Stock	12.2125	12.2214	12.1714	12.1746	29690248.0
2011-03-22 11:00:00	AAPL	Stock	12.1746	12.1907	12.1482	12.1864	24697820.0
2011-03-22 11:30:00	AAPL	Stock	12.1879	12.1964	12.1693	12.1886	13740020.0
2011-03-22 12:00:00	AAPL	Stock	12.1896	12.1975	12.17	12.1825	12830552.0
2011-03-22 12:30:00	AAPL	Stock	12.1829	12.1857	12.1696	12.1739	9215556.0
2011-03-22 13:00:00	AAPL	Stock	12.1729	12.1752	12.1371	12.143	19761812.0
2011-03-22 13:30:00	AAPL	Stock	12.1436	12.1782	12.1375	12.1714	18831092.0
2011-03-22 14:00:00	AAPL	Stock	12.1714	12.1726	12.1368	12.1404	15020740.0
2011-03-22 14:30:00	AAPL	Stock	12.1432	12.1704	12.1404	12.1625	13651428.0
2011-03-22 15:00:00	AAPL	Stock	12.1629	12.185	12.1475	12.1779	14058324.0
2011-03-22 15:30:00	AAPL	Stock	12.1782	12.1996	12.1625	12.1832	29138032.0
2011-03-22 16:00:00	AAPL	Stock	12.1857	12.2025	12.115	12.1929	7368564.0
2011-03-22 16:30:00	AAPL	Stock	12.1961	12.1989	12.1739	12.1929	183820.0
2011-03-22 17:00:00	AAPL	Stock	12.1929	12.1964	12.1768	12.1768	178724.0
2011-03-22 17:30:00	AAPL	Stock	12.1768	12.1925	12.1718	12.1786	59556.0
2011-03-22 18:00:00	AAPL	Stock	12.1821	12.1857	12.1821	12.1857	79492.0
2011-03-22 18:30:00	AAPL	Stock	12.1825	12.1889	12.1825	12.1886	13916.0
2011-03-22 19:00:00	AAPL	Stock	12.1893	12.1911	12.1857	12.1911	53900.0
2011-03-22 19:30:00	AAPL	Stock	12.1896	12.1911	12.1786	12.1789	170380.0
2011-03-22 06:30:00	MSFT	Stock	25.38	25.4	25.38	25.4	990.0
2011-03-22 07:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	200.0
2011-03-22 07:30:00	MSFT	Stock	25.4	25.4	25.4	25.4	310.0
2011-03-22 08:00:00	MSFT	Stock	25.35	25.37	25.33	25.37	3462.0
2011-03-22 08:30:00	MSFT	Stock	25.39	25.4	25.35	25.35	8210.0
2011-03-22 09:00:00	MSFT	Stock	25.34	25.35	25.3	25.35	15695.0
2011-03-22 09:30:00	MSFT	Stock	25.35	25.44	25.23	25.38	4365352.0
2011-03-22 10:00:00	MSFT	Stock	25.385	25.45	25.34	25.44	2970888.0
2011-03-22 10:30:00	MSFT	Stock	25.445	25.45	25.36	25.368	2226723.0
2011-03-22 11:00:00	MSFT	Stock	25.36	25.42	25.35	25.38	1792853.0
2011-03-22 11:30:00	MSFT	Stock	25.375	25.46	25.37	25.44	1822483.0
2011-03-22 12:00:00	MSFT	Stock	25.43	25.44	25.4	25.411	1324251.0
2011-03-22 12:30:00	MSFT	Stock	25.415	25.43	25.35	25.35	1222208.0
2011-03-22 13:00:00	MSFT	Stock	25.355	25.36	25.26	25.278	1289534.0
2011-03-22 13:30:00	MSFT	Stock	25.27	25.37	25.26	25.36	1377629.0
2011-03-22 14:00:00	MSFT	Stock	25.36	25.37	25.27	25.28	1243659.0
2011-03-22 14:30:00	MSFT	Stock	25.282	25.33	25.28	25.33	1023775.0
2011-03-22 15:00:00	MSFT	Stock	25.32	25.37	25.31	25.332	1386272.0
2011-03-22 15:30:00	MSFT	Stock	25.33	25.38	25.28	25.29	3924599.0
2011-03-22 16:00:00	MSFT	Stock	25.3	25.465	25.277	25.34	1680579.0

> showing 50 of 73,498 rows — these rows as CSV

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