PREVIEW / stock_5min / 2009-09-09

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-09.parquet
  size:    4.6 MB
  rows:    316,485
  symbols: 3,366

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
2009-09-09 05:25:00	AAPL	Stock	6.1946	6.1946	6.1946	6.1946	2800.0
2009-09-09 07:05:00	AAPL	Stock	6.1939	6.1943	6.1939	6.1943	14000.0
2009-09-09 07:15:00	AAPL	Stock	6.1786	6.1814	6.1786	6.1814	29680.0
2009-09-09 07:20:00	AAPL	Stock	6.1821	6.1821	6.1821	6.1821	2800.0
2009-09-09 07:50:00	AAPL	Stock	6.175	6.175	6.1714	6.1714	9240.0
2009-09-09 07:55:00	AAPL	Stock	6.1718	6.1718	6.1718	6.1718	5600.0
2009-09-09 08:00:00	AAPL	Stock	6.175	6.175	6.155	6.1575	239260.0
2009-09-09 08:05:00	AAPL	Stock	6.1575	6.1711	6.1575	6.1657	111300.0
2009-09-09 08:10:00	AAPL	Stock	6.1661	6.1661	6.1654	6.1661	15064.0
2009-09-09 08:15:00	AAPL	Stock	6.1654	6.1679	6.1643	6.1643	59640.0
2009-09-09 08:20:00	AAPL	Stock	6.1639	6.1714	6.1639	6.1714	50596.0
2009-09-09 08:25:00	AAPL	Stock	6.1725	6.1775	6.1725	6.175	94640.0
2009-09-09 08:30:00	AAPL	Stock	6.1764	6.1771	6.175	6.175	16184.0
2009-09-09 08:35:00	AAPL	Stock	6.1743	6.175	6.1711	6.1711	130200.0
2009-09-09 08:40:00	AAPL	Stock	6.1682	6.1682	6.1682	6.1682	11200.0
2009-09-09 08:45:00	AAPL	Stock	6.1682	6.1682	6.1664	6.1679	46396.0
2009-09-09 08:50:00	AAPL	Stock	6.1679	6.1679	6.1675	6.1675	23856.0
2009-09-09 08:55:00	AAPL	Stock	6.1668	6.1729	6.1668	6.1693	61516.0
2009-09-09 09:00:00	AAPL	Stock	6.1689	6.1711	6.1689	6.1711	46900.0
2009-09-09 09:05:00	AAPL	Stock	6.1721	6.1721	6.1682	6.1693	39200.0
2009-09-09 09:10:00	AAPL	Stock	6.1696	6.1714	6.1679	6.1696	92400.0
2009-09-09 09:15:00	AAPL	Stock	6.1686	6.1714	6.1686	6.1686	22792.0
2009-09-09 09:20:00	AAPL	Stock	6.1707	6.1714	6.1682	6.1682	52192.0
2009-09-09 09:25:00	AAPL	Stock	6.1696	6.1732	6.1643	6.17	140084.0
2009-09-09 09:30:00	AAPL	Stock	6.1721	6.1775	6.1336	6.1375	15241772.0
2009-09-09 09:35:00	AAPL	Stock	6.1382	6.1564	6.1254	6.1429	10848656.0
2009-09-09 09:40:00	AAPL	Stock	6.1429	6.1529	6.1382	6.1514	6200208.0
2009-09-09 09:45:00	AAPL	Stock	6.1518	6.1679	6.1482	6.1604	9458876.0
2009-09-09 09:50:00	AAPL	Stock	6.16	6.1782	6.1589	6.175	7735756.0
2009-09-09 09:55:00	AAPL	Stock	6.1754	6.1829	6.1646	6.1657	7155008.0
2009-09-09 10:00:00	AAPL	Stock	6.1657	6.1754	6.1657	6.1721	5505752.0
2009-09-09 10:05:00	AAPL	Stock	6.1725	6.1839	6.1675	6.1797	7693056.0
2009-09-09 10:10:00	AAPL	Stock	6.1804	6.1825	6.1679	6.1705	4291280.0
2009-09-09 10:15:00	AAPL	Stock	6.171	6.1782	6.1707	6.1764	3701992.0
2009-09-09 10:20:00	AAPL	Stock	6.1764	6.1779	6.1621	6.1668	4609332.0
2009-09-09 10:25:00	AAPL	Stock	6.1671	6.1675	6.1579	6.1646	3288152.0
2009-09-09 10:30:00	AAPL	Stock	6.1646	6.1671	6.1593	6.1636	2710792.0
2009-09-09 10:35:00	AAPL	Stock	6.1639	6.1654	6.1568	6.1621	3255252.0
2009-09-09 10:40:00	AAPL	Stock	6.1625	6.1643	6.1582	6.1593	2546628.0
2009-09-09 10:45:00	AAPL	Stock	6.1589	6.1614	6.1511	6.1539	3764348.0
2009-09-09 10:50:00	AAPL	Stock	6.1537	6.1579	6.1511	6.1571	2399600.0
2009-09-09 10:55:00	AAPL	Stock	6.1571	6.1607	6.1536	6.1586	2164260.0
2009-09-09 11:00:00	AAPL	Stock	6.1589	6.1714	6.1586	6.1693	3743180.0
2009-09-09 11:05:00	AAPL	Stock	6.1682	6.1707	6.1593	6.1614	3350144.0
2009-09-09 11:10:00	AAPL	Stock	6.1614	6.1636	6.1546	6.1561	2834300.0
2009-09-09 11:15:00	AAPL	Stock	6.1561	6.1636	6.1557	6.1586	3183124.0
2009-09-09 11:20:00	AAPL	Stock	6.1589	6.1714	6.1543	6.1714	5282172.0
2009-09-09 11:25:00	AAPL	Stock	6.1714	6.1764	6.1704	6.1725	4156040.0
2009-09-09 11:30:00	AAPL	Stock	6.1718	6.1796	6.1714	6.1771	6407492.0
2009-09-09 11:35:00	AAPL	Stock	6.1771	6.1786	6.1711	6.1771	3123400.0

> showing 50 of 316,485 rows — these rows as CSV

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