PREVIEW / stock_1hour / 2000-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-18.parquet
  size:    272 KB
  rows:    14,109
  symbols: 1,158

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-18 09:00:00	AAPL	Stock	0.9196	0.9263	0.9107	0.9174	56481600.0
2000-05-18 10:00:00	AAPL	Stock	0.9174	0.9269	0.9102	0.9269	60043200.0
2000-05-18 11:00:00	AAPL	Stock	0.9269	0.9369	0.9146	0.9196	86665600.0
2000-05-18 12:00:00	AAPL	Stock	0.9185	0.9275	0.9185	0.9219	32872000.0
2000-05-18 13:00:00	AAPL	Stock	0.9208	0.9241	0.9191	0.9196	13608000.0
2000-05-18 14:00:00	AAPL	Stock	0.9196	0.9252	0.9157	0.918	28739200.0
2000-05-18 15:00:00	AAPL	Stock	0.9185	0.9196	0.8984	0.8996	74827200.0
2000-05-18 16:00:00	AAPL	Stock	0.8996	0.9007	0.8996	0.8996	940800.0
2000-05-18 09:00:00	MSFT	Stock	34.0312	34.0312	33.625	33.7656	5848800.0
2000-05-18 10:00:00	MSFT	Stock	33.7812	33.8125	33.5	33.7031	7559600.0
2000-05-18 11:00:00	MSFT	Stock	33.7031	33.75	33.2812	33.4062	6181000.0
2000-05-18 12:00:00	MSFT	Stock	33.375	33.4375	33.2188	33.3125	4948400.0
2000-05-18 13:00:00	MSFT	Stock	33.3438	33.375	33.125	33.1562	5683800.0
2000-05-18 14:00:00	MSFT	Stock	33.1562	33.3125	33.0938	33.0938	8140400.0
2000-05-18 15:00:00	MSFT	Stock	33.0938	33.1875	32.9375	33.125	13257200.0
2000-05-18 16:00:00	MSFT	Stock	33.1094	33.125	33.0938	33.0938	284800.0
2000-05-18 09:00:00	NVDA	Stock	0.2315	0.2353	0.2214	0.2292	125328000.0
2000-05-18 10:00:00	NVDA	Stock	0.2307	0.2332	0.226	0.2276	88080000.0
2000-05-18 11:00:00	NVDA	Stock	0.2276	0.2294	0.2257	0.2276	47904000.0
2000-05-18 12:00:00	NVDA	Stock	0.2268	0.2285	0.2263	0.2283	23376000.0
2000-05-18 13:00:00	NVDA	Stock	0.2281	0.2289	0.2262	0.2279	25008000.0
2000-05-18 14:00:00	NVDA	Stock	0.2279	0.2346	0.2277	0.2312	57504000.0
2000-05-18 15:00:00	NVDA	Stock	0.2309	0.2326	0.2132	0.2148	121344000.0
2000-05-18 16:00:00	NVDA	Stock	0.2147	0.2147	0.2147	0.2147	48000.0
2000-05-18 09:00:00	AMZN	Stock	3.0188	3.0438	2.9875	2.9906	17184000.0
2000-05-18 10:00:00	AMZN	Stock	2.9875	3.0125	2.9688	2.9938	11852000.0
2000-05-18 11:00:00	AMZN	Stock	2.9906	2.9938	2.9188	2.9375	13996000.0
2000-05-18 12:00:00	AMZN	Stock	2.9375	2.9625	2.925	2.9313	4192000.0
2000-05-18 13:00:00	AMZN	Stock	2.9313	2.9609	2.9125	2.9219	6106000.0
2000-05-18 14:00:00	AMZN	Stock	2.9188	2.9406	2.8625	2.8844	6550000.0
2000-05-18 15:00:00	AMZN	Stock	2.8844	2.8875	2.7562	2.7688	30930000.0
2000-05-18 16:00:00	AMZN	Stock	2.7719	2.7719	2.7688	2.7688	562000.0
2000-05-18 09:00:00	CL	Stock	28.625	29.75	28.625	29.7188	348800.0
2000-05-18 10:00:00	CL	Stock	29.6875	29.7188	29.3125	29.375	394400.0
2000-05-18 11:00:00	CL	Stock	29.3438	29.5938	29.3438	29.5625	269000.0
2000-05-18 12:00:00	CL	Stock	29.5312	29.6875	29.5312	29.5312	203800.0
2000-05-18 13:00:00	CL	Stock	29.5625	29.75	29.5625	29.6562	131800.0
2000-05-18 14:00:00	CL	Stock	29.625	29.75	29.5625	29.625	229600.0
2000-05-18 15:00:00	CL	Stock	29.5938	29.6875	29.5	29.5938	192600.0
2000-05-18 16:00:00	CL	Stock	29.5625	29.5625	29.5312	29.5312	53800.0

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

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