PREVIEW / stock_1hour / 2000-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-09.parquet
  size:    282 KB
  rows:    14,493
  symbols: 1,167

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
2000-05-09 09:00:00	AAPL	Stock	0.9849	0.9933	0.9688	0.971	37676800.0
2000-05-09 10:00:00	AAPL	Stock	0.971	0.9721	0.9364	0.9481	98963200.0
2000-05-09 11:00:00	AAPL	Stock	0.9487	0.9548	0.942	0.9515	36769600.0
2000-05-09 12:00:00	AAPL	Stock	0.9503	0.9509	0.9448	0.9464	18659200.0
2000-05-09 13:00:00	AAPL	Stock	0.947	0.9515	0.9403	0.9459	22736000.0
2000-05-09 14:00:00	AAPL	Stock	0.9448	0.9565	0.9386	0.9554	53491200.0
2000-05-09 15:00:00	AAPL	Stock	0.9556	0.9581	0.9397	0.9414	43220800.0
2000-05-09 16:00:00	AAPL	Stock	0.9414	0.942	0.9414	0.9414	739200.0
2000-05-09 09:00:00	MSFT	Stock	35.0938	35.2188	34.9062	35.0	5871000.0
2000-05-09 10:00:00	MSFT	Stock	35.0	35.0	34.4375	34.625	7411200.0
2000-05-09 11:00:00	MSFT	Stock	34.625	34.7188	34.4062	34.6562	4319000.0
2000-05-09 12:00:00	MSFT	Stock	34.6875	34.6875	34.2812	34.3438	5005800.0
2000-05-09 13:00:00	MSFT	Stock	34.3438	34.375	33.875	33.9375	10428400.0
2000-05-09 14:00:00	MSFT	Stock	33.9688	34.2188	33.875	34.1562	7630000.0
2000-05-09 15:00:00	MSFT	Stock	34.125	34.1875	33.75	33.9375	17220600.0
2000-05-09 16:00:00	MSFT	Stock	33.9375	33.9375	33.9062	33.9062	155800.0
2000-05-09 09:00:00	NVDA	Stock	0.188	0.1896	0.1865	0.1866	18432000.0
2000-05-09 10:00:00	NVDA	Stock	0.1865	0.1866	0.1784	0.1793	47424000.0
2000-05-09 11:00:00	NVDA	Stock	0.1792	0.1826	0.1792	0.1823	16896000.0
2000-05-09 12:00:00	NVDA	Stock	0.1822	0.1828	0.1799	0.1809	10224000.0
2000-05-09 13:00:00	NVDA	Stock	0.1809	0.1828	0.1799	0.1805	22608000.0
2000-05-09 14:00:00	NVDA	Stock	0.1802	0.1833	0.1771	0.1828	31296000.0
2000-05-09 15:00:00	NVDA	Stock	0.1831	0.1849	0.1806	0.1823	17040000.0
2000-05-09 16:00:00	NVDA	Stock	0.1822	0.1823	0.1822	0.1823	1248000.0
2000-05-09 09:00:00	AMZN	Stock	2.825	2.8875	2.8188	2.8281	9688000.0
2000-05-09 10:00:00	AMZN	Stock	2.8313	2.8344	2.7281	2.7625	19802000.0
2000-05-09 11:00:00	AMZN	Stock	2.7625	2.7719	2.7	2.75	10138000.0
2000-05-09 12:00:00	AMZN	Stock	2.7531	2.7688	2.7094	2.7125	7058000.0
2000-05-09 13:00:00	AMZN	Stock	2.7156	2.7219	2.6688	2.6719	9432000.0
2000-05-09 14:00:00	AMZN	Stock	2.6719	2.7688	2.6688	2.7438	13842000.0
2000-05-09 15:00:00	AMZN	Stock	2.7469	2.85	2.7125	2.825	14846000.0
2000-05-09 16:00:00	AMZN	Stock	2.8063	2.825	2.8063	2.8125	156000.0
2000-05-09 09:00:00	CL	Stock	28.875	29.125	28.8438	29.0625	412200.0
2000-05-09 10:00:00	CL	Stock	29.125	29.7188	29.0938	29.4688	721600.0
2000-05-09 11:00:00	CL	Stock	29.4688	29.5	29.375	29.4688	507800.0
2000-05-09 12:00:00	CL	Stock	29.4062	29.5	29.375	29.375	214800.0
2000-05-09 13:00:00	CL	Stock	29.4062	29.4062	29.1875	29.2812	400400.0
2000-05-09 14:00:00	CL	Stock	29.2812	29.5312	29.1562	29.4688	461200.0
2000-05-09 15:00:00	CL	Stock	29.4062	29.5625	29.3438	29.5	579000.0
2000-05-09 16:00:00	CL	Stock	29.4688	29.5	29.4688	29.5	157600.0

> showing 40 of 14,493 rows — these rows as CSV

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