PREVIEW / stock_1hour / 2004-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-12-17.parquet
  size:    578 KB
  rows:    27,307
  symbols: 1,896

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
2004-12-17 08:00:00	AAPL	Stock	1.1964	1.1964	1.1843	1.1938	1012984.0
2004-12-17 09:00:00	AAPL	Stock	1.1932	1.1971	1.1809	1.1829	106560944.0
2004-12-17 10:00:00	AAPL	Stock	1.183	1.1877	1.1705	1.1709	102461688.0
2004-12-17 11:00:00	AAPL	Stock	1.1713	1.1718	1.1596	1.1638	115865064.0
2004-12-17 12:00:00	AAPL	Stock	1.1638	1.1695	1.1618	1.165	68192488.0
2004-12-17 13:00:00	AAPL	Stock	1.1646	1.167	1.1625	1.1654	32797240.0
2004-12-17 14:00:00	AAPL	Stock	1.1654	1.1661	1.163	1.1641	63789096.0
2004-12-17 15:00:00	AAPL	Stock	1.1641	1.1643	1.1589	1.1605	171341240.0
2004-12-17 16:00:00	AAPL	Stock	1.1605	1.1627	1.1593	1.1609	71731128.0
2004-12-17 17:00:00	AAPL	Stock	1.1626	1.1736	1.1607	1.1621	36209432.0
2004-12-17 18:00:00	AAPL	Stock	1.1621	1.163	1.1607	1.1607	4898096.0
2004-12-17 08:00:00	MSFT	Stock	27.165	27.165	27.1	27.15	31355.0
2004-12-17 09:00:00	MSFT	Stock	27.15	27.26	26.92	27.25	23243824.0
2004-12-17 10:00:00	MSFT	Stock	27.25	27.32	27.19	27.29	21620306.0
2004-12-17 11:00:00	MSFT	Stock	27.29	27.3	27.14	27.17	12550670.0
2004-12-17 12:00:00	MSFT	Stock	27.18	27.2	27.12	27.132	7625377.0
2004-12-17 13:00:00	MSFT	Stock	27.13	27.24	27.12	27.18	11525458.0
2004-12-17 14:00:00	MSFT	Stock	27.18	27.19	27.1	27.1	12909226.0
2004-12-17 15:00:00	MSFT	Stock	27.1	27.13	26.95	26.95	15153837.0
2004-12-17 16:00:00	MSFT	Stock	26.95	27.04	26.8	26.805	13089460.0
2004-12-17 17:00:00	MSFT	Stock	26.8	27.02	26.795	26.96	2006001.0
2004-12-17 18:00:00	MSFT	Stock	26.93	27.0623	26.8	26.89	730590.0
2004-12-17 08:00:00	NVDA	Stock	0.199	0.2009	0.199	0.2009	228000.0
2004-12-17 09:00:00	NVDA	Stock	0.1992	0.2016	0.1982	0.199	94859760.0
2004-12-17 10:00:00	NVDA	Stock	0.1989	0.1991	0.1948	0.1961	119189280.0
2004-12-17 11:00:00	NVDA	Stock	0.1961	0.1961	0.1945	0.1957	55735080.0
2004-12-17 12:00:00	NVDA	Stock	0.1956	0.1957	0.1934	0.1934	52734240.0
2004-12-17 13:00:00	NVDA	Stock	0.1935	0.1938	0.192	0.192	93060000.0
2004-12-17 14:00:00	NVDA	Stock	0.192	0.1939	0.1908	0.1934	133262160.0
2004-12-17 15:00:00	NVDA	Stock	0.1934	0.1939	0.1899	0.1922	343104720.0
2004-12-17 16:00:00	NVDA	Stock	0.1922	0.1937	0.1905	0.1915	247537200.0
2004-12-17 17:00:00	NVDA	Stock	0.1914	0.1945	0.1914	0.1914	7196760.0
2004-12-17 18:00:00	NVDA	Stock	0.1914	0.1917	0.1914	0.1917	1838400.0
2004-12-17 08:00:00	AMZN	Stock	2.001	2.002	2.001	2.002	19860.0
2004-12-17 09:00:00	AMZN	Stock	2.002	2.0115	1.996	2.0025	13220740.0
2004-12-17 10:00:00	AMZN	Stock	2.001	2.005	1.9935	1.9955	17394920.0
2004-12-17 11:00:00	AMZN	Stock	1.9955	2.0036	1.995	2.0025	11393800.0
2004-12-17 12:00:00	AMZN	Stock	2.002	2.003	2.0	2.0015	5837300.0
2004-12-17 13:00:00	AMZN	Stock	2.0015	2.0045	1.9995	2.0015	6830860.0
2004-12-17 14:00:00	AMZN	Stock	2.0015	2.006	2.0	2.0025	17514020.0
2004-12-17 15:00:00	AMZN	Stock	2.0025	2.0035	2.0	2.0005	23662840.0
2004-12-17 16:00:00	AMZN	Stock	2.0005	2.005	2.0	2.0	6116160.0
2004-12-17 17:00:00	AMZN	Stock	2.0	2.0013	2.0	2.0	1667560.0
2004-12-17 18:00:00	AMZN	Stock	2.0005	2.0005	1.9975	2.0005	151600.0
2004-12-17 09:00:00	CL	Stock	24.75	25.0	24.75	24.97	1581200.0
2004-12-17 10:00:00	CL	Stock	24.95	24.995	24.85	24.95	526200.0
2004-12-17 11:00:00	CL	Stock	24.95	24.96	24.75	24.82	422600.0
2004-12-17 12:00:00	CL	Stock	24.82	24.84	24.7	24.715	404800.0
2004-12-17 13:00:00	CL	Stock	24.715	24.815	24.695	24.81	366000.0
2004-12-17 14:00:00	CL	Stock	24.81	24.945	24.78	24.92	375600.0

> showing 50 of 27,307 rows — these rows as CSV

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