PREVIEW / stock_1hour / 2003-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-05-19.parquet
  size:    429 KB
  rows:    20,905
  symbols: 1,565

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
2003-05-19 08:00:00	AAPL	Stock	0.3348	0.3348	0.3313	0.3321	330400.0
2003-05-19 09:00:00	AAPL	Stock	0.333	0.3366	0.3289	0.3296	46502960.0
2003-05-19 10:00:00	AAPL	Stock	0.3298	0.3305	0.3266	0.3282	72952824.0
2003-05-19 11:00:00	AAPL	Stock	0.328	0.3289	0.3239	0.3239	51633904.0
2003-05-19 12:00:00	AAPL	Stock	0.3239	0.3259	0.3225	0.3248	48310528.0
2003-05-19 13:00:00	AAPL	Stock	0.3248	0.327	0.3248	0.3254	29035832.0
2003-05-19 14:00:00	AAPL	Stock	0.3252	0.3275	0.3245	0.3264	35922376.0
2003-05-19 15:00:00	AAPL	Stock	0.3266	0.3273	0.3236	0.3239	72074128.0
2003-05-19 16:00:00	AAPL	Stock	0.3239	0.3284	0.323	0.3241	8870512.0
2003-05-19 18:00:00	AAPL	Stock	0.3236	0.3236	0.3236	0.3236	33600.0
2003-05-19 08:00:00	MSFT	Stock	25.4	25.45	25.25	25.331	49181.0
2003-05-19 09:00:00	MSFT	Stock	25.349	25.54	25.32	25.361	5928737.0
2003-05-19 10:00:00	MSFT	Stock	25.36	25.43	25.102	25.18	9033681.0
2003-05-19 11:00:00	MSFT	Stock	25.18	25.2	25.08	25.11	4545239.0
2003-05-19 12:00:00	MSFT	Stock	25.1	25.18	25.03	25.16	3826737.0
2003-05-19 13:00:00	MSFT	Stock	25.162	25.2	25.04	25.0831	3418451.0
2003-05-19 14:00:00	MSFT	Stock	25.08	25.1	24.999	25.02	5238651.0
2003-05-19 15:00:00	MSFT	Stock	25.02	25.05	24.74	24.76	9650173.0
2003-05-19 16:00:00	MSFT	Stock	24.75	25.02	24.69	24.74	950401.0
2003-05-19 17:00:00	MSFT	Stock	24.73	24.76	24.7	24.73	62100.0
2003-05-19 18:00:00	MSFT	Stock	24.72	24.81	24.71	24.75	16550.0
2003-05-19 08:00:00	NVDA	Stock	0.1729	0.1747	0.1725	0.1738	2385120.0
2003-05-19 09:00:00	NVDA	Stock	0.1738	0.1784	0.1735	0.1752	127536720.0
2003-05-19 10:00:00	NVDA	Stock	0.1752	0.1757	0.173	0.1738	155549400.0
2003-05-19 11:00:00	NVDA	Stock	0.1738	0.1738	0.1697	0.1697	173580720.0
2003-05-19 12:00:00	NVDA	Stock	0.1698	0.1702	0.1667	0.1677	190484760.0
2003-05-19 13:00:00	NVDA	Stock	0.1677	0.1687	0.1668	0.167	80080560.0
2003-05-19 14:00:00	NVDA	Stock	0.167	0.1681	0.1664	0.1679	109759200.0
2003-05-19 15:00:00	NVDA	Stock	0.1679	0.168	0.1651	0.1657	163871040.0
2003-05-19 16:00:00	NVDA	Stock	0.1657	0.1672	0.1651	0.1662	6073920.0
2003-05-19 17:00:00	NVDA	Stock	0.166	0.166	0.1657	0.1658	132000.0
2003-05-19 18:00:00	NVDA	Stock	0.1658	0.1658	0.1658	0.1658	12000.0
2003-05-19 08:00:00	AMZN	Stock	1.6265	1.64	1.6265	1.6345	213700.0
2003-05-19 09:00:00	AMZN	Stock	1.634	1.6555	1.6325	1.644	17666180.0
2003-05-19 10:00:00	AMZN	Stock	1.6438	1.645	1.6205	1.623	32526320.0
2003-05-19 11:00:00	AMZN	Stock	1.6235	1.624	1.607	1.608	20469340.0
2003-05-19 12:00:00	AMZN	Stock	1.608	1.6093	1.595	1.5994	22615040.0
2003-05-19 13:00:00	AMZN	Stock	1.5995	1.5995	1.5875	1.589	17343280.0
2003-05-19 14:00:00	AMZN	Stock	1.5885	1.593	1.5795	1.5895	14957560.0
2003-05-19 15:00:00	AMZN	Stock	1.5895	1.593	1.57	1.5785	33965480.0
2003-05-19 16:00:00	AMZN	Stock	1.578	1.581	1.5365	1.578	1314000.0
2003-05-19 17:00:00	AMZN	Stock	1.576	1.58	1.5755	1.58	162000.0
2003-05-19 18:00:00	AMZN	Stock	1.5805	1.5805	1.5805	1.5805	24000.0
2003-05-19 09:00:00	CL	Stock	29.285	29.285	29.135	29.155	265200.0
2003-05-19 10:00:00	CL	Stock	29.15	29.225	29.045	29.095	422400.0
2003-05-19 11:00:00	CL	Stock	29.095	29.105	29.0	29.01	403400.0
2003-05-19 12:00:00	CL	Stock	29.01	29.075	28.99	29.07	203000.0
2003-05-19 13:00:00	CL	Stock	29.07	29.105	29.05	29.08	228200.0
2003-05-19 14:00:00	CL	Stock	29.075	29.2	29.055	29.165	456600.0
2003-05-19 15:00:00	CL	Stock	29.16	29.27	29.15	29.245	668200.0

> showing 50 of 20,905 rows — these rows as CSV

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