PREVIEW / stock_1hour / 2000-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-13.parquet
  size:    296 KB
  rows:    15,248
  symbols: 1,209

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-09-13 08:00:00	AAPL	Stock	1.0307	1.0357	0.9844	1.0	935200.0
2000-09-13 09:00:00	AAPL	Stock	0.9821	1.0413	0.9821	1.0357	61157600.0
2000-09-13 10:00:00	AAPL	Stock	1.0391	1.0625	1.0301	1.043	65637600.0
2000-09-13 11:00:00	AAPL	Stock	1.0446	1.0458	1.0223	1.0246	25961600.0
2000-09-13 12:00:00	AAPL	Stock	1.0234	1.029	1.0201	1.0246	17270400.0
2000-09-13 13:00:00	AAPL	Stock	1.0246	1.0246	1.0134	1.019	37553600.0
2000-09-13 14:00:00	AAPL	Stock	1.019	1.0424	1.0173	1.0346	34860000.0
2000-09-13 15:00:00	AAPL	Stock	1.0357	1.0402	1.0201	1.0346	46916800.0
2000-09-13 16:00:00	AAPL	Stock	1.0352	1.0424	1.0346	1.0357	5812800.0
2000-09-13 08:00:00	MSFT	Stock	34.0	34.0625	33.5312	33.625	99600.0
2000-09-13 09:00:00	MSFT	Stock	33.6875	34.0625	33.625	33.75	6737400.0
2000-09-13 10:00:00	MSFT	Stock	33.7812	34.2188	33.6562	33.9844	8152600.0
2000-09-13 11:00:00	MSFT	Stock	33.9688	34.0625	33.75	33.9375	4112800.0
2000-09-13 12:00:00	MSFT	Stock	33.9062	34.0	33.6875	33.6875	3331600.0
2000-09-13 13:00:00	MSFT	Stock	33.6875	33.9062	33.5938	33.8438	4911800.0
2000-09-13 14:00:00	MSFT	Stock	33.8125	34.375	33.75	34.0938	5033000.0
2000-09-13 15:00:00	MSFT	Stock	34.0625	34.1562	33.6875	34.1094	5728600.0
2000-09-13 16:00:00	MSFT	Stock	34.0938	34.2188	33.9062	34.125	938600.0
2000-09-13 17:00:00	MSFT	Stock	34.0312	34.125	34.0312	34.0312	73200.0
2000-09-13 18:00:00	MSFT	Stock	34.0625	34.0625	34.0625	34.0625	200.0
2000-09-13 08:00:00	NVDA	Stock	0.2898	0.2922	0.2898	0.2922	96000.0
2000-09-13 09:00:00	NVDA	Stock	0.2917	0.2938	0.2849	0.2896	56304000.0
2000-09-13 10:00:00	NVDA	Stock	0.2898	0.2919	0.2896	0.2914	25224000.0
2000-09-13 11:00:00	NVDA	Stock	0.2914	0.2917	0.2896	0.2896	15720000.0
2000-09-13 12:00:00	NVDA	Stock	0.2898	0.2917	0.2896	0.2906	18936000.0
2000-09-13 13:00:00	NVDA	Stock	0.2914	0.2914	0.2896	0.2906	5256000.0
2000-09-13 14:00:00	NVDA	Stock	0.2906	0.2966	0.2901	0.2948	44952000.0
2000-09-13 15:00:00	NVDA	Stock	0.2958	0.2958	0.2896	0.2919	46320000.0
2000-09-13 16:00:00	NVDA	Stock	0.2919	0.2927	0.2911	0.2922	6048000.0
2000-09-13 17:00:00	NVDA	Stock	0.2922	0.2922	0.2917	0.2919	192000.0
2000-09-13 18:00:00	NVDA	Stock	0.2906	0.2906	0.2906	0.2906	48000.0
2000-09-13 08:00:00	AMZN	Stock	2.1125	2.15	2.0625	2.075	478000.0
2000-09-13 09:00:00	AMZN	Stock	2.075	2.125	2.05	2.0938	11284000.0
2000-09-13 10:00:00	AMZN	Stock	2.0938	2.1562	2.0875	2.1031	14312000.0
2000-09-13 11:00:00	AMZN	Stock	2.1062	2.125	2.0938	2.1031	11372000.0
2000-09-13 12:00:00	AMZN	Stock	2.1031	2.1062	2.0719	2.0781	8838000.0
2000-09-13 13:00:00	AMZN	Stock	2.0781	2.1125	2.0562	2.1	9666000.0
2000-09-13 14:00:00	AMZN	Stock	2.0969	2.1281	2.0906	2.1203	8610000.0
2000-09-13 15:00:00	AMZN	Stock	2.1188	2.125	2.0969	2.1188	11458000.0
2000-09-13 16:00:00	AMZN	Stock	2.1219	2.1312	2.1156	2.1219	850000.0
2000-09-13 17:00:00	AMZN	Stock	2.1375	2.1375	2.1	2.1125	154000.0
2000-09-13 18:00:00	AMZN	Stock	2.1016	2.1016	2.075	2.1	80000.0
2000-09-13 09:00:00	CL	Stock	27.8438	27.8438	27.4062	27.5312	779200.0
2000-09-13 10:00:00	CL	Stock	27.5	27.625	27.4375	27.5625	440600.0
2000-09-13 11:00:00	CL	Stock	27.5938	27.9062	27.5312	27.7812	371200.0
2000-09-13 12:00:00	CL	Stock	27.8125	27.9375	27.6875	27.8438	466000.0
2000-09-13 13:00:00	CL	Stock	27.8438	28.1875	27.8438	28.0938	652200.0
2000-09-13 14:00:00	CL	Stock	28.0938	28.3125	28.0312	28.0938	662200.0
2000-09-13 15:00:00	CL	Stock	28.0938	28.1875	27.875	28.0938	807600.0
2000-09-13 16:00:00	CL	Stock	28.0938	28.0938	28.0938	28.0938	101200.0

> showing 50 of 15,248 rows — these rows as CSV

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