PREVIEW / stock_1hour / 2004-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-23.parquet
  size:    538 KB
  rows:    25,324
  symbols: 1,879

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-11-23 08:00:00	AAPL	Stock	1.1	1.1148	1.1	1.1071	10000592.0
2004-11-23 09:00:00	AAPL	Stock	1.1073	1.1141	1.0914	1.0934	214716600.0
2004-11-23 10:00:00	AAPL	Stock	1.0931	1.1079	1.0902	1.0964	197851080.0
2004-11-23 11:00:00	AAPL	Stock	1.0961	1.1045	1.0938	1.1014	93520784.0
2004-11-23 12:00:00	AAPL	Stock	1.102	1.1027	1.0963	1.1	71459864.0
2004-11-23 13:00:00	AAPL	Stock	1.1	1.1005	1.092	1.0968	77323960.0
2004-11-23 14:00:00	AAPL	Stock	1.0966	1.1018	1.0961	1.0995	75242272.0
2004-11-23 15:00:00	AAPL	Stock	1.0995	1.1011	1.0938	1.0939	114954000.0
2004-11-23 16:00:00	AAPL	Stock	1.0943	1.098	1.0938	1.0968	12245800.0
2004-11-23 17:00:00	AAPL	Stock	1.0964	1.0968	1.0941	1.0955	1193696.0
2004-11-23 18:00:00	AAPL	Stock	1.0946	1.0971	1.0946	1.0964	257600.0
2004-11-23 08:00:00	MSFT	Stock	26.6	26.65	26.53	26.56	91515.0
2004-11-23 09:00:00	MSFT	Stock	26.6	26.64	26.45	26.47	6498539.0
2004-11-23 10:00:00	MSFT	Stock	26.47	26.7	26.44	26.53	13302399.0
2004-11-23 11:00:00	MSFT	Stock	26.53	26.551	26.45	26.48	5440948.0
2004-11-23 12:00:00	MSFT	Stock	26.48	26.49	26.43	26.45	4589750.0
2004-11-23 13:00:00	MSFT	Stock	26.45	26.52	26.4	26.48	5925628.0
2004-11-23 14:00:00	MSFT	Stock	26.47	26.6	26.47	26.53	9049120.0
2004-11-23 15:00:00	MSFT	Stock	26.54	26.62	26.5	26.52	13452624.0
2004-11-23 16:00:00	MSFT	Stock	26.52	26.6	26.475	26.52	7199104.0
2004-11-23 17:00:00	MSFT	Stock	26.52	26.5746	26.52	26.52	2177604.0
2004-11-23 18:00:00	MSFT	Stock	26.56	26.6	26.55	26.59	17011.0
2004-11-23 08:00:00	NVDA	Stock	0.1602	0.1613	0.1602	0.1604	360000.0
2004-11-23 09:00:00	NVDA	Stock	0.1604	0.1632	0.1598	0.1625	92686320.0
2004-11-23 10:00:00	NVDA	Stock	0.1624	0.1649	0.1617	0.1624	145871280.0
2004-11-23 11:00:00	NVDA	Stock	0.1624	0.163	0.1616	0.1623	67945440.0
2004-11-23 12:00:00	NVDA	Stock	0.1623	0.1633	0.1621	0.1625	68420880.0
2004-11-23 13:00:00	NVDA	Stock	0.1625	0.1628	0.1622	0.1625	43700280.0
2004-11-23 14:00:00	NVDA	Stock	0.1626	0.1646	0.1626	0.163	118628520.0
2004-11-23 15:00:00	NVDA	Stock	0.163	0.1637	0.1626	0.1632	126536520.0
2004-11-23 16:00:00	NVDA	Stock	0.1632	0.1637	0.1625	0.1632	5829480.0
2004-11-23 17:00:00	NVDA	Stock	0.1632	0.1636	0.1632	0.1632	1169520.0
2004-11-23 18:00:00	NVDA	Stock	0.1637	0.1637	0.1637	0.1637	66000.0
2004-11-23 08:00:00	AMZN	Stock	1.9025	1.91	1.9	1.9025	59280.0
2004-11-23 09:00:00	AMZN	Stock	1.905	1.9375	1.901	1.9375	17432980.0
2004-11-23 10:00:00	AMZN	Stock	1.937	1.984	1.9295	1.9375	41714760.0
2004-11-23 11:00:00	AMZN	Stock	1.937	1.947	1.93	1.942	15018740.0
2004-11-23 12:00:00	AMZN	Stock	1.941	1.941	1.919	1.93	10748980.0
2004-11-23 13:00:00	AMZN	Stock	1.9295	1.934	1.9195	1.925	8371760.0
2004-11-23 14:00:00	AMZN	Stock	1.9255	1.9455	1.925	1.9375	14444340.0
2004-11-23 15:00:00	AMZN	Stock	1.937	1.95	1.915	1.915	29781340.0
2004-11-23 16:00:00	AMZN	Stock	1.917	1.928	1.9125	1.9155	2295740.0
2004-11-23 17:00:00	AMZN	Stock	1.9265	1.9345	1.9155	1.9155	1857600.0
2004-11-23 18:00:00	AMZN	Stock	1.9275	1.9375	1.9275	1.9375	59000.0
2004-11-23 09:00:00	CL	Stock	23.05	23.05	22.925	23.015	386600.0
2004-11-23 10:00:00	CL	Stock	23.015	23.055	22.945	22.965	578400.0
2004-11-23 11:00:00	CL	Stock	22.965	22.97	22.875	22.905	407200.0
2004-11-23 12:00:00	CL	Stock	22.905	23.0	22.9	22.905	328000.0
2004-11-23 13:00:00	CL	Stock	22.91	22.975	22.91	22.945	221200.0
2004-11-23 14:00:00	CL	Stock	22.945	23.02	22.94	22.945	473000.0

> showing 50 of 25,324 rows — these rows as CSV

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