PREVIEW / stock_5min / 2007-01-19

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-01-19.parquet
  size:    3.3 MB
  rows:    240,345
  symbols: 2,500

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-01-19 04:20:00	AAPL	Stock	3.1775	3.1775	3.1775	3.1775	2800.0
2007-01-19 04:35:00	AAPL	Stock	3.1775	3.1775	3.1775	3.1775	2800.0
2007-01-19 04:50:00	AAPL	Stock	3.1818	3.1818	3.1818	3.1818	8400.0
2007-01-19 07:05:00	AAPL	Stock	3.1689	3.175	3.1689	3.175	30800.0
2007-01-19 07:10:00	AAPL	Stock	3.1693	3.1714	3.1679	3.1689	910000.0
2007-01-19 07:15:00	AAPL	Stock	3.1689	3.1689	3.1689	3.1689	131404.0
2007-01-19 07:20:00	AAPL	Stock	3.1689	3.1689	3.1689	3.1689	11200.0
2007-01-19 07:25:00	AAPL	Stock	3.1689	3.1689	3.1689	3.1689	11200.0
2007-01-19 07:30:00	AAPL	Stock	3.1689	3.1689	3.1689	3.1689	159600.0
2007-01-19 07:35:00	AAPL	Stock	3.1679	3.1679	3.1618	3.1618	95200.0
2007-01-19 07:40:00	AAPL	Stock	3.1668	3.1679	3.1643	3.1643	34720.0
2007-01-19 07:45:00	AAPL	Stock	3.1629	3.1639	3.1618	3.1639	30800.0
2007-01-19 07:50:00	AAPL	Stock	3.1643	3.1643	3.1643	3.1643	176148.0
2007-01-19 07:55:00	AAPL	Stock	3.1643	3.1643	3.1643	3.1643	130172.0
2007-01-19 08:00:00	AAPL	Stock	3.1661	3.1679	3.1571	3.1589	1431584.0
2007-01-19 08:05:00	AAPL	Stock	3.1579	3.1639	3.1579	3.1607	480760.0
2007-01-19 08:10:00	AAPL	Stock	3.1607	3.1621	3.1529	3.155	1166060.0
2007-01-19 08:15:00	AAPL	Stock	3.1557	3.16	3.155	3.1579	638736.0
2007-01-19 08:20:00	AAPL	Stock	3.1589	3.1661	3.1561	3.165	1376312.0
2007-01-19 08:25:00	AAPL	Stock	3.1643	3.1643	3.1596	3.1636	381976.0
2007-01-19 08:30:00	AAPL	Stock	3.1629	3.1714	3.1607	3.1707	668080.0
2007-01-19 08:35:00	AAPL	Stock	3.1693	3.1711	3.1675	3.1707	767228.0
2007-01-19 08:40:00	AAPL	Stock	3.1707	3.1714	3.1693	3.1707	611492.0
2007-01-19 08:45:00	AAPL	Stock	3.1707	3.1714	3.1686	3.1696	800884.0
2007-01-19 08:50:00	AAPL	Stock	3.1686	3.1707	3.1654	3.1679	673008.0
2007-01-19 08:55:00	AAPL	Stock	3.1686	3.1696	3.1607	3.1643	900788.0
2007-01-19 09:00:00	AAPL	Stock	3.1643	3.1696	3.1643	3.1679	465640.0
2007-01-19 09:05:00	AAPL	Stock	3.1679	3.1679	3.1643	3.165	220164.0
2007-01-19 09:10:00	AAPL	Stock	3.1661	3.1707	3.1661	3.1686	389760.0
2007-01-19 09:15:00	AAPL	Stock	3.17	3.1714	3.1643	3.1671	243600.0
2007-01-19 09:20:00	AAPL	Stock	3.1664	3.1679	3.1646	3.1668	1014608.0
2007-01-19 09:25:00	AAPL	Stock	3.1671	3.1679	3.1625	3.1629	2563960.0
2007-01-19 09:30:00	AAPL	Stock	3.165	3.1871	3.1471	3.1757	87289188.0
2007-01-19 09:35:00	AAPL	Stock	3.1761	3.1882	3.1646	3.185	36629068.0
2007-01-19 09:40:00	AAPL	Stock	3.1854	3.1954	3.1796	3.1811	33236504.0
2007-01-19 09:45:00	AAPL	Stock	3.1811	3.1857	3.17	3.1732	23220680.0
2007-01-19 09:50:00	AAPL	Stock	3.1732	3.175	3.1607	3.1614	23861880.0
2007-01-19 09:55:00	AAPL	Stock	3.1614	3.1661	3.1571	3.1646	26277860.0
2007-01-19 10:00:00	AAPL	Stock	3.1646	3.1704	3.1561	3.1589	29816276.0
2007-01-19 10:05:00	AAPL	Stock	3.1586	3.1657	3.155	3.1568	26132540.0
2007-01-19 10:10:00	AAPL	Stock	3.1571	3.17	3.1568	3.1679	34732152.0
2007-01-19 10:15:00	AAPL	Stock	3.1682	3.175	3.1643	3.1654	23849868.0
2007-01-19 10:20:00	AAPL	Stock	3.165	3.1661	3.1571	3.1625	19920936.0
2007-01-19 10:25:00	AAPL	Stock	3.1621	3.1768	3.1593	3.1764	27916056.0
2007-01-19 10:30:00	AAPL	Stock	3.1764	3.185	3.1757	3.1782	34134156.0
2007-01-19 10:35:00	AAPL	Stock	3.1782	3.1818	3.1725	3.1806	16013088.0
2007-01-19 10:40:00	AAPL	Stock	3.1804	3.1907	3.175	3.1902	29661800.0
2007-01-19 10:45:00	AAPL	Stock	3.1904	3.1943	3.1846	3.1882	31081484.0
2007-01-19 10:50:00	AAPL	Stock	3.1882	3.1886	3.1804	3.1832	15363460.0
2007-01-19 10:55:00	AAPL	Stock	3.1832	3.1854	3.1696	3.1707	25590992.0

> showing 50 of 240,345 rows — these rows as CSV

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