PREVIEW / stock_1hour / 2000-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-10.parquet
  size:    278 KB
  rows:    14,375
  symbols: 1,174

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-10 09:00:00	AAPL	Stock	0.9291	0.9353	0.9063	0.9129	85276800.0
2000-05-10 10:00:00	AAPL	Stock	0.9129	0.9146	0.8934	0.8951	98918400.0
2000-05-10 11:00:00	AAPL	Stock	0.8951	0.9007	0.8873	0.8973	70537600.0
2000-05-10 12:00:00	AAPL	Stock	0.8984	0.9107	0.8956	0.904	30811200.0
2000-05-10 13:00:00	AAPL	Stock	0.904	0.9152	0.899	0.9102	40320000.0
2000-05-10 14:00:00	AAPL	Stock	0.9096	0.9241	0.9068	0.9241	85265600.0
2000-05-10 15:00:00	AAPL	Stock	0.9235	0.9375	0.8817	0.8862	103488000.0
2000-05-10 16:00:00	AAPL	Stock	0.8862	0.8867	0.8862	0.8867	560000.0
2000-05-10 09:00:00	MSFT	Stock	33.875	33.9375	33.5625	33.6562	6920000.0
2000-05-10 10:00:00	MSFT	Stock	33.6406	33.7188	33.25	33.5312	11643200.0
2000-05-10 11:00:00	MSFT	Stock	33.5312	33.7812	33.125	33.125	8895800.0
2000-05-10 12:00:00	MSFT	Stock	33.1875	33.25	33.0	33.0938	7533800.0
2000-05-10 13:00:00	MSFT	Stock	33.0938	33.4375	32.9375	33.3438	9318000.0
2000-05-10 14:00:00	MSFT	Stock	33.375	33.5	33.1875	33.3438	9408800.0
2000-05-10 15:00:00	MSFT	Stock	33.3125	33.4375	32.875	33.125	10357000.0
2000-05-10 16:00:00	MSFT	Stock	33.0938	33.0938	33.0625	33.0938	83400.0
2000-05-10 09:00:00	NVDA	Stock	0.1805	0.1806	0.175	0.1771	32112000.0
2000-05-10 10:00:00	NVDA	Stock	0.1771	0.1771	0.1689	0.1704	49440000.0
2000-05-10 11:00:00	NVDA	Stock	0.1703	0.1708	0.1668	0.1677	35760000.0
2000-05-10 12:00:00	NVDA	Stock	0.1677	0.1689	0.1647	0.1661	64128000.0
2000-05-10 13:00:00	NVDA	Stock	0.1661	0.1706	0.1659	0.1686	18816000.0
2000-05-10 14:00:00	NVDA	Stock	0.1686	0.1714	0.1674	0.1714	18624000.0
2000-05-10 15:00:00	NVDA	Stock	0.1719	0.1754	0.1628	0.1645	52656000.0
2000-05-10 16:00:00	NVDA	Stock	0.1643	0.1643	0.1643	0.1643	240000.0
2000-05-10 09:00:00	AMZN	Stock	2.7266	2.7688	2.6938	2.7063	12852000.0
2000-05-10 10:00:00	AMZN	Stock	2.7063	2.7125	2.5844	2.6	25176000.0
2000-05-10 11:00:00	AMZN	Stock	2.6	2.6438	2.5625	2.575	13708000.0
2000-05-10 12:00:00	AMZN	Stock	2.5781	2.6	2.5469	2.55	14898000.0
2000-05-10 13:00:00	AMZN	Stock	2.55	2.6	2.45	2.5875	38346000.0
2000-05-10 14:00:00	AMZN	Stock	2.5875	2.6938	2.5688	2.6875	35778000.0
2000-05-10 15:00:00	AMZN	Stock	2.6938	2.7625	2.6312	2.6625	30570000.0
2000-05-10 16:00:00	AMZN	Stock	2.6656	2.6719	2.6625	2.6656	236000.0
2000-05-10 09:00:00	CL	Stock	29.125	29.5	29.0938	29.4062	592200.0
2000-05-10 10:00:00	CL	Stock	29.4062	29.6562	29.125	29.625	658800.0
2000-05-10 11:00:00	CL	Stock	29.6562	29.6875	29.4062	29.5938	523400.0
2000-05-10 12:00:00	CL	Stock	29.6562	29.75	29.5625	29.6875	204000.0
2000-05-10 13:00:00	CL	Stock	29.6562	29.7188	29.4688	29.7188	277000.0
2000-05-10 14:00:00	CL	Stock	29.7188	29.8438	29.6562	29.8125	410200.0
2000-05-10 15:00:00	CL	Stock	29.7812	29.875	29.0	29.1875	1058200.0
2000-05-10 16:00:00	CL	Stock	29.1875	29.1875	29.0938	29.0938	50000.0

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

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