PREVIEW / stock_1hour / 2005-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-31.parquet
  size:    550 KB
  rows:    26,053
  symbols: 1,930

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
2005-01-31 08:00:00	AAPL	Stock	1.3263	1.3434	1.3263	1.3393	8175608.0
2005-01-31 09:00:00	AAPL	Stock	1.3393	1.348	1.3214	1.3445	264862360.0
2005-01-31 10:00:00	AAPL	Stock	1.3445	1.3598	1.3423	1.3571	308171528.0
2005-01-31 11:00:00	AAPL	Stock	1.3571	1.3848	1.3563	1.3754	367586632.0
2005-01-31 12:00:00	AAPL	Stock	1.3754	1.385	1.3725	1.3788	159676832.0
2005-01-31 13:00:00	AAPL	Stock	1.3788	1.383	1.3754	1.3827	82171320.0
2005-01-31 14:00:00	AAPL	Stock	1.3829	1.3909	1.3805	1.3843	176124200.0
2005-01-31 15:00:00	AAPL	Stock	1.3845	1.3859	1.3643	1.3729	294954968.0
2005-01-31 16:00:00	AAPL	Stock	1.3718	1.3732	1.3696	1.3732	6699168.0
2005-01-31 17:00:00	AAPL	Stock	1.3698	1.373	1.3696	1.3721	1471960.0
2005-01-31 18:00:00	AAPL	Stock	1.3721	1.373	1.3716	1.372	192752.0
2005-01-31 08:00:00	MSFT	Stock	26.35	26.35	26.28	26.3	93292.0
2005-01-31 09:00:00	MSFT	Stock	26.31	26.49	26.2	26.48	11126230.0
2005-01-31 10:00:00	MSFT	Stock	26.48	26.52	26.34	26.378	12534054.0
2005-01-31 11:00:00	MSFT	Stock	26.38	26.43	26.35	26.42	5727945.0
2005-01-31 12:00:00	MSFT	Stock	26.42	26.45	26.39	26.42	4873627.0
2005-01-31 13:00:00	MSFT	Stock	26.42	26.44	26.31	26.32	6087015.0
2005-01-31 14:00:00	MSFT	Stock	26.32	26.32	26.2	26.26	11196042.0
2005-01-31 15:00:00	MSFT	Stock	26.26	26.3	26.16	26.26	16044396.0
2005-01-31 16:00:00	MSFT	Stock	26.28	26.41	26.26	26.28	709684.0
2005-01-31 17:00:00	MSFT	Stock	26.28	26.28	26.2	26.2	424877.0
2005-01-31 18:00:00	MSFT	Stock	26.26	26.28	26.25	26.25	1485.0
2005-01-31 08:00:00	NVDA	Stock	0.1928	0.1928	0.1921	0.1928	51000.0
2005-01-31 09:00:00	NVDA	Stock	0.1925	0.1946	0.1907	0.1933	96291840.0
2005-01-31 10:00:00	NVDA	Stock	0.1933	0.1935	0.1893	0.1907	131336400.0
2005-01-31 11:00:00	NVDA	Stock	0.1907	0.1917	0.1902	0.1914	53139480.0
2005-01-31 12:00:00	NVDA	Stock	0.1915	0.1922	0.1908	0.192	41687880.0
2005-01-31 13:00:00	NVDA	Stock	0.192	0.1931	0.1918	0.193	28503360.0
2005-01-31 14:00:00	NVDA	Stock	0.193	0.1932	0.1901	0.1902	62885520.0
2005-01-31 15:00:00	NVDA	Stock	0.1901	0.1925	0.1883	0.1914	140058240.0
2005-01-31 16:00:00	NVDA	Stock	0.1912	0.1916	0.1904	0.191	4027920.0
2005-01-31 17:00:00	NVDA	Stock	0.1917	0.1917	0.191	0.191	171720.0
2005-01-31 18:00:00	NVDA	Stock	0.1909	0.1909	0.1909	0.1909	48000.0
2005-01-31 08:00:00	AMZN	Stock	2.125	2.125	2.12	2.12	76680.0
2005-01-31 09:00:00	AMZN	Stock	2.1205	2.137	2.111	2.133	12864120.0
2005-01-31 10:00:00	AMZN	Stock	2.133	2.143	2.1295	2.1365	15910080.0
2005-01-31 11:00:00	AMZN	Stock	2.1365	2.1435	2.133	2.1425	10810360.0
2005-01-31 12:00:00	AMZN	Stock	2.1425	2.149	2.14	2.1435	16500840.0
2005-01-31 13:00:00	AMZN	Stock	2.1435	2.1445	2.141	2.1425	7414020.0
2005-01-31 14:00:00	AMZN	Stock	2.143	2.171	2.1425	2.1605	30600920.0
2005-01-31 15:00:00	AMZN	Stock	2.1605	2.165	2.1465	2.1605	30324420.0
2005-01-31 16:00:00	AMZN	Stock	2.1605	2.17	2.158	2.161	1592720.0
2005-01-31 17:00:00	AMZN	Stock	2.161	2.161	2.1606	2.161	185280.0
2005-01-31 18:00:00	AMZN	Stock	2.1625	2.1625	2.1625	2.1625	6000.0
2005-01-31 09:00:00	CL	Stock	26.0	26.14	25.89	26.105	835200.0
2005-01-31 10:00:00	CL	Stock	26.115	26.235	26.0	26.09	1631200.0
2005-01-31 11:00:00	CL	Stock	26.09	26.09	25.96	26.005	1038200.0
2005-01-31 12:00:00	CL	Stock	26.015	26.1	25.965	26.1	779200.0
2005-01-31 13:00:00	CL	Stock	26.1	26.18	26.055	26.06	529000.0
2005-01-31 14:00:00	CL	Stock	26.065	26.175	26.06	26.145	701600.0

> showing 50 of 26,053 rows — these rows as CSV

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