PREVIEW / stock_1hour / 2000-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-24.parquet
  size:    275 KB
  rows:    14,320
  symbols: 1,160

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-04-24 09:00:00	AAPL	Stock	1.0268	1.048	1.0246	1.0346	69787200.0
2000-04-24 10:00:00	AAPL	Stock	1.0346	1.0424	1.0279	1.0391	82723200.0
2000-04-24 11:00:00	AAPL	Stock	1.0399	1.0469	1.0346	1.0452	52236800.0
2000-04-24 12:00:00	AAPL	Stock	1.0458	1.0511	1.0357	1.0485	40745600.0
2000-04-24 13:00:00	AAPL	Stock	1.0469	1.0625	1.0446	1.0491	55641600.0
2000-04-24 14:00:00	AAPL	Stock	1.0497	1.0525	1.0419	1.0455	38124800.0
2000-04-24 15:00:00	AAPL	Stock	1.0452	1.0759	1.0335	1.0756	80640000.0
2000-04-24 16:00:00	AAPL	Stock	1.0759	1.0759	1.0753	1.0759	1848000.0
2000-04-24 09:00:00	MSFT	Stock	33.625	33.9375	33.25	33.5938	49653600.0
2000-04-24 10:00:00	MSFT	Stock	33.5938	33.6562	32.5	32.9375	61101400.0
2000-04-24 11:00:00	MSFT	Stock	32.9375	33.125	32.75	32.9688	34831600.0
2000-04-24 12:00:00	MSFT	Stock	32.9688	33.125	32.9062	33.125	27619600.0
2000-04-24 13:00:00	MSFT	Stock	33.125	33.2812	32.9375	33.0312	24485000.0
2000-04-24 14:00:00	MSFT	Stock	33.0312	33.2812	32.75	33.1875	24749600.0
2000-04-24 15:00:00	MSFT	Stock	33.2188	33.375	32.9375	33.3125	43839800.0
2000-04-24 16:00:00	MSFT	Stock	33.3438	33.4062	33.3125	33.3125	260600.0
2000-04-24 09:00:00	NVDA	Stock	0.1583	0.163	0.1557	0.1589	34608000.0
2000-04-24 10:00:00	NVDA	Stock	0.1599	0.1607	0.1552	0.1594	31968000.0
2000-04-24 11:00:00	NVDA	Stock	0.1607	0.1654	0.1583	0.1617	35088000.0
2000-04-24 12:00:00	NVDA	Stock	0.1624	0.1643	0.1604	0.1604	15984000.0
2000-04-24 13:00:00	NVDA	Stock	0.1612	0.1612	0.1576	0.1591	8592000.0
2000-04-24 14:00:00	NVDA	Stock	0.1581	0.1594	0.1557	0.1562	26256000.0
2000-04-24 15:00:00	NVDA	Stock	0.1557	0.1596	0.1513	0.1586	35520000.0
2000-04-24 16:00:00	NVDA	Stock	0.1596	0.1596	0.1596	0.1596	6720000.0
2000-04-24 09:00:00	AMZN	Stock	2.4688	2.5781	2.4281	2.5344	12174000.0
2000-04-24 10:00:00	AMZN	Stock	2.5344	2.575	2.2438	2.3594	39502000.0
2000-04-24 11:00:00	AMZN	Stock	2.3656	2.375	2.2875	2.35	16700000.0
2000-04-24 12:00:00	AMZN	Stock	2.35	2.4578	2.3375	2.4188	13276000.0
2000-04-24 13:00:00	AMZN	Stock	2.4188	2.4313	2.3438	2.3562	10690000.0
2000-04-24 14:00:00	AMZN	Stock	2.3562	2.375	2.3062	2.3438	10252000.0
2000-04-24 15:00:00	AMZN	Stock	2.3438	2.4938	2.3125	2.4938	21886000.0
2000-04-24 16:00:00	AMZN	Stock	2.4906	2.4969	2.4906	2.4906	464000.0
2000-04-24 09:00:00	CL	Stock	28.4688	29.0	28.375	28.9375	400400.0
2000-04-24 10:00:00	CL	Stock	28.9688	29.125	28.75	29.0938	901200.0
2000-04-24 11:00:00	CL	Stock	29.0938	29.25	28.9375	29.2188	550800.0
2000-04-24 12:00:00	CL	Stock	29.1875	29.375	29.0312	29.1562	430400.0
2000-04-24 13:00:00	CL	Stock	29.1875	29.1875	29.0	29.0	230600.0
2000-04-24 14:00:00	CL	Stock	28.9688	29.3438	28.9375	29.2188	557400.0
2000-04-24 15:00:00	CL	Stock	29.25	29.375	29.125	29.375	743000.0
2000-04-24 16:00:00	CL	Stock	29.3125	29.3438	29.3125	29.3125	116600.0

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

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