PREVIEW / stock_1hour / 2009-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-14.parquet
  size:    811 KB
  rows:    40,302
  symbols: 3,315

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-01-14 07:00:00	AAPL	Stock	3.1125	3.1125	3.1029	3.1029	11200.0
2009-01-14 08:00:00	AAPL	Stock	3.1061	3.1071	3.0771	3.0775	976864.0
2009-01-14 09:00:00	AAPL	Stock	3.0775	3.1161	3.0686	3.0811	93068528.0
2009-01-14 10:00:00	AAPL	Stock	3.0811	3.0921	3.0489	3.0646	137857468.0
2009-01-14 11:00:00	AAPL	Stock	3.0646	3.0832	3.0521	3.0786	92251712.0
2009-01-14 12:00:00	AAPL	Stock	3.0786	3.0845	3.0536	3.0646	67746336.0
2009-01-14 13:00:00	AAPL	Stock	3.0643	3.0646	3.0357	3.0382	97279392.0
2009-01-14 14:00:00	AAPL	Stock	3.0382	3.0679	3.0275	3.0511	130365340.0
2009-01-14 15:00:00	AAPL	Stock	3.0511	3.0643	3.0257	3.0482	180513564.0
2009-01-14 16:00:00	AAPL	Stock	3.0479	3.0729	3.045	3.0572	22308412.0
2009-01-14 17:00:00	AAPL	Stock	2.8468	2.8661	2.7182	2.8625	198928856.0
2009-01-14 18:00:00	AAPL	Stock	2.8639	3.0475	2.8393	2.8418	35408968.0
2009-01-14 19:00:00	AAPL	Stock	2.8414	2.8464	2.8221	2.8321	7026684.0
2009-01-14 08:00:00	MSFT	Stock	19.65	19.67	19.53	19.56	19630.0
2009-01-14 09:00:00	MSFT	Stock	19.56	19.68	19.27	19.47	6401121.0
2009-01-14 10:00:00	MSFT	Stock	19.47	19.52	19.03	19.12	12327473.0
2009-01-14 11:00:00	MSFT	Stock	19.12	19.19	19.03	19.1	11683589.0
2009-01-14 12:00:00	MSFT	Stock	19.11	19.12	19.01	19.11	8888853.0
2009-01-14 13:00:00	MSFT	Stock	19.119	19.47	19.03	19.1	7653113.0
2009-01-14 14:00:00	MSFT	Stock	19.11	19.35	19.08	19.26	9215894.0
2009-01-14 15:00:00	MSFT	Stock	19.25	19.26	19.01	19.1	18686414.0
2009-01-14 16:00:00	MSFT	Stock	19.1	19.36	19.04	19.04	4475844.0
2009-01-14 17:00:00	MSFT	Stock	19.03	19.07	19.01	19.01	33778.0
2009-01-14 18:00:00	MSFT	Stock	19.03	19.19	19.02	19.04	57176.0
2009-01-14 19:00:00	MSFT	Stock	19.09	19.12	19.0	19.0	18049.0
2009-01-14 08:00:00	NVDA	Stock	0.1875	0.1878	0.1838	0.1845	441200.0
2009-01-14 09:00:00	NVDA	Stock	0.1835	0.1868	0.1825	0.184	145539480.0
2009-01-14 10:00:00	NVDA	Stock	0.1843	0.1865	0.1818	0.182	216262240.0
2009-01-14 11:00:00	NVDA	Stock	0.182	0.1855	0.18	0.184	170030440.0
2009-01-14 12:00:00	NVDA	Stock	0.184	0.1863	0.183	0.1835	72884120.0
2009-01-14 13:00:00	NVDA	Stock	0.1838	0.1843	0.1815	0.182	61325200.0
2009-01-14 14:00:00	NVDA	Stock	0.182	0.186	0.1813	0.1843	128860080.0
2009-01-14 15:00:00	NVDA	Stock	0.1843	0.1843	0.181	0.183	157953040.0
2009-01-14 16:00:00	NVDA	Stock	0.183	0.1834	0.1808	0.181	17504160.0
2009-01-14 17:00:00	NVDA	Stock	0.1828	0.1828	0.1825	0.1825	36080.0
2009-01-14 19:00:00	NVDA	Stock	0.1823	0.1825	0.1823	0.1825	73840.0
2009-01-14 08:00:00	AMZN	Stock	2.55	2.5695	2.513	2.513	281500.0
2009-01-14 09:00:00	AMZN	Stock	2.5125	2.5345	2.441	2.458	32572260.0
2009-01-14 10:00:00	AMZN	Stock	2.4575	2.4715	2.407	2.4305	31716920.0
2009-01-14 11:00:00	AMZN	Stock	2.4295	2.465	2.4205	2.455	21325000.0
2009-01-14 12:00:00	AMZN	Stock	2.4545	2.464	2.438	2.458	15663660.0
2009-01-14 13:00:00	AMZN	Stock	2.457	2.4572	2.43	2.443	15609840.0
2009-01-14 14:00:00	AMZN	Stock	2.442	2.4635	2.441	2.4505	30662720.0
2009-01-14 15:00:00	AMZN	Stock	2.4505	2.451	2.417	2.424	55102100.0
2009-01-14 16:00:00	AMZN	Stock	2.4255	2.446	2.405	2.419	1625180.0
2009-01-14 17:00:00	AMZN	Stock	2.4125	2.4125	2.4055	2.4095	34560.0
2009-01-14 18:00:00	AMZN	Stock	2.4095	2.4095	2.3995	2.3995	130580.0
2009-01-14 19:00:00	AMZN	Stock	2.397	2.4075	2.397	2.407	70760.0
2009-01-14 08:00:00	TLT	Stock	114.07	114.5	114.07	114.5	5700.0
2009-01-14 09:00:00	TLT	Stock	114.8	115.4	114.51	115.2828	460970.0

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

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