PREVIEW / stock_1min / 2008-08-27

all stock 1-min files

  file:    by_date/stock_1min/2008/2008-08-27.parquet
  size:    11.7 MB
  rows:    957,947
  symbols: 2,679

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
2008-08-27 07:23:00	AAPL	Stock	6.2036	6.2036	6.2036	6.2036	2800.0
2008-08-27 07:30:00	AAPL	Stock	6.1964	6.1964	6.1964	6.1964	3920.0
2008-08-27 07:57:00	AAPL	Stock	6.1968	6.1968	6.1968	6.1968	5600.0
2008-08-27 08:00:00	AAPL	Stock	6.1932	6.1932	6.1786	6.1786	126840.0
2008-08-27 08:01:00	AAPL	Stock	6.1779	6.1779	6.1779	6.1779	4200.0
2008-08-27 08:04:00	AAPL	Stock	6.1764	6.1768	6.1764	6.1768	5880.0
2008-08-27 08:05:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	28000.0
2008-08-27 08:06:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	7028.0
2008-08-27 08:14:00	AAPL	Stock	6.1861	6.1861	6.1857	6.1857	16800.0
2008-08-27 08:15:00	AAPL	Stock	6.1839	6.1839	6.1839	6.1839	14000.0
2008-08-27 08:16:00	AAPL	Stock	6.1821	6.1821	6.1786	6.1786	155820.0
2008-08-27 08:17:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-08-27 08:21:00	AAPL	Stock	6.1786	6.1821	6.1786	6.1821	15036.0
2008-08-27 08:22:00	AAPL	Stock	6.1821	6.1821	6.1821	6.1821	7000.0
2008-08-27 08:23:00	AAPL	Stock	6.1804	6.1804	6.1786	6.1786	10024.0
2008-08-27 08:26:00	AAPL	Stock	6.1789	6.1796	6.1786	6.1786	25900.0
2008-08-27 08:28:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-08-27 08:30:00	AAPL	Stock	6.1821	6.2054	6.1821	6.1946	75376.0
2008-08-27 08:31:00	AAPL	Stock	6.2007	6.2014	6.2	6.2	63000.0
2008-08-27 08:32:00	AAPL	Stock	6.2018	6.2139	6.2018	6.2139	79856.0
2008-08-27 08:33:00	AAPL	Stock	6.21	6.2107	6.1907	6.1907	61376.0
2008-08-27 08:35:00	AAPL	Stock	6.2014	6.2014	6.2014	6.2014	2800.0
2008-08-27 08:36:00	AAPL	Stock	6.2014	6.2086	6.2014	6.2086	37800.0
2008-08-27 08:37:00	AAPL	Stock	6.21	6.2146	6.2089	6.2143	233744.0
2008-08-27 08:38:00	AAPL	Stock	6.2143	6.2189	6.2143	6.2171	19600.0
2008-08-27 08:39:00	AAPL	Stock	6.2136	6.2136	6.2118	6.2118	5600.0
2008-08-27 08:40:00	AAPL	Stock	6.2143	6.2143	6.2143	6.2143	7000.0
2008-08-27 08:41:00	AAPL	Stock	6.2143	6.2143	6.2139	6.2143	30800.0
2008-08-27 08:42:00	AAPL	Stock	6.2139	6.2139	6.2107	6.2107	94836.0
2008-08-27 08:43:00	AAPL	Stock	6.2139	6.2139	6.21	6.21	28364.0
2008-08-27 08:44:00	AAPL	Stock	6.2107	6.2107	6.2107	6.2107	5600.0
2008-08-27 08:45:00	AAPL	Stock	6.2107	6.2107	6.2107	6.2107	28000.0
2008-08-27 08:46:00	AAPL	Stock	6.21	6.21	6.21	6.21	14000.0
2008-08-27 08:47:00	AAPL	Stock	6.2129	6.2132	6.2129	6.2132	30800.0
2008-08-27 08:48:00	AAPL	Stock	6.2107	6.2107	6.2107	6.2107	5600.0
2008-08-27 08:49:00	AAPL	Stock	6.2132	6.2132	6.2132	6.2132	12600.0
2008-08-27 08:50:00	AAPL	Stock	6.2132	6.2139	6.2104	6.2104	79800.0
2008-08-27 08:51:00	AAPL	Stock	6.2093	6.2093	6.2093	6.2093	2800.0
2008-08-27 08:52:00	AAPL	Stock	6.2107	6.2107	6.2093	6.2093	5600.0
2008-08-27 08:53:00	AAPL	Stock	6.2104	6.2104	6.2104	6.2104	14000.0
2008-08-27 08:55:00	AAPL	Stock	6.2093	6.2139	6.2089	6.2139	119224.0
2008-08-27 08:56:00	AAPL	Stock	6.2089	6.2107	6.2082	6.21	19600.0
2008-08-27 08:57:00	AAPL	Stock	6.2104	6.2107	6.2104	6.2107	11200.0
2008-08-27 08:58:00	AAPL	Stock	6.2107	6.2107	6.2107	6.2107	5600.0
2008-08-27 08:59:00	AAPL	Stock	6.2107	6.2107	6.2089	6.2089	139860.0
2008-08-27 09:00:00	AAPL	Stock	6.2089	6.2089	6.2089	6.2089	16940.0
2008-08-27 09:02:00	AAPL	Stock	6.2082	6.2104	6.2082	6.2104	21000.0
2008-08-27 09:04:00	AAPL	Stock	6.2071	6.2089	6.2068	6.2068	78400.0
2008-08-27 09:05:00	AAPL	Stock	6.2029	6.2036	6.2029	6.2036	5600.0
2008-08-27 09:08:00	AAPL	Stock	6.2054	6.2068	6.2054	6.2068	15176.0

> showing 50 of 957,947 rows — these rows as CSV

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