PREVIEW / stock_1hour / 2004-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-05.parquet
  size:    502 KB
  rows:    22,818
  symbols: 1,731

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-03-05 08:00:00	AAPL	Stock	0.4493	0.4493	0.4446	0.4464	1591296.0
2004-03-05 09:00:00	AAPL	Stock	0.4473	0.4832	0.4291	0.4768	208374096.0
2004-03-05 10:00:00	AAPL	Stock	0.4771	0.4909	0.4711	0.4773	391124720.0
2004-03-05 11:00:00	AAPL	Stock	0.4773	0.4789	0.4682	0.4768	145637576.0
2004-03-05 12:00:00	AAPL	Stock	0.4766	0.483	0.4761	0.482	106867152.0
2004-03-05 13:00:00	AAPL	Stock	0.4821	0.4825	0.4765	0.4786	115086944.0
2004-03-05 14:00:00	AAPL	Stock	0.4786	0.483	0.4782	0.4821	86217320.0
2004-03-05 15:00:00	AAPL	Stock	0.482	0.4838	0.4775	0.4788	186473056.0
2004-03-05 16:00:00	AAPL	Stock	0.4788	0.4792	0.4753	0.4777	6265336.0
2004-03-05 17:00:00	AAPL	Stock	0.478	0.478	0.4777	0.478	64120.0
2004-03-05 18:00:00	AAPL	Stock	0.4775	0.4786	0.4775	0.4786	64400.0
2004-03-05 08:00:00	MSFT	Stock	26.35	26.38	26.21	26.21	194466.0
2004-03-05 09:00:00	MSFT	Stock	26.24	26.45	26.21	26.33	6710400.0
2004-03-05 10:00:00	MSFT	Stock	26.33	26.59	26.33	26.58	8980106.0
2004-03-05 11:00:00	MSFT	Stock	26.58	26.6	26.34	26.42	8334974.0
2004-03-05 12:00:00	MSFT	Stock	26.42	26.53	26.38	26.41	3889078.0
2004-03-05 13:00:00	MSFT	Stock	26.41	26.44	26.3	26.34	4138325.0
2004-03-05 14:00:00	MSFT	Stock	26.34	26.5	26.31	26.41	6111301.0
2004-03-05 15:00:00	MSFT	Stock	26.4	26.49	26.32	26.35	9762697.0
2004-03-05 16:00:00	MSFT	Stock	26.35	26.46	26.29	26.34	1292618.0
2004-03-05 17:00:00	MSFT	Stock	26.35	26.35	26.34	26.35	3450.0
2004-03-05 18:00:00	MSFT	Stock	26.35	26.35	26.35	26.35	400.0
2004-03-05 08:00:00	NVDA	Stock	0.1825	0.1863	0.1823	0.1823	5676000.0
2004-03-05 09:00:00	NVDA	Stock	0.1825	0.1843	0.1814	0.1842	25999200.0
2004-03-05 10:00:00	NVDA	Stock	0.1842	0.1892	0.1842	0.1871	88139400.0
2004-03-05 11:00:00	NVDA	Stock	0.1871	0.1883	0.1838	0.1857	56374440.0
2004-03-05 12:00:00	NVDA	Stock	0.1856	0.1874	0.1851	0.1869	43441680.0
2004-03-05 13:00:00	NVDA	Stock	0.1869	0.1873	0.1857	0.1862	18863040.0
2004-03-05 14:00:00	NVDA	Stock	0.1859	0.1874	0.1858	0.1868	24345600.0
2004-03-05 15:00:00	NVDA	Stock	0.1867	0.1868	0.1847	0.1847	27337680.0
2004-03-05 16:00:00	NVDA	Stock	0.1847	0.1864	0.1847	0.1849	3633240.0
2004-03-05 08:00:00	AMZN	Stock	2.218	2.225	2.19	2.19	317000.0
2004-03-05 09:00:00	AMZN	Stock	2.192	2.219	2.1765	2.201	15939000.0
2004-03-05 10:00:00	AMZN	Stock	2.202	2.2415	2.202	2.231	27749740.0
2004-03-05 11:00:00	AMZN	Stock	2.2315	2.234	2.196	2.2095	22793840.0
2004-03-05 12:00:00	AMZN	Stock	2.2102	2.2115	2.1924	2.206	10238020.0
2004-03-05 13:00:00	AMZN	Stock	2.2059	2.212	2.1965	2.201	6700540.0
2004-03-05 14:00:00	AMZN	Stock	2.201	2.2095	2.196	2.2025	9423800.0
2004-03-05 15:00:00	AMZN	Stock	2.2025	2.2145	2.198	2.202	12087140.0
2004-03-05 16:00:00	AMZN	Stock	2.2005	2.2078	2.197	2.201	694620.0
2004-03-05 17:00:00	AMZN	Stock	2.201	2.201	2.201	2.201	14520.0
2004-03-05 09:00:00	CL	Stock	27.97	28.015	27.94	27.95	263200.0
2004-03-05 10:00:00	CL	Stock	27.945	28.125	27.94	27.975	582800.0
2004-03-05 11:00:00	CL	Stock	27.975	28.015	27.74	27.945	367400.0
2004-03-05 12:00:00	CL	Stock	27.945	27.98	27.905	27.96	219200.0
2004-03-05 13:00:00	CL	Stock	27.965	28.055	27.945	27.995	178600.0
2004-03-05 14:00:00	CL	Stock	28.0	28.15	28.0	28.13	392600.0
2004-03-05 15:00:00	CL	Stock	28.125	28.25	28.085	28.185	461800.0
2004-03-05 16:00:00	CL	Stock	28.175	28.175	28.0345	28.175	29200.0

> showing 49 of 22,818 rows — these rows as CSV

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