PREVIEW / stock_1hour / 2004-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-22.parquet
  size:    510 KB
  rows:    24,127
  symbols: 1,716

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-01-22 08:00:00	AAPL	Stock	0.4038	0.4039	0.4	0.4038	94472.0
2004-01-22 09:00:00	AAPL	Stock	0.4036	0.4077	0.4018	0.4045	22279264.0
2004-01-22 10:00:00	AAPL	Stock	0.4046	0.4048	0.3997	0.4004	44404080.0
2004-01-22 11:00:00	AAPL	Stock	0.4004	0.4009	0.3988	0.4005	20904016.0
2004-01-22 12:00:00	AAPL	Stock	0.4004	0.4034	0.4004	0.4014	13841968.0
2004-01-22 13:00:00	AAPL	Stock	0.4014	0.4016	0.3984	0.3993	17567200.0
2004-01-22 14:00:00	AAPL	Stock	0.3995	0.4009	0.3973	0.3979	20815872.0
2004-01-22 15:00:00	AAPL	Stock	0.3977	0.4005	0.3964	0.3964	53112192.0
2004-01-22 16:00:00	AAPL	Stock	0.3964	0.4002	0.3959	0.4002	2209592.0
2004-01-22 17:00:00	AAPL	Stock	0.3961	0.3961	0.3961	0.3961	83160.0
2004-01-22 08:00:00	MSFT	Stock	28.45	28.45	28.34	28.36	79910.0
2004-01-22 09:00:00	MSFT	Stock	28.36	28.44	28.219	28.3	7034871.0
2004-01-22 10:00:00	MSFT	Stock	28.31	28.33	28.14	28.17	9821845.0
2004-01-22 11:00:00	MSFT	Stock	28.17	28.2	28.019	28.14	9001398.0
2004-01-22 12:00:00	MSFT	Stock	28.132	28.2	28.09	28.13	5752089.0
2004-01-22 13:00:00	MSFT	Stock	28.13	28.13	27.98	28.01	6039737.0
2004-01-22 14:00:00	MSFT	Stock	28.01	28.11	27.98	28.0	7799389.0
2004-01-22 15:00:00	MSFT	Stock	28.0	28.28	27.98	28.01	18466095.0
2004-01-22 16:00:00	MSFT	Stock	28.01	28.7	27.14	27.59	9411360.0
2004-01-22 17:00:00	MSFT	Stock	27.6	28.04	27.16	27.55	2886843.0
2004-01-22 18:00:00	MSFT	Stock	27.56	27.88	27.54	27.8	768231.0
2004-01-22 08:00:00	NVDA	Stock	0.2021	0.2021	0.2017	0.2017	36000.0
2004-01-22 09:00:00	NVDA	Stock	0.2025	0.2058	0.2017	0.2037	52871160.0
2004-01-22 10:00:00	NVDA	Stock	0.2037	0.2056	0.2021	0.2022	134871000.0
2004-01-22 11:00:00	NVDA	Stock	0.2022	0.2022	0.1979	0.1984	106005120.0
2004-01-22 12:00:00	NVDA	Stock	0.1986	0.2013	0.1981	0.1986	47581200.0
2004-01-22 13:00:00	NVDA	Stock	0.1986	0.1988	0.1944	0.1953	118809240.0
2004-01-22 14:00:00	NVDA	Stock	0.1953	0.1964	0.1947	0.1958	53996040.0
2004-01-22 15:00:00	NVDA	Stock	0.1958	0.1981	0.1952	0.1971	80262360.0
2004-01-22 16:00:00	NVDA	Stock	0.1968	0.1992	0.1953	0.1988	3732720.0
2004-01-22 17:00:00	NVDA	Stock	0.1971	0.1971	0.1957	0.1958	711000.0
2004-01-22 18:00:00	NVDA	Stock	0.1958	0.1958	0.1956	0.1958	180000.0
2004-01-22 08:00:00	AMZN	Stock	2.8425	2.8475	2.833	2.8385	94000.0
2004-01-22 09:00:00	AMZN	Stock	2.8465	2.869	2.8275	2.8475	30487360.0
2004-01-22 10:00:00	AMZN	Stock	2.8475	2.8475	2.812	2.8285	29643140.0
2004-01-22 11:00:00	AMZN	Stock	2.8294	2.8565	2.8245	2.8465	26821580.0
2004-01-22 12:00:00	AMZN	Stock	2.8455	2.8685	2.8444	2.86	31300640.0
2004-01-22 13:00:00	AMZN	Stock	2.8595	2.8618	2.85	2.8595	15577840.0
2004-01-22 14:00:00	AMZN	Stock	2.859	2.875	2.8545	2.869	22303840.0
2004-01-22 15:00:00	AMZN	Stock	2.869	2.891	2.853	2.8575	35307800.0
2004-01-22 16:00:00	AMZN	Stock	2.856	2.8755	2.8476	2.8476	5554720.0
2004-01-22 17:00:00	AMZN	Stock	2.8565	2.86	2.8565	2.86	352240.0
2004-01-22 18:00:00	AMZN	Stock	2.86	2.86	2.858	2.858	6000.0
2004-01-22 08:00:00	CL	Stock	25.25	25.25	25.25	25.25	800.0
2004-01-22 09:00:00	CL	Stock	25.79	25.79	25.535	25.575	386400.0
2004-01-22 10:00:00	CL	Stock	25.58	25.615	25.51	25.535	501800.0
2004-01-22 11:00:00	CL	Stock	25.545	25.55	25.38	25.42	865400.0
2004-01-22 12:00:00	CL	Stock	25.42	25.505	25.41	25.49	463000.0
2004-01-22 13:00:00	CL	Stock	25.485	25.55	25.475	25.53	405600.0
2004-01-22 14:00:00	CL	Stock	25.53	25.6	25.505	25.555	467000.0

> showing 50 of 24,127 rows — these rows as CSV

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