PREVIEW / stock_1hour / 2004-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-19.parquet
  size:    500 KB
  rows:    24,188
  symbols: 1,759

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-19 08:00:00	AAPL	Stock	0.5213	0.5213	0.5207	0.5207	84000.0
2004-04-19 09:00:00	AAPL	Stock	0.5179	0.5179	0.4998	0.5089	140355208.0
2004-04-19 10:00:00	AAPL	Stock	0.5089	0.5089	0.502	0.5057	100575384.0
2004-04-19 11:00:00	AAPL	Stock	0.5059	0.5079	0.5036	0.5057	64497440.0
2004-04-19 12:00:00	AAPL	Stock	0.5059	0.5079	0.4996	0.5	95592168.0
2004-04-19 13:00:00	AAPL	Stock	0.5004	0.5021	0.497	0.5007	72862272.0
2004-04-19 14:00:00	AAPL	Stock	0.5007	0.5016	0.4986	0.5009	66109568.0
2004-04-19 15:00:00	AAPL	Stock	0.5009	0.5063	0.5005	0.5057	122491824.0
2004-04-19 16:00:00	AAPL	Stock	0.5057	0.5077	0.5055	0.506	12161856.0
2004-04-19 17:00:00	AAPL	Stock	0.5063	0.5071	0.5061	0.5071	3924144.0
2004-04-19 08:00:00	MSFT	Stock	25.16	25.29	25.1	25.13	75740.0
2004-04-19 09:00:00	MSFT	Stock	25.13	25.19	24.5	25.16	4277860.0
2004-04-19 10:00:00	MSFT	Stock	25.16	25.36	25.14	25.28	6651806.0
2004-04-19 11:00:00	MSFT	Stock	25.28	25.49	25.26	25.48	7894707.0
2004-04-19 12:00:00	MSFT	Stock	25.48	25.56	25.38	25.41	6351246.0
2004-04-19 13:00:00	MSFT	Stock	25.4	25.45	25.32	25.4	4227828.0
2004-04-19 14:00:00	MSFT	Stock	25.4	25.49	25.34	25.47	3993225.0
2004-04-19 15:00:00	MSFT	Stock	25.47	25.56	25.42	25.53	8762456.0
2004-04-19 16:00:00	MSFT	Stock	25.54	25.6	25.42	25.57	773565.0
2004-04-19 17:00:00	MSFT	Stock	25.58	25.58	25.52	25.53	504260.0
2004-04-19 18:00:00	MSFT	Stock	25.55	25.55	25.55	25.55	200.0
2004-04-19 08:00:00	NVDA	Stock	0.1967	0.1967	0.1967	0.1967	12000.0
2004-04-19 09:00:00	NVDA	Stock	0.1975	0.1983	0.193	0.1948	70807680.0
2004-04-19 10:00:00	NVDA	Stock	0.1948	0.1964	0.1942	0.1962	59608320.0
2004-04-19 11:00:00	NVDA	Stock	0.1962	0.1979	0.1962	0.1971	66252840.0
2004-04-19 12:00:00	NVDA	Stock	0.1971	0.1972	0.1962	0.1963	38385360.0
2004-04-19 13:00:00	NVDA	Stock	0.1963	0.1971	0.1949	0.1952	28450800.0
2004-04-19 14:00:00	NVDA	Stock	0.1952	0.1961	0.1947	0.1955	66052920.0
2004-04-19 15:00:00	NVDA	Stock	0.1956	0.1971	0.1955	0.1965	168916080.0
2004-04-19 16:00:00	NVDA	Stock	0.1965	0.1965	0.1958	0.1965	13834800.0
2004-04-19 17:00:00	NVDA	Stock	0.1965	0.1965	0.1964	0.1964	2865360.0
2004-04-19 08:00:00	AMZN	Stock	2.285	2.285	2.273	2.275	60000.0
2004-04-19 09:00:00	AMZN	Stock	2.273	2.2775	2.256	2.27	13159960.0
2004-04-19 10:00:00	AMZN	Stock	2.27	2.2935	2.259	2.285	15974460.0
2004-04-19 11:00:00	AMZN	Stock	2.285	2.3015	2.2775	2.299	13279500.0
2004-04-19 12:00:00	AMZN	Stock	2.3	2.322	2.298	2.311	11256600.0
2004-04-19 13:00:00	AMZN	Stock	2.311	2.3165	2.305	2.314	5814060.0
2004-04-19 14:00:00	AMZN	Stock	2.313	2.339	2.3065	2.3355	12221840.0
2004-04-19 15:00:00	AMZN	Stock	2.335	2.3635	2.335	2.3505	27393060.0
2004-04-19 16:00:00	AMZN	Stock	2.3515	2.3565	2.3	2.35	2264980.0
2004-04-19 17:00:00	AMZN	Stock	2.353	2.3555	2.35	2.35	1026660.0
2004-04-19 09:00:00	CL	Stock	28.0	28.145	27.975	28.1	478400.0
2004-04-19 10:00:00	CL	Stock	28.095	28.145	27.91	28.085	798600.0
2004-04-19 11:00:00	CL	Stock	28.095	28.145	28.085	28.115	614800.0
2004-04-19 12:00:00	CL	Stock	28.12	28.13	27.98	28.015	368800.0
2004-04-19 13:00:00	CL	Stock	28.015	28.05	27.895	27.94	447600.0
2004-04-19 14:00:00	CL	Stock	27.94	28.075	27.9	28.025	491200.0
2004-04-19 15:00:00	CL	Stock	28.025	28.175	28.02	28.13	907400.0
2004-04-19 16:00:00	CL	Stock	28.155	28.155	28.155	28.155	1000.0

> showing 49 of 24,188 rows — these rows as CSV

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