PREVIEW / stock_1hour / 2000-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-28.parquet
  size:    278 KB
  rows:    14,450
  symbols: 1,166

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-28 09:00:00	AAPL	Stock	1.135	1.1384	1.115	1.12	32692800.0
2000-04-28 10:00:00	AAPL	Stock	1.1183	1.1228	1.0938	1.0949	53726400.0
2000-04-28 11:00:00	AAPL	Stock	1.0943	1.106	1.0831	1.0965	36164800.0
2000-04-28 12:00:00	AAPL	Stock	1.0965	1.1038	1.0893	1.1038	21560000.0
2000-04-28 13:00:00	AAPL	Stock	1.1038	1.118	1.0988	1.115	26689600.0
2000-04-28 14:00:00	AAPL	Stock	1.1127	1.1205	1.1027	1.1094	28067200.0
2000-04-28 15:00:00	AAPL	Stock	1.1088	1.1138	1.0949	1.108	28672000.0
2000-04-28 16:00:00	AAPL	Stock	1.1083	1.1083	1.1077	1.1077	2251200.0
2000-04-28 09:00:00	MSFT	Stock	35.375	35.4375	34.7188	34.75	14765200.0
2000-04-28 10:00:00	MSFT	Stock	34.75	34.9688	34.5	34.6562	13493600.0
2000-04-28 11:00:00	MSFT	Stock	34.6562	34.6875	34.125	34.2188	10800000.0
2000-04-28 12:00:00	MSFT	Stock	34.2188	34.3438	34.125	34.2812	5461400.0
2000-04-28 13:00:00	MSFT	Stock	34.2812	34.4375	34.2188	34.2812	5946800.0
2000-04-28 14:00:00	MSFT	Stock	34.2812	34.5312	34.2812	34.4688	8523400.0
2000-04-28 15:00:00	MSFT	Stock	34.5	34.9375	34.25	34.9062	11237600.0
2000-04-28 16:00:00	MSFT	Stock	34.9062	34.9375	34.8438	34.875	590800.0
2000-04-28 09:00:00	NVDA	Stock	0.1926	0.2	0.1906	0.1906	28608000.0
2000-04-28 10:00:00	NVDA	Stock	0.1906	0.1954	0.1896	0.1897	35712000.0
2000-04-28 11:00:00	NVDA	Stock	0.1898	0.1921	0.1885	0.1917	13728000.0
2000-04-28 12:00:00	NVDA	Stock	0.1919	0.1921	0.1885	0.1904	15168000.0
2000-04-28 13:00:00	NVDA	Stock	0.1902	0.1958	0.19	0.194	12144000.0
2000-04-28 14:00:00	NVDA	Stock	0.1948	0.1969	0.1917	0.1921	19008000.0
2000-04-28 15:00:00	NVDA	Stock	0.1917	0.1919	0.1857	0.1857	39072000.0
2000-04-28 16:00:00	NVDA	Stock	0.1857	0.1857	0.1857	0.1857	96000.0
2000-04-28 09:00:00	AMZN	Stock	2.7	2.7812	2.6688	2.6938	17246000.0
2000-04-28 10:00:00	AMZN	Stock	2.6969	2.7688	2.6813	2.7312	22338000.0
2000-04-28 11:00:00	AMZN	Stock	2.7312	2.7344	2.6562	2.6938	19162000.0
2000-04-28 12:00:00	AMZN	Stock	2.6938	2.75	2.6875	2.7344	12198000.0
2000-04-28 13:00:00	AMZN	Stock	2.7375	2.7594	2.675	2.7063	16050000.0
2000-04-28 14:00:00	AMZN	Stock	2.7	2.7625	2.7	2.7438	12302000.0
2000-04-28 15:00:00	AMZN	Stock	2.7438	2.7688	2.7125	2.7625	20554000.0
2000-04-28 16:00:00	AMZN	Stock	2.7594	2.7625	2.7562	2.7594	552000.0
2000-04-28 09:00:00	CL	Stock	28.25	28.6562	28.1875	28.5312	450600.0
2000-04-28 10:00:00	CL	Stock	28.5	28.75	28.4062	28.5	734000.0
2000-04-28 11:00:00	CL	Stock	28.5	28.6875	27.7812	27.9688	374200.0
2000-04-28 12:00:00	CL	Stock	27.9062	27.9375	27.4375	27.6562	353000.0
2000-04-28 13:00:00	CL	Stock	27.6562	27.9688	27.5	27.8438	333400.0
2000-04-28 14:00:00	CL	Stock	27.7812	28.0	27.75	27.9688	438000.0
2000-04-28 15:00:00	CL	Stock	28.0	28.875	28.0	28.5938	1185600.0
2000-04-28 16:00:00	CL	Stock	28.5625	28.5625	28.5625	28.5625	77400.0

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

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