PREVIEW / stock_30min / 2012-01-30

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-30.parquet
  size:    1.4 MB
  rows:    75,531
  symbols: 3,529

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-01-30 04:00:00	AAPL	Stock	15.9218	15.925	15.9204	15.925	14000.0
2012-01-30 04:30:00	AAPL	Stock	15.9068	15.9068	15.8854	15.8854	65940.0
2012-01-30 05:00:00	AAPL	Stock	15.8964	15.9075	15.8929	15.8964	28000.0
2012-01-30 05:30:00	AAPL	Stock	15.9075	15.9075	15.9075	15.9075	8400.0
2012-01-30 06:30:00	AAPL	Stock	15.9211	15.9214	15.9086	15.9086	58800.0
2012-01-30 07:00:00	AAPL	Stock	15.9214	15.9507	15.9107	15.9196	251944.0
2012-01-30 07:30:00	AAPL	Stock	15.9214	15.9214	15.9029	15.9157	147196.0
2012-01-30 08:00:00	AAPL	Stock	15.9154	15.95	15.9104	15.9104	482132.0
2012-01-30 08:30:00	AAPL	Stock	15.9054	15.9143	15.8864	15.8929	995372.0
2012-01-30 09:00:00	AAPL	Stock	15.8932	15.9282	15.8911	15.9182	1059492.0
2012-01-30 09:30:00	AAPL	Stock	15.9179	16.0243	15.9068	15.9914	47065032.0
2012-01-30 10:00:00	AAPL	Stock	15.9896	16.0982	15.9825	16.0596	57721160.0
2012-01-30 10:30:00	AAPL	Stock	16.0596	16.1732	16.0554	16.1711	49740684.0
2012-01-30 11:00:00	AAPL	Stock	16.1711	16.1911	16.1293	16.1468	30012528.0
2012-01-30 11:30:00	AAPL	Stock	16.1496	16.1594	16.1304	16.145	15064364.0
2012-01-30 12:00:00	AAPL	Stock	16.1461	16.1964	16.1414	16.1882	20992328.0
2012-01-30 12:30:00	AAPL	Stock	16.1876	16.1907	16.1482	16.1657	17333064.0
2012-01-30 13:00:00	AAPL	Stock	16.1671	16.1946	16.1446	16.1889	14061432.0
2012-01-30 13:30:00	AAPL	Stock	16.1879	16.2107	16.1679	16.1811	19434436.0
2012-01-30 14:00:00	AAPL	Stock	16.1796	16.2007	16.17	16.182	14620088.0
2012-01-30 14:30:00	AAPL	Stock	16.1829	16.1986	16.1786	16.1904	10870440.0
2012-01-30 15:00:00	AAPL	Stock	16.1896	16.1921	16.1679	16.1911	18452784.0
2012-01-30 15:30:00	AAPL	Stock	16.1911	16.1918	16.1364	16.1789	32177432.0
2012-01-30 16:00:00	AAPL	Stock	16.1789	16.1925	16.1152	16.1821	19405316.0
2012-01-30 16:30:00	AAPL	Stock	16.1807	16.1889	16.1552	16.1829	765660.0
2012-01-30 17:00:00	AAPL	Stock	16.1793	16.1918	16.1786	16.1911	805420.0
2012-01-30 17:30:00	AAPL	Stock	16.1911	16.1954	16.19	16.1936	230496.0
2012-01-30 18:00:00	AAPL	Stock	16.1925	16.195	16.1879	16.1929	116592.0
2012-01-30 18:30:00	AAPL	Stock	16.1879	16.1936	16.1879	16.1936	30800.0
2012-01-30 19:00:00	AAPL	Stock	16.1946	16.2032	16.1929	16.2032	210840.0
2012-01-30 19:30:00	AAPL	Stock	16.2046	16.2107	16.2036	16.2089	232316.0
2012-01-30 04:00:00	MSFT	Stock	29.15	29.15	29.0	29.0	200.0
2012-01-30 07:30:00	MSFT	Stock	29.03	29.05	29.0	29.0	4758.0
2012-01-30 08:00:00	MSFT	Stock	29.04	29.18	29.0	29.03	20696.0
2012-01-30 08:30:00	MSFT	Stock	29.23	29.23	29.0	29.05	79126.0
2012-01-30 09:00:00	MSFT	Stock	29.05	29.06	28.97	28.98	32297.0
2012-01-30 09:30:00	MSFT	Stock	28.99	29.135	28.83	29.125	4716630.0
2012-01-30 10:00:00	MSFT	Stock	29.12	29.13	28.95	28.958	5565599.0
2012-01-30 10:30:00	MSFT	Stock	28.95	29.22	28.94	29.145	3660624.0
2012-01-30 11:00:00	MSFT	Stock	29.14	29.32	29.14	29.284	3535880.0
2012-01-30 11:30:00	MSFT	Stock	29.285	29.41	29.27	29.37	2287927.0
2012-01-30 12:00:00	MSFT	Stock	29.37	29.47	29.364	29.42	2202380.0
2012-01-30 12:30:00	MSFT	Stock	29.43	29.5	29.41	29.495	2698949.0
2012-01-30 13:00:00	MSFT	Stock	29.5	29.5	29.41	29.478	2001005.0
2012-01-30 13:30:00	MSFT	Stock	29.475	29.58	29.46	29.565	2354213.0
2012-01-30 14:00:00	MSFT	Stock	29.56	29.62	29.54	29.605	2397945.0
2012-01-30 14:30:00	MSFT	Stock	29.61	29.62	29.52	29.53	4334270.0
2012-01-30 15:00:00	MSFT	Stock	29.53	29.57	29.48	29.57	3087127.0
2012-01-30 15:30:00	MSFT	Stock	29.565	29.61	29.49	29.61	7238250.0
2012-01-30 16:00:00	MSFT	Stock	29.59	29.61	29.23	29.61	3784630.0

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

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