PREVIEW / stock_1hour / 2001-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-19.parquet
  size:    318 KB
  rows:    16,317
  symbols: 1,261

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
2001-01-19 08:00:00	AAPL	Stock	0.3482	0.3571	0.3415	0.3504	5409600.0
2001-01-19 09:00:00	AAPL	Stock	0.3504	0.3516	0.3359	0.3404	138689600.0
2001-01-19 10:00:00	AAPL	Stock	0.3404	0.3415	0.3337	0.3371	122119200.0
2001-01-19 11:00:00	AAPL	Stock	0.3371	0.3415	0.3348	0.3393	81155200.0
2001-01-19 12:00:00	AAPL	Stock	0.3393	0.346	0.3382	0.3438	51637600.0
2001-01-19 13:00:00	AAPL	Stock	0.3449	0.3482	0.3438	0.346	67384800.0
2001-01-19 14:00:00	AAPL	Stock	0.346	0.3482	0.3415	0.3415	49123200.0
2001-01-19 15:00:00	AAPL	Stock	0.3415	0.3493	0.3382	0.3471	153552000.0
2001-01-19 16:00:00	AAPL	Stock	0.3471	0.3482	0.3337	0.3482	10164000.0
2001-01-19 17:00:00	AAPL	Stock	0.3438	0.3482	0.3415	0.3482	117600.0
2001-01-19 18:00:00	AAPL	Stock	0.3449	0.346	0.3449	0.346	22400.0
2001-01-19 08:00:00	MSFT	Stock	29.75	30.0625	29.25	30.0	3956000.0
2001-01-19 09:00:00	MSFT	Stock	30.0	30.125	27.9688	29.875	39672600.0
2001-01-19 10:00:00	MSFT	Stock	29.875	30.0938	29.4375	29.8125	32268400.0
2001-01-19 11:00:00	MSFT	Stock	29.8125	30.0	29.75	29.9688	16980200.0
2001-01-19 12:00:00	MSFT	Stock	29.9688	30.0312	29.8438	29.9688	12677400.0
2001-01-19 13:00:00	MSFT	Stock	29.9688	30.25	29.9688	30.2031	15404200.0
2001-01-19 14:00:00	MSFT	Stock	30.2188	30.7188	30.1875	30.4375	26752200.0
2001-01-19 15:00:00	MSFT	Stock	30.4688	30.625	30.2188	30.5	31697200.0
2001-01-19 16:00:00	MSFT	Stock	30.5	30.625	29.875	30.5625	5243400.0
2001-01-19 17:00:00	MSFT	Stock	30.5938	30.5938	30.5312	30.5625	398400.0
2001-01-19 18:00:00	MSFT	Stock	30.5312	30.5938	30.4375	30.5938	13400.0
2001-01-19 08:00:00	NVDA	Stock	0.2276	0.2292	0.2251	0.2286	528000.0
2001-01-19 09:00:00	NVDA	Stock	0.2281	0.2333	0.2188	0.2219	69408000.0
2001-01-19 10:00:00	NVDA	Stock	0.2219	0.2292	0.2135	0.2284	172248000.0
2001-01-19 11:00:00	NVDA	Stock	0.2285	0.2346	0.2271	0.2333	99288000.0
2001-01-19 12:00:00	NVDA	Stock	0.2346	0.2375	0.2297	0.2328	148896000.0
2001-01-19 13:00:00	NVDA	Stock	0.2328	0.2354	0.2315	0.2333	136272000.0
2001-01-19 14:00:00	NVDA	Stock	0.2333	0.2344	0.2266	0.2276	95976000.0
2001-01-19 15:00:00	NVDA	Stock	0.2271	0.2276	0.2146	0.2174	150744000.0
2001-01-19 16:00:00	NVDA	Stock	0.2186	0.2188	0.2125	0.2172	38160000.0
2001-01-19 17:00:00	NVDA	Stock	0.213	0.2167	0.213	0.2167	48000.0
2001-01-19 08:00:00	AMZN	Stock	1.025	1.075	1.0156	1.0188	694000.0
2001-01-19 09:00:00	AMZN	Stock	1.0188	1.025	0.9625	0.9625	17790000.0
2001-01-19 10:00:00	AMZN	Stock	0.9719	0.9719	0.9344	0.9469	15654000.0
2001-01-19 11:00:00	AMZN	Stock	0.9516	0.9594	0.9406	0.9531	11126000.0
2001-01-19 12:00:00	AMZN	Stock	0.95	0.9625	0.9438	0.9594	7602000.0
2001-01-19 13:00:00	AMZN	Stock	0.9594	0.9781	0.95	0.9625	9504000.0
2001-01-19 14:00:00	AMZN	Stock	0.9625	0.9938	0.9594	0.9781	13502000.0
2001-01-19 15:00:00	AMZN	Stock	0.9781	1.0	0.9672	0.9938	21328000.0
2001-01-19 16:00:00	AMZN	Stock	0.9969	0.9969	0.9812	0.9953	3156000.0
2001-01-19 17:00:00	AMZN	Stock	0.9938	1.0	0.9938	0.9969	2872000.0
2001-01-19 18:00:00	AMZN	Stock	0.9953	0.9969	0.9953	0.9969	36000.0
2001-01-19 09:00:00	CL	Stock	28.44	28.5	28.125	28.135	643400.0
2001-01-19 10:00:00	CL	Stock	28.13	28.175	27.75	27.95	413400.0
2001-01-19 11:00:00	CL	Stock	27.96	28.225	27.925	28.21	254400.0
2001-01-19 12:00:00	CL	Stock	28.195	28.425	28.1	28.405	273800.0
2001-01-19 13:00:00	CL	Stock	28.4	28.61	28.285	28.6	209200.0
2001-01-19 14:00:00	CL	Stock	28.605	28.7	28.275	28.7	426000.0
2001-01-19 15:00:00	CL	Stock	28.7	28.7	28.3	28.335	351400.0

> showing 50 of 16,317 rows — these rows as CSV

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