PREVIEW / stock_5min / 2009-04-15

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-15.parquet
  size:    4.3 MB
  rows:    299,324
  symbols: 3,308

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-04-15 07:00:00	AAPL	Stock	4.2054	4.2054	4.2054	4.2054	75600.0
2009-04-15 07:05:00	AAPL	Stock	4.2054	4.2054	4.2054	4.2054	8400.0
2009-04-15 07:25:00	AAPL	Stock	4.2071	4.2071	4.2071	4.2071	2800.0
2009-04-15 07:35:00	AAPL	Stock	4.2018	4.2029	4.2018	4.2018	14000.0
2009-04-15 07:40:00	AAPL	Stock	4.2018	4.2018	4.2018	4.2018	14000.0
2009-04-15 08:00:00	AAPL	Stock	4.1971	4.1971	4.1929	4.1929	9240.0
2009-04-15 08:05:00	AAPL	Stock	4.1964	4.1964	4.1929	4.1929	9800.0
2009-04-15 08:10:00	AAPL	Stock	4.1929	4.1964	4.1896	4.1964	42028.0
2009-04-15 08:20:00	AAPL	Stock	4.1968	4.1968	4.1893	4.1893	30800.0
2009-04-15 08:25:00	AAPL	Stock	4.1911	4.1964	4.1911	4.1911	19600.0
2009-04-15 08:30:00	AAPL	Stock	4.2025	4.2025	4.1814	4.1889	76244.0
2009-04-15 08:35:00	AAPL	Stock	4.1857	4.1889	4.1857	4.1889	98000.0
2009-04-15 08:45:00	AAPL	Stock	4.1875	4.1875	4.1875	4.1875	2800.0
2009-04-15 08:50:00	AAPL	Stock	4.1889	4.1889	4.1821	4.1821	31640.0
2009-04-15 08:55:00	AAPL	Stock	4.1821	4.1839	4.1821	4.1825	63084.0
2009-04-15 09:00:00	AAPL	Stock	4.1839	4.1839	4.1814	4.1821	42000.0
2009-04-15 09:05:00	AAPL	Stock	4.1821	4.1886	4.1821	4.1886	52360.0
2009-04-15 09:10:00	AAPL	Stock	4.1886	4.1889	4.1879	4.1879	77840.0
2009-04-15 09:15:00	AAPL	Stock	4.1854	4.1854	4.1854	4.1854	2800.0
2009-04-15 09:20:00	AAPL	Stock	4.1864	4.1925	4.1807	4.1925	84672.0
2009-04-15 09:25:00	AAPL	Stock	4.1821	4.1868	4.175	4.1793	150528.0
2009-04-15 09:30:00	AAPL	Stock	4.1818	4.2054	4.1714	4.1991	8761032.0
2009-04-15 09:35:00	AAPL	Stock	4.1979	4.2086	4.1814	4.1954	19472460.0
2009-04-15 09:40:00	AAPL	Stock	4.1957	4.2075	4.19	4.205	7234556.0
2009-04-15 09:45:00	AAPL	Stock	4.205	4.205	4.1786	4.1811	6162240.0
2009-04-15 09:50:00	AAPL	Stock	4.1814	4.2014	4.1804	4.19	7283332.0
2009-04-15 09:55:00	AAPL	Stock	4.19	4.2025	4.1857	4.2007	6805596.0
2009-04-15 10:00:00	AAPL	Stock	4.2011	4.2018	4.1896	4.1979	5072116.0
2009-04-15 10:05:00	AAPL	Stock	4.1975	4.2204	4.1914	4.2182	5561948.0
2009-04-15 10:10:00	AAPL	Stock	4.2189	4.2232	4.2093	4.2132	7579012.0
2009-04-15 10:15:00	AAPL	Stock	4.2134	4.2147	4.1914	4.1914	7897568.0
2009-04-15 10:20:00	AAPL	Stock	4.1918	4.2025	4.1893	4.1961	4407704.0
2009-04-15 10:25:00	AAPL	Stock	4.1968	4.2021	4.19	4.1979	3389820.0
2009-04-15 10:30:00	AAPL	Stock	4.1984	4.2	4.1793	4.1943	4822104.0
2009-04-15 10:35:00	AAPL	Stock	4.1936	4.195	4.1843	4.1879	3270820.0
2009-04-15 10:40:00	AAPL	Stock	4.1882	4.1932	4.1839	4.1886	3088400.0
2009-04-15 10:45:00	AAPL	Stock	4.1893	4.1914	4.18	4.18	3068072.0
2009-04-15 10:50:00	AAPL	Stock	4.1811	4.1825	4.1646	4.165	5787320.0
2009-04-15 10:55:00	AAPL	Stock	4.165	4.1714	4.1536	4.1554	7599900.0
2009-04-15 11:00:00	AAPL	Stock	4.1554	4.1564	4.1386	4.1396	9407664.0
2009-04-15 11:05:00	AAPL	Stock	4.1393	4.1443	4.1343	4.1379	6821192.0
2009-04-15 11:10:00	AAPL	Stock	4.1385	4.1482	4.1361	4.1475	5128032.0
2009-04-15 11:15:00	AAPL	Stock	4.1475	4.1479	4.1343	4.1406	4079824.0
2009-04-15 11:20:00	AAPL	Stock	4.1407	4.1554	4.1407	4.1496	4055632.0
2009-04-15 11:25:00	AAPL	Stock	4.1499	4.1539	4.1439	4.1443	3086636.0
2009-04-15 11:30:00	AAPL	Stock	4.1443	4.16	4.1443	4.1579	4289292.0
2009-04-15 11:35:00	AAPL	Stock	4.1571	4.165	4.1568	4.1593	3930248.0
2009-04-15 11:40:00	AAPL	Stock	4.1602	4.1671	4.1596	4.1604	3000312.0
2009-04-15 11:45:00	AAPL	Stock	4.1607	4.1618	4.155	4.157	2733108.0
2009-04-15 11:50:00	AAPL	Stock	4.1557	4.1571	4.1471	4.1482	3022096.0

> showing 50 of 299,324 rows — these rows as CSV

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