PREVIEW / stock_1hour / 2009-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-20.parquet
  size:    823 KB
  rows:    40,554
  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-02-20 07:00:00	AAPL	Stock	3.1921	3.1929	3.1643	3.1718	82320.0
2009-02-20 08:00:00	AAPL	Stock	3.1904	3.2011	3.175	3.2004	1636824.0
2009-02-20 09:00:00	AAPL	Stock	3.1982	3.2404	3.1696	3.2257	110924044.0
2009-02-20 10:00:00	AAPL	Stock	3.2261	3.24	3.1964	3.205	106689884.0
2009-02-20 11:00:00	AAPL	Stock	3.2046	3.2243	3.1975	3.2171	71017996.0
2009-02-20 12:00:00	AAPL	Stock	3.2171	3.2404	3.2118	3.2168	72077068.0
2009-02-20 13:00:00	AAPL	Stock	3.2164	3.2289	3.1964	3.2186	66261720.0
2009-02-20 14:00:00	AAPL	Stock	3.2186	3.3	3.2057	3.2729	154637560.0
2009-02-20 15:00:00	AAPL	Stock	3.2729	3.275	3.2329	3.2546	138005028.0
2009-02-20 16:00:00	AAPL	Stock	3.2564	3.2571	3.233	3.255	9938572.0
2009-02-20 17:00:00	AAPL	Stock	3.255	3.255	3.2546	3.2546	29036.0
2009-02-20 18:00:00	AAPL	Stock	3.2543	3.2579	3.2468	3.2468	327320.0
2009-02-20 19:00:00	AAPL	Stock	3.2532	3.2543	3.2479	3.2539	128940.0
2009-02-20 07:00:00	MSFT	Stock	17.62	17.62	17.6	17.6	10000.0
2009-02-20 08:00:00	MSFT	Stock	17.68	17.75	17.6	17.7	72684.0
2009-02-20 09:00:00	MSFT	Stock	17.73	18.13	17.66	18.09	12925700.0
2009-02-20 10:00:00	MSFT	Stock	18.09	18.172	17.88	17.98	9617902.0
2009-02-20 11:00:00	MSFT	Stock	17.98	18.09	17.95	18.03	5198009.0
2009-02-20 12:00:00	MSFT	Stock	18.03	18.12	17.8	17.842	5325935.0
2009-02-20 13:00:00	MSFT	Stock	17.85	17.85	17.73	17.808	4844579.0
2009-02-20 14:00:00	MSFT	Stock	17.81	18.19	17.76	18.04	13103690.0
2009-02-20 15:00:00	MSFT	Stock	18.04	18.09	17.83	17.99	14478392.0
2009-02-20 16:00:00	MSFT	Stock	17.99	18.05	17.92	18.01	2146005.0
2009-02-20 17:00:00	MSFT	Stock	17.98	18.01	17.98	18.01	1475.0
2009-02-20 18:00:00	MSFT	Stock	18.01	18.06	18.01	18.06	1900.0
2009-02-20 19:00:00	MSFT	Stock	18.01	18.05	18.01	18.05	499.0
2009-02-20 08:00:00	NVDA	Stock	0.185	0.185	0.1813	0.1838	248000.0
2009-02-20 09:00:00	NVDA	Stock	0.1818	0.1905	0.1813	0.1888	91265760.0
2009-02-20 10:00:00	NVDA	Stock	0.189	0.1915	0.1875	0.1885	95026880.0
2009-02-20 11:00:00	NVDA	Stock	0.1888	0.1895	0.187	0.1875	56012880.0
2009-02-20 12:00:00	NVDA	Stock	0.1875	0.1895	0.186	0.187	56529680.0
2009-02-20 13:00:00	NVDA	Stock	0.187	0.1878	0.185	0.1873	79092360.0
2009-02-20 14:00:00	NVDA	Stock	0.187	0.1933	0.1863	0.1918	189042920.0
2009-02-20 15:00:00	NVDA	Stock	0.1918	0.1921	0.1888	0.1903	182405400.0
2009-02-20 16:00:00	NVDA	Stock	0.1903	0.1913	0.1888	0.1888	14091760.0
2009-02-20 17:00:00	NVDA	Stock	0.19	0.19	0.19	0.19	4000.0
2009-02-20 18:00:00	NVDA	Stock	0.19	0.19	0.19	0.19	4000.0
2009-02-20 08:00:00	AMZN	Stock	3.0505	3.0505	3.0425	3.0425	155000.0
2009-02-20 09:00:00	AMZN	Stock	3.03	3.1325	3.03	3.09	26521380.0
2009-02-20 10:00:00	AMZN	Stock	3.09	3.1195	3.076	3.1007	18053840.0
2009-02-20 11:00:00	AMZN	Stock	3.101	3.1235	3.0785	3.121	14837540.0
2009-02-20 12:00:00	AMZN	Stock	3.1205	3.1365	3.101	3.114	13471220.0
2009-02-20 13:00:00	AMZN	Stock	3.115	3.1265	3.0905	3.1175	20979960.0
2009-02-20 14:00:00	AMZN	Stock	3.118	3.1885	3.112	3.171	36671440.0
2009-02-20 15:00:00	AMZN	Stock	3.171	3.2075	3.164	3.1925	50761560.0
2009-02-20 16:00:00	AMZN	Stock	3.193	3.2125	3.1364	3.1915	5193880.0
2009-02-20 17:00:00	AMZN	Stock	3.1945	3.205	3.194	3.205	12000.0
2009-02-20 18:00:00	AMZN	Stock	3.205	3.205	3.205	3.205	4000.0
2009-02-20 19:00:00	AMZN	Stock	3.2065	3.207	3.1965	3.1965	8000.0
2009-02-20 08:00:00	TLT	Stock	103.47	104.28	103.47	104.28	12700.0

> showing 50 of 40,554 rows — these rows as CSV

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