PREVIEW / stock_1hour / 2004-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-09.parquet
  size:    512 KB
  rows:    23,849
  symbols: 1,712

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-09 08:00:00	AAPL	Stock	0.4205	0.4205	0.4136	0.4175	1135456.0
2004-01-09 09:00:00	AAPL	Stock	0.4161	0.4275	0.4136	0.4261	73272192.0
2004-01-09 10:00:00	AAPL	Stock	0.4261	0.4309	0.4234	0.4265	98335552.0
2004-01-09 11:00:00	AAPL	Stock	0.4266	0.4268	0.4214	0.4225	39429376.0
2004-01-09 12:00:00	AAPL	Stock	0.4225	0.4241	0.4196	0.4202	28130424.0
2004-01-09 13:00:00	AAPL	Stock	0.4205	0.4239	0.4189	0.4202	22552992.0
2004-01-09 14:00:00	AAPL	Stock	0.4205	0.422	0.407	0.408	69984432.0
2004-01-09 15:00:00	AAPL	Stock	0.408	0.4127	0.408	0.4104	73111304.0
2004-01-09 16:00:00	AAPL	Stock	0.4104	0.4121	0.4098	0.4121	1970752.0
2004-01-09 17:00:00	AAPL	Stock	0.4102	0.4127	0.4102	0.4127	1298752.0
2004-01-09 18:00:00	AAPL	Stock	0.4103	0.4125	0.4102	0.4102	454160.0
2004-01-09 08:00:00	MSFT	Stock	28.27	28.27	28.0	28.0	136615.0
2004-01-09 09:00:00	MSFT	Stock	28.01	28.05	27.82	27.9	9698067.0
2004-01-09 10:00:00	MSFT	Stock	27.9	27.99	27.73	27.86	12403524.0
2004-01-09 11:00:00	MSFT	Stock	27.86	27.9	27.77	27.83	7136123.0
2004-01-09 12:00:00	MSFT	Stock	27.82	27.83	27.75	27.8	6721708.0
2004-01-09 13:00:00	MSFT	Stock	27.8	27.9	27.79	27.88	5556955.0
2004-01-09 14:00:00	MSFT	Stock	27.8803	27.91	27.72	27.77	9380427.0
2004-01-09 15:00:00	MSFT	Stock	27.77	27.79	27.59	27.62	12902232.0
2004-01-09 16:00:00	MSFT	Stock	27.62	28.23	27.57	27.62	604066.0
2004-01-09 17:00:00	MSFT	Stock	27.63	27.68	27.6	27.68	664007.0
2004-01-09 18:00:00	MSFT	Stock	27.6385	27.68	27.63	27.66	59176.0
2004-01-09 08:00:00	NVDA	Stock	0.2083	0.2085	0.2075	0.2076	1872000.0
2004-01-09 09:00:00	NVDA	Stock	0.2076	0.2108	0.2062	0.2087	170571120.0
2004-01-09 10:00:00	NVDA	Stock	0.2087	0.2119	0.2083	0.2116	114227640.0
2004-01-09 11:00:00	NVDA	Stock	0.2115	0.2148	0.211	0.2148	113703960.0
2004-01-09 12:00:00	NVDA	Stock	0.2148	0.2148	0.2122	0.2122	77282760.0
2004-01-09 13:00:00	NVDA	Stock	0.2122	0.2126	0.2112	0.2119	39041400.0
2004-01-09 14:00:00	NVDA	Stock	0.212	0.2132	0.2111	0.2119	60427320.0
2004-01-09 15:00:00	NVDA	Stock	0.2118	0.213	0.2107	0.2128	166485120.0
2004-01-09 16:00:00	NVDA	Stock	0.2129	0.213	0.211	0.2124	4221240.0
2004-01-09 17:00:00	NVDA	Stock	0.2127	0.2127	0.2124	0.2127	2618280.0
2004-01-09 18:00:00	NVDA	Stock	0.2128	0.2128	0.2126	0.2127	379200.0
2004-01-09 08:00:00	AMZN	Stock	2.4625	2.49	2.4625	2.482	589820.0
2004-01-09 09:00:00	AMZN	Stock	2.48	2.4995	2.464	2.49	29530220.0
2004-01-09 10:00:00	AMZN	Stock	2.491	2.515	2.485	2.506	34158000.0
2004-01-09 11:00:00	AMZN	Stock	2.506	2.54	2.506	2.539	28613160.0
2004-01-09 12:00:00	AMZN	Stock	2.539	2.5575	2.5325	2.5525	22963660.0
2004-01-09 13:00:00	AMZN	Stock	2.5525	2.5675	2.548	2.565	20002680.0
2004-01-09 14:00:00	AMZN	Stock	2.565	2.578	2.555	2.577	31225020.0
2004-01-09 15:00:00	AMZN	Stock	2.5775	2.6075	2.5615	2.5785	82425120.0
2004-01-09 16:00:00	AMZN	Stock	2.5755	2.5895	2.575	2.5875	1501200.0
2004-01-09 17:00:00	AMZN	Stock	2.575	2.5895	2.575	2.5895	461400.0
2004-01-09 18:00:00	AMZN	Stock	2.5754	2.5875	2.5754	2.5875	67700.0
2004-01-09 09:00:00	CL	Stock	25.265	25.3	25.175	25.285	601200.0
2004-01-09 10:00:00	CL	Stock	25.285	25.41	25.27	25.405	766800.0
2004-01-09 11:00:00	CL	Stock	25.4	25.475	25.395	25.43	585400.0
2004-01-09 12:00:00	CL	Stock	25.42	25.445	25.26	25.31	1066400.0
2004-01-09 13:00:00	CL	Stock	25.305	25.37	25.25	25.255	1725600.0
2004-01-09 14:00:00	CL	Stock	25.25	25.3	25.215	25.265	923600.0

> showing 50 of 23,849 rows — these rows as CSV

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