PREVIEW / stock_1min / 2007-12-28

all stock 1-min files

  file:    by_date/stock_1min/2007/2007-12-28.parquet
  size:    12.0 MB
  rows:    984,476
  symbols: 2,666

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
2007-12-28 05:07:00	AAPL	Stock	7.14	7.14	7.14	7.14	2800.0
2007-12-28 07:10:00	AAPL	Stock	7.1607	7.1607	7.1607	7.1607	2800.0
2007-12-28 07:12:00	AAPL	Stock	7.1625	7.1625	7.1625	7.1625	2800.0
2007-12-28 07:13:00	AAPL	Stock	7.1661	7.1661	7.1661	7.1661	11200.0
2007-12-28 07:14:00	AAPL	Stock	7.1675	7.1718	7.1675	7.1679	89600.0
2007-12-28 07:15:00	AAPL	Stock	7.1714	7.1714	7.1714	7.1714	11200.0
2007-12-28 07:16:00	AAPL	Stock	7.1714	7.1714	7.1679	7.1679	64120.0
2007-12-28 07:17:00	AAPL	Stock	7.1679	7.1679	7.1679	7.1679	12880.0
2007-12-28 07:18:00	AAPL	Stock	7.1714	7.1714	7.1714	7.1714	24052.0
2007-12-28 07:19:00	AAPL	Stock	7.1775	7.1779	7.1775	7.1779	35560.0
2007-12-28 07:20:00	AAPL	Stock	7.1775	7.1775	7.1714	7.1714	75600.0
2007-12-28 07:21:00	AAPL	Stock	7.1607	7.1607	7.1607	7.1607	14000.0
2007-12-28 07:22:00	AAPL	Stock	7.1764	7.1768	7.1764	7.1768	56000.0
2007-12-28 07:23:00	AAPL	Stock	7.1768	7.1771	7.1768	7.1771	39200.0
2007-12-28 07:31:00	AAPL	Stock	7.1625	7.1636	7.15	7.15	39508.0
2007-12-28 07:32:00	AAPL	Stock	7.1679	7.1679	7.1446	7.15	61600.0
2007-12-28 07:33:00	AAPL	Stock	7.1482	7.1482	7.1482	7.1482	5600.0
2007-12-28 07:34:00	AAPL	Stock	7.1464	7.1607	7.1464	7.1607	44996.0
2007-12-28 07:35:00	AAPL	Stock	7.1604	7.1604	7.1604	7.1604	8400.0
2007-12-28 07:36:00	AAPL	Stock	7.1604	7.1604	7.1589	7.1604	195608.0
2007-12-28 07:42:00	AAPL	Stock	7.1589	7.1589	7.1589	7.1589	2800.0
2007-12-28 07:44:00	AAPL	Stock	7.1507	7.1589	7.1507	7.1589	19796.0
2007-12-28 07:46:00	AAPL	Stock	7.1696	7.1714	7.1696	7.1714	25200.0
2007-12-28 07:48:00	AAPL	Stock	7.1696	7.1696	7.1696	7.1696	11200.0
2007-12-28 07:49:00	AAPL	Stock	7.1679	7.1736	7.1679	7.1696	148400.0
2007-12-28 07:50:00	AAPL	Stock	7.1714	7.1714	7.1714	7.1714	11200.0
2007-12-28 07:53:00	AAPL	Stock	7.1696	7.1696	7.1696	7.1696	2800.0
2007-12-28 07:54:00	AAPL	Stock	7.1696	7.1696	7.1696	7.1696	28000.0
2007-12-28 07:55:00	AAPL	Stock	7.1714	7.1732	7.1696	7.1732	11200.0
2007-12-28 07:57:00	AAPL	Stock	7.175	7.175	7.175	7.175	4200.0
2007-12-28 07:59:00	AAPL	Stock	7.1696	7.1707	7.1679	7.1707	14000.0
2007-12-28 08:00:00	AAPL	Stock	7.1679	7.1746	7.1536	7.1671	639044.0
2007-12-28 08:01:00	AAPL	Stock	7.1643	7.1671	7.1607	7.1607	163800.0
2007-12-28 08:02:00	AAPL	Stock	7.1632	7.1661	7.1579	7.1643	85680.0
2007-12-28 08:03:00	AAPL	Stock	7.1643	7.1729	7.1643	7.1696	311668.0
2007-12-28 08:04:00	AAPL	Stock	7.1729	7.1764	7.1696	7.1714	505036.0
2007-12-28 08:05:00	AAPL	Stock	7.1768	7.1857	7.1704	7.1839	448672.0
2007-12-28 08:06:00	AAPL	Stock	7.1839	7.1875	7.1839	7.1839	162092.0
2007-12-28 08:07:00	AAPL	Stock	7.1839	7.1875	7.1736	7.1786	188552.0
2007-12-28 08:08:00	AAPL	Stock	7.1839	7.1839	7.175	7.1786	254800.0
2007-12-28 08:09:00	AAPL	Stock	7.1782	7.1782	7.1743	7.1743	97440.0
2007-12-28 08:10:00	AAPL	Stock	7.175	7.1754	7.1714	7.1743	233800.0
2007-12-28 08:11:00	AAPL	Stock	7.1711	7.1768	7.1696	7.1743	166460.0
2007-12-28 08:12:00	AAPL	Stock	7.1732	7.1768	7.1718	7.1768	38080.0
2007-12-28 08:13:00	AAPL	Stock	7.1743	7.1768	7.1732	7.1732	33796.0
2007-12-28 08:14:00	AAPL	Stock	7.1725	7.1725	7.1696	7.1696	33740.0
2007-12-28 08:15:00	AAPL	Stock	7.1689	7.1711	7.1682	7.1711	14700.0
2007-12-28 08:16:00	AAPL	Stock	7.1696	7.1714	7.1671	7.1679	139720.0
2007-12-28 08:18:00	AAPL	Stock	7.1657	7.1679	7.1643	7.1643	80388.0
2007-12-28 08:19:00	AAPL	Stock	7.1661	7.1661	7.1661	7.1661	2800.0

> showing 50 of 984,476 rows — these rows as CSV

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