PREVIEW / stock_1hour / 2004-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-12.parquet
  size:    490 KB
  rows:    22,979
  symbols: 1,755

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-04-12 08:00:00	AAPL	Stock	0.4945	0.4945	0.4943	0.4943	134400.0
2004-04-12 09:00:00	AAPL	Stock	0.492	0.4964	0.4909	0.4925	15097152.0
2004-04-12 10:00:00	AAPL	Stock	0.4925	0.498	0.4925	0.4977	20837712.0
2004-04-12 11:00:00	AAPL	Stock	0.4977	0.4989	0.4955	0.4986	20278496.0
2004-04-12 12:00:00	AAPL	Stock	0.4986	0.5	0.4986	0.4988	29367744.0
2004-04-12 13:00:00	AAPL	Stock	0.4989	0.5007	0.4988	0.5	32085144.0
2004-04-12 14:00:00	AAPL	Stock	0.5	0.5018	0.4995	0.4995	43708896.0
2004-04-12 15:00:00	AAPL	Stock	0.4996	0.5007	0.4988	0.4996	37780120.0
2004-04-12 16:00:00	AAPL	Stock	0.4996	0.5025	0.4995	0.5007	1346800.0
2004-04-12 17:00:00	AAPL	Stock	0.5018	0.5018	0.5	0.5	50400.0
2004-04-12 08:00:00	MSFT	Stock	25.68	25.68	25.57	25.58	17593.0
2004-04-12 09:00:00	MSFT	Stock	25.58	25.67	25.42	25.63	4807881.0
2004-04-12 10:00:00	MSFT	Stock	25.63	25.72	25.61	25.69	6491954.0
2004-04-12 11:00:00	MSFT	Stock	25.68	25.72	25.6	25.72	4971859.0
2004-04-12 12:00:00	MSFT	Stock	25.72	25.74	25.65	25.66	4043264.0
2004-04-12 13:00:00	MSFT	Stock	25.66	25.6802	25.6	25.62	2961348.0
2004-04-12 14:00:00	MSFT	Stock	25.62	25.67	25.61	25.62	3684862.0
2004-04-12 15:00:00	MSFT	Stock	25.63	25.69	25.6	25.61	5940070.0
2004-04-12 16:00:00	MSFT	Stock	25.61	25.68	25.55	25.61	344973.0
2004-04-12 17:00:00	MSFT	Stock	25.61	25.61	25.58	25.61	32234.0
2004-04-12 18:00:00	MSFT	Stock	25.61	25.61	25.59	25.59	20900.0
2004-04-12 08:00:00	NVDA	Stock	0.2257	0.2258	0.2257	0.2258	138000.0
2004-04-12 09:00:00	NVDA	Stock	0.2258	0.2258	0.2228	0.2236	24418560.0
2004-04-12 10:00:00	NVDA	Stock	0.2236	0.2242	0.2205	0.221	49596480.0
2004-04-12 11:00:00	NVDA	Stock	0.221	0.221	0.2177	0.2201	118041120.0
2004-04-12 12:00:00	NVDA	Stock	0.2199	0.22	0.2187	0.2192	23196720.0
2004-04-12 13:00:00	NVDA	Stock	0.2192	0.2198	0.2182	0.2186	23846400.0
2004-04-12 14:00:00	NVDA	Stock	0.2186	0.2197	0.2173	0.2179	38856240.0
2004-04-12 15:00:00	NVDA	Stock	0.2179	0.219	0.2176	0.2187	81669960.0
2004-04-12 16:00:00	NVDA	Stock	0.2187	0.2188	0.2179	0.2187	3049080.0
2004-04-12 17:00:00	NVDA	Stock	0.2181	0.2181	0.2181	0.2181	12000.0
2004-04-12 08:00:00	AMZN	Stock	2.425	2.426	2.4125	2.4175	159160.0
2004-04-12 09:00:00	AMZN	Stock	2.4175	2.4175	2.3835	2.3925	15438600.0
2004-04-12 10:00:00	AMZN	Stock	2.3925	2.3945	2.3785	2.3945	13511260.0
2004-04-12 11:00:00	AMZN	Stock	2.3945	2.4085	2.39	2.408	9767020.0
2004-04-12 12:00:00	AMZN	Stock	2.4075	2.4185	2.4	2.4055	10082020.0
2004-04-12 13:00:00	AMZN	Stock	2.405	2.4095	2.392	2.396	6169780.0
2004-04-12 14:00:00	AMZN	Stock	2.396	2.402	2.3855	2.387	6811420.0
2004-04-12 15:00:00	AMZN	Stock	2.387	2.4005	2.384	2.3955	8614980.0
2004-04-12 16:00:00	AMZN	Stock	2.3955	2.398	2.395	2.3955	272660.0
2004-04-12 17:00:00	AMZN	Stock	2.398	2.398	2.395	2.3975	114740.0
2004-04-12 18:00:00	AMZN	Stock	2.397	2.397	2.397	2.397	20000.0
2004-04-12 09:00:00	CL	Stock	27.15	27.175	27.05	27.075	392600.0
2004-04-12 10:00:00	CL	Stock	27.075	27.115	27.04	27.06	465000.0
2004-04-12 11:00:00	CL	Stock	27.055	27.055	26.96	26.99	365600.0
2004-04-12 12:00:00	CL	Stock	26.995	27.0	26.93	26.965	252000.0
2004-04-12 13:00:00	CL	Stock	26.96	27.0	26.935	26.995	147600.0
2004-04-12 14:00:00	CL	Stock	26.995	27.025	26.98	27.0	416000.0
2004-04-12 15:00:00	CL	Stock	27.01	27.025	26.975	26.99	568800.0
2004-04-12 16:00:00	CL	Stock	26.99	26.99	26.99	26.99	11200.0

> showing 50 of 22,979 rows — these rows as CSV

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