PREVIEW / stock_1hour / 2000-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-05.parquet
  size:    303 KB
  rows:    15,633
  symbols: 1,232

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-10-05 08:00:00	AAPL	Stock	0.4152	0.4174	0.4051	0.4118	1825600.0
2000-10-05 09:00:00	AAPL	Stock	0.4118	0.4275	0.4107	0.4208	121139200.0
2000-10-05 10:00:00	AAPL	Stock	0.4208	0.423	0.3996	0.4018	141422400.0
2000-10-05 11:00:00	AAPL	Stock	0.4029	0.4096	0.4007	0.4007	120915200.0
2000-10-05 12:00:00	AAPL	Stock	0.4018	0.4096	0.4007	0.4074	92612800.0
2000-10-05 13:00:00	AAPL	Stock	0.4074	0.4074	0.3996	0.4029	77044800.0
2000-10-05 14:00:00	AAPL	Stock	0.4029	0.4051	0.3929	0.3962	97664000.0
2000-10-05 15:00:00	AAPL	Stock	0.3962	0.4018	0.3929	0.394	178483200.0
2000-10-05 16:00:00	AAPL	Stock	0.3951	0.4012	0.394	0.3973	10550400.0
2000-10-05 17:00:00	AAPL	Stock	0.394	0.4018	0.394	0.3996	235200.0
2000-10-05 18:00:00	AAPL	Stock	0.3996	0.3996	0.399	0.3996	39200.0
2000-10-05 08:00:00	MSFT	Stock	27.5938	27.5938	27.375	27.5	38600.0
2000-10-05 09:00:00	MSFT	Stock	27.5	28.4062	27.25	28.3281	12076800.0
2000-10-05 10:00:00	MSFT	Stock	28.3438	28.625	28.0	28.125	15008600.0
2000-10-05 11:00:00	MSFT	Stock	28.0938	28.1875	27.75	27.8125	11975200.0
2000-10-05 12:00:00	MSFT	Stock	27.8125	28.0312	27.6562	28.0	7539000.0
2000-10-05 13:00:00	MSFT	Stock	28.0	28.1875	27.9062	28.1562	7652600.0
2000-10-05 14:00:00	MSFT	Stock	28.1875	28.25	27.6875	27.75	7893600.0
2000-10-05 15:00:00	MSFT	Stock	27.75	28.0	27.6562	27.6875	11751400.0
2000-10-05 16:00:00	MSFT	Stock	27.6562	27.9688	27.625	27.7812	4509600.0
2000-10-05 17:00:00	MSFT	Stock	27.9688	27.9688	27.75	27.7812	54600.0
2000-10-05 18:00:00	MSFT	Stock	27.75	27.75	27.7188	27.7188	12200.0
2000-10-05 09:00:00	NVDA	Stock	0.312	0.3141	0.3052	0.3068	57960000.0
2000-10-05 10:00:00	NVDA	Stock	0.3065	0.3083	0.3021	0.3029	34920000.0
2000-10-05 11:00:00	NVDA	Stock	0.3026	0.3056	0.3	0.3003	36120000.0
2000-10-05 12:00:00	NVDA	Stock	0.3	0.3042	0.2984	0.3031	57264000.0
2000-10-05 13:00:00	NVDA	Stock	0.3026	0.3047	0.3005	0.3018	40368000.0
2000-10-05 14:00:00	NVDA	Stock	0.3018	0.3029	0.2977	0.2995	71376000.0
2000-10-05 15:00:00	NVDA	Stock	0.2993	0.3042	0.2982	0.3042	194064000.0
2000-10-05 16:00:00	NVDA	Stock	0.3042	0.3104	0.3036	0.3042	13656000.0
2000-10-05 17:00:00	NVDA	Stock	0.3016	0.3016	0.3016	0.3016	1344000.0
2000-10-05 08:00:00	AMZN	Stock	1.7875	1.8	1.7375	1.7688	400000.0
2000-10-05 09:00:00	AMZN	Stock	1.75	1.8188	1.75	1.8031	7460000.0
2000-10-05 10:00:00	AMZN	Stock	1.8031	1.8312	1.7062	1.7156	12570000.0
2000-10-05 11:00:00	AMZN	Stock	1.7156	1.7156	1.6312	1.6312	35312000.0
2000-10-05 12:00:00	AMZN	Stock	1.6375	1.6719	1.625	1.6719	21232000.0
2000-10-05 13:00:00	AMZN	Stock	1.6688	1.6781	1.6	1.6562	16964000.0
2000-10-05 14:00:00	AMZN	Stock	1.6531	1.6781	1.6188	1.6188	16562000.0
2000-10-05 15:00:00	AMZN	Stock	1.6188	1.7031	1.6188	1.6781	18906000.0
2000-10-05 16:00:00	AMZN	Stock	1.6781	1.7969	1.6688	1.6812	1706000.0
2000-10-05 17:00:00	AMZN	Stock	1.6781	1.6781	1.6781	1.6781	8000.0
2000-10-05 18:00:00	AMZN	Stock	1.675	1.6781	1.675	1.6781	18000.0
2000-10-05 09:00:00	CL	Stock	24.0	24.7	24.0	24.505	1404600.0
2000-10-05 10:00:00	CL	Stock	24.505	24.645	24.35	24.35	1182800.0
2000-10-05 11:00:00	CL	Stock	24.355	24.52	24.275	24.475	533800.0
2000-10-05 12:00:00	CL	Stock	24.48	24.6	24.46	24.525	387200.0
2000-10-05 13:00:00	CL	Stock	24.525	25.125	24.525	25.05	1087000.0
2000-10-05 14:00:00	CL	Stock	25.055	25.25	24.925	25.18	618200.0
2000-10-05 15:00:00	CL	Stock	25.175	25.175	24.8	24.805	957200.0
2000-10-05 16:00:00	CL	Stock	24.805	24.99	24.66	24.99	881400.0

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

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