PREVIEW / stock_1hour / 2000-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-16.parquet
  size:    301 KB
  rows:    15,640
  symbols: 1,179

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-06-16 09:00:00	AAPL	Stock	0.8281	0.8371	0.8092	0.8092	48316800.0
2000-06-16 10:00:00	AAPL	Stock	0.8097	0.8119	0.7952	0.8086	76552000.0
2000-06-16 11:00:00	AAPL	Stock	0.8086	0.8103	0.7997	0.8092	25984000.0
2000-06-16 12:00:00	AAPL	Stock	0.8092	0.8142	0.8086	0.8092	17908800.0
2000-06-16 13:00:00	AAPL	Stock	0.8092	0.8203	0.8086	0.8181	17438400.0
2000-06-16 14:00:00	AAPL	Stock	0.8181	0.827	0.8147	0.8164	27260800.0
2000-06-16 15:00:00	AAPL	Stock	0.8164	0.82	0.8092	0.8139	45707200.0
2000-06-16 16:00:00	AAPL	Stock	0.8136	0.8147	0.8131	0.8142	11435200.0
2000-06-16 17:00:00	AAPL	Stock	0.8139	0.8145	0.8139	0.8145	78400.0
2000-06-16 08:00:00	MSFT	Stock	36.3125	36.5625	36.2812	36.375	156400.0
2000-06-16 09:00:00	MSFT	Stock	36.3438	36.5625	36.0625	36.2188	15214400.0
2000-06-16 10:00:00	MSFT	Stock	36.25	36.2812	35.75	36.25	9990800.0
2000-06-16 11:00:00	MSFT	Stock	36.2188	36.25	35.8125	36.0	5442200.0
2000-06-16 12:00:00	MSFT	Stock	36.0	36.25	35.875	35.9375	4599400.0
2000-06-16 13:00:00	MSFT	Stock	35.875	36.3125	35.875	36.25	4648400.0
2000-06-16 14:00:00	MSFT	Stock	36.25	36.4688	36.1562	36.2812	4425000.0
2000-06-16 15:00:00	MSFT	Stock	36.2812	36.375	36.0	36.25	8348200.0
2000-06-16 16:00:00	MSFT	Stock	36.2812	36.5	36.2344	36.2812	7349600.0
2000-06-16 17:00:00	MSFT	Stock	36.2812	36.3125	36.0312	36.0625	140000.0
2000-06-16 18:00:00	MSFT	Stock	36.1562	36.3125	36.0312	36.0625	10400.0
2000-06-16 08:00:00	NVDA	Stock	0.2719	0.2719	0.2708	0.2708	144000.0
2000-06-16 09:00:00	NVDA	Stock	0.2729	0.2799	0.2701	0.2799	61872000.0
2000-06-16 10:00:00	NVDA	Stock	0.2799	0.2901	0.2767	0.288	114480000.0
2000-06-16 11:00:00	NVDA	Stock	0.2878	0.2924	0.2842	0.2922	63264000.0
2000-06-16 12:00:00	NVDA	Stock	0.2922	0.3073	0.2917	0.2961	247872000.0
2000-06-16 13:00:00	NVDA	Stock	0.2966	0.3057	0.2964	0.3053	139104000.0
2000-06-16 14:00:00	NVDA	Stock	0.3049	0.3094	0.2992	0.3017	132240000.0
2000-06-16 15:00:00	NVDA	Stock	0.3023	0.3125	0.2953	0.3116	172752000.0
2000-06-16 16:00:00	NVDA	Stock	0.3116	0.3146	0.3083	0.3083	28560000.0
2000-06-16 17:00:00	NVDA	Stock	0.3089	0.312	0.3083	0.3086	816000.0
2000-06-16 18:00:00	NVDA	Stock	0.3104	0.3104	0.3089	0.3089	96000.0
2000-06-16 08:00:00	AMZN	Stock	2.3313	2.3313	2.3188	2.3188	40000.0
2000-06-16 09:00:00	AMZN	Stock	2.3313	2.3719	2.325	2.35	13098000.0
2000-06-16 10:00:00	AMZN	Stock	2.35	2.3562	2.3125	2.3281	7902000.0
2000-06-16 11:00:00	AMZN	Stock	2.325	2.3344	2.3062	2.3156	3902000.0
2000-06-16 12:00:00	AMZN	Stock	2.3156	2.3406	2.3062	2.3078	7618000.0
2000-06-16 13:00:00	AMZN	Stock	2.3094	2.3219	2.2812	2.2969	7906000.0
2000-06-16 14:00:00	AMZN	Stock	2.3	2.3125	2.2875	2.2906	4632000.0
2000-06-16 15:00:00	AMZN	Stock	2.2906	2.3062	2.2688	2.2969	12362000.0
2000-06-16 16:00:00	AMZN	Stock	2.2969	2.3	2.2844	2.3	1650000.0
2000-06-16 17:00:00	AMZN	Stock	2.275	2.2984	2.275	2.2969	18000.0
2000-06-16 09:00:00	CL	Stock	29.0	29.125	28.875	28.875	1397400.0
2000-06-16 10:00:00	CL	Stock	28.8125	29.0938	28.8125	29.0	349800.0
2000-06-16 11:00:00	CL	Stock	29.0	29.0312	28.875	28.875	170000.0
2000-06-16 12:00:00	CL	Stock	28.875	28.9062	28.6562	28.75	415600.0
2000-06-16 13:00:00	CL	Stock	28.7812	29.0625	28.75	28.9688	321600.0
2000-06-16 14:00:00	CL	Stock	28.9688	29.0938	28.9062	29.0	503200.0
2000-06-16 15:00:00	CL	Stock	29.0	29.0312	28.8125	28.9375	689600.0
2000-06-16 16:00:00	CL	Stock	28.9688	28.9688	28.9375	28.9375	425600.0
2000-06-16 17:00:00	CL	Stock	28.9375	28.9375	28.9375	28.9375	24800.0

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

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