PREVIEW / stock_1hour / 2000-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-20.parquet
  size:    273 KB
  rows:    14,259
  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-20 09:00:00	AAPL	Stock	1.1044	1.1138	1.0647	1.0692	201409600.0
2000-04-20 10:00:00	AAPL	Stock	1.0692	1.0826	1.0513	1.0703	140347200.0
2000-04-20 11:00:00	AAPL	Stock	1.0703	1.0709	1.0474	1.048	81816000.0
2000-04-20 12:00:00	AAPL	Stock	1.0469	1.0647	1.0463	1.0564	60894400.0
2000-04-20 13:00:00	AAPL	Stock	1.058	1.067	1.0541	1.0625	37934400.0
2000-04-20 14:00:00	AAPL	Stock	1.0625	1.0714	1.0513	1.0647	33331200.0
2000-04-20 15:00:00	AAPL	Stock	1.0647	1.0675	1.0536	1.0619	72228800.0
2000-04-20 16:00:00	AAPL	Stock	1.0619	1.0619	1.0603	1.0614	1176000.0
2000-04-20 09:00:00	MSFT	Stock	39.3125	39.9375	39.1562	39.3438	8474600.0
2000-04-20 10:00:00	MSFT	Stock	39.3438	39.625	39.0938	39.4062	8025000.0
2000-04-20 11:00:00	MSFT	Stock	39.4062	39.6562	39.125	39.125	4050000.0
2000-04-20 12:00:00	MSFT	Stock	39.125	39.25	38.75	38.9375	7166200.0
2000-04-20 13:00:00	MSFT	Stock	38.9688	39.4375	38.9375	39.375	3487200.0
2000-04-20 14:00:00	MSFT	Stock	39.3906	39.5625	39.0	39.3438	4051200.0
2000-04-20 15:00:00	MSFT	Stock	39.3438	39.5938	39.2188	39.5	7770000.0
2000-04-20 16:00:00	MSFT	Stock	39.5	39.5	39.4688	39.4688	208600.0
2000-04-20 09:00:00	NVDA	Stock	0.1734	0.1767	0.1719	0.1719	17712000.0
2000-04-20 10:00:00	NVDA	Stock	0.1719	0.1719	0.1667	0.1698	30000000.0
2000-04-20 11:00:00	NVDA	Stock	0.1693	0.1704	0.1677	0.1687	13200000.0
2000-04-20 12:00:00	NVDA	Stock	0.1677	0.1687	0.1674	0.1677	17760000.0
2000-04-20 13:00:00	NVDA	Stock	0.1676	0.1677	0.1656	0.1661	25584000.0
2000-04-20 14:00:00	NVDA	Stock	0.1667	0.1674	0.1656	0.1674	22992000.0
2000-04-20 15:00:00	NVDA	Stock	0.1667	0.1719	0.166	0.168	19584000.0
2000-04-20 16:00:00	NVDA	Stock	0.1668	0.168	0.1668	0.168	2352000.0
2000-04-20 09:00:00	AMZN	Stock	2.6688	2.6844	2.6094	2.6297	11346000.0
2000-04-20 10:00:00	AMZN	Stock	2.6312	2.6375	2.5563	2.5625	12752000.0
2000-04-20 11:00:00	AMZN	Stock	2.5625	2.6094	2.55	2.5656	8736000.0
2000-04-20 12:00:00	AMZN	Stock	2.5656	2.625	2.5031	2.575	13830000.0
2000-04-20 13:00:00	AMZN	Stock	2.5656	2.6	2.5156	2.5312	10340000.0
2000-04-20 14:00:00	AMZN	Stock	2.5312	2.5875	2.4938	2.5844	14302000.0
2000-04-20 15:00:00	AMZN	Stock	2.5875	2.6688	2.5813	2.6188	22398000.0
2000-04-20 16:00:00	AMZN	Stock	2.6188	2.6188	2.6156	2.6188	182000.0
2000-04-20 09:00:00	CL	Stock	27.625	27.625	27.3125	27.625	594200.0
2000-04-20 10:00:00	CL	Stock	27.5938	28.4062	27.5938	28.3438	554400.0
2000-04-20 11:00:00	CL	Stock	28.3438	28.6875	28.3438	28.4688	1130600.0
2000-04-20 12:00:00	CL	Stock	28.5	28.6562	28.4062	28.4375	635000.0
2000-04-20 13:00:00	CL	Stock	28.4062	28.6875	28.375	28.4062	512800.0
2000-04-20 14:00:00	CL	Stock	28.4375	28.4688	28.2812	28.375	290800.0
2000-04-20 15:00:00	CL	Stock	28.375	28.5625	28.375	28.5312	1580200.0
2000-04-20 16:00:00	CL	Stock	28.5625	28.5625	28.5312	28.5625	210400.0

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

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