PREVIEW / stock_1hour / 2005-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-06.parquet
  size:    537 KB
  rows:    25,607
  symbols: 1,973

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
2005-05-06 08:00:00	AAPL	Stock	1.3054	1.3196	1.3054	1.3179	2730112.0
2005-05-06 09:00:00	AAPL	Stock	1.3175	1.3268	1.3146	1.3179	55599544.0
2005-05-06 10:00:00	AAPL	Stock	1.3182	1.3268	1.3139	1.3229	68245464.0
2005-05-06 11:00:00	AAPL	Stock	1.3232	1.3246	1.3179	1.3196	35347900.0
2005-05-06 12:00:00	AAPL	Stock	1.3193	1.3207	1.3154	1.3193	27227900.0
2005-05-06 13:00:00	AAPL	Stock	1.3193	1.3246	1.3193	1.3243	22327368.0
2005-05-06 14:00:00	AAPL	Stock	1.3246	1.3289	1.3232	1.3279	45617908.0
2005-05-06 15:00:00	AAPL	Stock	1.3275	1.3332	1.3239	1.3304	61323220.0
2005-05-06 16:00:00	AAPL	Stock	1.3279	1.3321	1.3271	1.3296	1223348.0
2005-05-06 17:00:00	AAPL	Stock	1.3289	1.33	1.3286	1.3286	248864.0
2005-05-06 18:00:00	AAPL	Stock	1.33	1.3318	1.33	1.3314	83776.0
2005-05-06 08:00:00	MSFT	Stock	25.23	25.35	25.23	25.32	39168.0
2005-05-06 09:00:00	MSFT	Stock	25.31	25.37	25.19	25.23	10755659.0
2005-05-06 10:00:00	MSFT	Stock	25.23	25.47	25.22	25.47	15052224.0
2005-05-06 11:00:00	MSFT	Stock	25.46	25.48	25.32	25.33	8768835.0
2005-05-06 12:00:00	MSFT	Stock	25.34	25.373	25.28	25.34	7862751.0
2005-05-06 13:00:00	MSFT	Stock	25.35	25.4	25.3	25.338	4645804.0
2005-05-06 14:00:00	MSFT	Stock	25.33	25.36	25.31	25.32	5315357.0
2005-05-06 15:00:00	MSFT	Stock	25.32	25.35	25.2	25.23	10442971.0
2005-05-06 16:00:00	MSFT	Stock	25.22	25.345	25.19	25.2	567008.0
2005-05-06 17:00:00	MSFT	Stock	25.21	25.235	25.2	25.23	13950.0
2005-05-06 08:00:00	NVDA	Stock	0.1921	0.1925	0.1921	0.1925	308400.0
2005-05-06 09:00:00	NVDA	Stock	0.1926	0.193	0.1897	0.1903	68071440.0
2005-05-06 10:00:00	NVDA	Stock	0.1903	0.1906	0.1883	0.1894	53232840.0
2005-05-06 11:00:00	NVDA	Stock	0.1894	0.1905	0.1891	0.19	40430640.0
2005-05-06 12:00:00	NVDA	Stock	0.19	0.1912	0.1895	0.1912	21656880.0
2005-05-06 13:00:00	NVDA	Stock	0.1912	0.1924	0.1912	0.1921	33261960.0
2005-05-06 14:00:00	NVDA	Stock	0.1921	0.1931	0.192	0.1929	36600240.0
2005-05-06 15:00:00	NVDA	Stock	0.1929	0.1932	0.1924	0.1929	73576320.0
2005-05-06 16:00:00	NVDA	Stock	0.1931	0.1936	0.1929	0.1931	14165880.0
2005-05-06 17:00:00	NVDA	Stock	0.1931	0.1931	0.1929	0.1929	246840.0
2005-05-06 18:00:00	NVDA	Stock	0.1931	0.1931	0.1931	0.1931	60000.0
2005-05-06 08:00:00	AMZN	Stock	1.702	1.715	1.7	1.7145	128000.0
2005-05-06 09:00:00	AMZN	Stock	1.716	1.727	1.7095	1.7265	19653200.0
2005-05-06 10:00:00	AMZN	Stock	1.726	1.7345	1.72	1.7285	30800540.0
2005-05-06 11:00:00	AMZN	Stock	1.7285	1.732	1.726	1.7301	12663140.0
2005-05-06 12:00:00	AMZN	Stock	1.73	1.7305	1.7225	1.7245	21853600.0
2005-05-06 13:00:00	AMZN	Stock	1.725	1.727	1.7125	1.7125	9743260.0
2005-05-06 14:00:00	AMZN	Stock	1.7125	1.7175	1.707	1.7135	12036400.0
2005-05-06 15:00:00	AMZN	Stock	1.7134	1.73	1.7125	1.726	24716620.0
2005-05-06 16:00:00	AMZN	Stock	1.726	1.729	1.7245	1.726	832240.0
2005-05-06 17:00:00	AMZN	Stock	1.726	1.726	1.7225	1.726	245280.0
2005-05-06 18:00:00	AMZN	Stock	1.726	1.726	1.726	1.726	20000.0
2005-05-06 09:00:00	CL	Stock	24.885	24.895	24.77	24.845	318200.0
2005-05-06 10:00:00	CL	Stock	24.85	24.85	24.595	24.7	672800.0
2005-05-06 11:00:00	CL	Stock	24.705	24.725	24.585	24.6	672200.0
2005-05-06 12:00:00	CL	Stock	24.6	24.61	24.465	24.565	537600.0
2005-05-06 13:00:00	CL	Stock	24.57	24.67	24.565	24.615	624000.0
2005-05-06 14:00:00	CL	Stock	24.61	24.705	24.6	24.65	295800.0
2005-05-06 15:00:00	CL	Stock	24.655	24.675	24.565	24.59	974800.0

> showing 50 of 25,607 rows — these rows as CSV

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