PREVIEW / stock_1hour / 2000-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-02.parquet
  size:    318 KB
  rows:    16,415
  symbols: 1,236

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-02 08:00:00	AAPL	Stock	0.4688	0.4732	0.4643	0.471	24460800.0
2000-10-02 09:00:00	AAPL	Stock	0.471	0.4866	0.4598	0.4654	400372000.0
2000-10-02 10:00:00	AAPL	Stock	0.4654	0.4665	0.4565	0.4643	211752800.0
2000-10-02 11:00:00	AAPL	Stock	0.4643	0.4654	0.4464	0.4498	289212000.0
2000-10-02 12:00:00	AAPL	Stock	0.4498	0.4554	0.4475	0.4498	171091200.0
2000-10-02 13:00:00	AAPL	Stock	0.4498	0.4498	0.4397	0.4403	269152800.0
2000-10-02 14:00:00	AAPL	Stock	0.4408	0.4408	0.4275	0.4286	256239200.0
2000-10-02 15:00:00	AAPL	Stock	0.4286	0.4353	0.4196	0.433	262292800.0
2000-10-02 16:00:00	AAPL	Stock	0.4353	0.4732	0.4208	0.4291	29657600.0
2000-10-02 17:00:00	AAPL	Stock	0.4291	0.4431	0.4252	0.433	3505600.0
2000-10-02 18:00:00	AAPL	Stock	0.4342	0.4364	0.433	0.4342	431200.0
2000-10-02 08:00:00	MSFT	Stock	30.125	30.5	30.125	30.375	44800.0
2000-10-02 09:00:00	MSFT	Stock	30.4375	30.4375	30.0938	30.1875	3921400.0
2000-10-02 10:00:00	MSFT	Stock	30.1875	30.375	29.7188	30.0312	6709600.0
2000-10-02 11:00:00	MSFT	Stock	30.0312	30.0625	29.7188	29.8125	3905800.0
2000-10-02 12:00:00	MSFT	Stock	29.7812	29.8125	29.4375	29.5312	5317800.0
2000-10-02 13:00:00	MSFT	Stock	29.5312	29.6875	29.125	29.3125	6904800.0
2000-10-02 14:00:00	MSFT	Stock	29.2812	29.5	29.125	29.2188	6448000.0
2000-10-02 15:00:00	MSFT	Stock	29.1875	29.5938	29.125	29.5625	9449400.0
2000-10-02 16:00:00	MSFT	Stock	29.5625	29.75	29.125	29.3438	4576800.0
2000-10-02 17:00:00	MSFT	Stock	29.3438	29.625	29.125	29.5	437200.0
2000-10-02 18:00:00	MSFT	Stock	29.5156	29.5156	29.5156	29.5156	600.0
2000-10-02 08:00:00	NVDA	Stock	0.3411	0.3411	0.3411	0.3411	72000.0
2000-10-02 09:00:00	NVDA	Stock	0.3406	0.3573	0.3406	0.3573	28776000.0
2000-10-02 10:00:00	NVDA	Stock	0.3576	0.3594	0.3458	0.3568	36720000.0
2000-10-02 11:00:00	NVDA	Stock	0.356	0.3568	0.3469	0.3479	29064000.0
2000-10-02 12:00:00	NVDA	Stock	0.3479	0.3487	0.3375	0.3391	24600000.0
2000-10-02 13:00:00	NVDA	Stock	0.3404	0.3404	0.3245	0.3344	42792000.0
2000-10-02 14:00:00	NVDA	Stock	0.3346	0.3375	0.3333	0.3357	17544000.0
2000-10-02 15:00:00	NVDA	Stock	0.3359	0.3378	0.3313	0.332	43752000.0
2000-10-02 16:00:00	NVDA	Stock	0.3331	0.3375	0.3313	0.3315	18000000.0
2000-10-02 17:00:00	NVDA	Stock	0.3323	0.3336	0.3318	0.3331	5448000.0
2000-10-02 08:00:00	AMZN	Stock	1.9094	1.9094	1.8938	1.9031	64000.0
2000-10-02 09:00:00	AMZN	Stock	1.9062	1.9219	1.8812	1.8906	8084000.0
2000-10-02 10:00:00	AMZN	Stock	1.8906	1.9	1.825	1.8594	16812000.0
2000-10-02 11:00:00	AMZN	Stock	1.8594	1.8625	1.8375	1.8375	5832000.0
2000-10-02 12:00:00	AMZN	Stock	1.8375	1.8406	1.7719	1.7781	9168000.0
2000-10-02 13:00:00	AMZN	Stock	1.775	1.8094	1.7625	1.7812	9794000.0
2000-10-02 14:00:00	AMZN	Stock	1.7812	1.8312	1.7781	1.7906	7776000.0
2000-10-02 15:00:00	AMZN	Stock	1.7938	1.8	1.775	1.7969	12850000.0
2000-10-02 16:00:00	AMZN	Stock	1.7969	1.8188	1.775	1.7781	2486000.0
2000-10-02 17:00:00	AMZN	Stock	1.7812	1.8	1.7781	1.7969	166000.0
2000-10-02 18:00:00	AMZN	Stock	1.825	1.825	1.825	1.825	2000.0
2000-10-02 09:00:00	CL	Stock	23.625	23.625	23.395	23.415	181000.0
2000-10-02 10:00:00	CL	Stock	23.415	23.55	23.28	23.475	307800.0
2000-10-02 11:00:00	CL	Stock	23.45	23.45	23.225	23.23	233200.0
2000-10-02 12:00:00	CL	Stock	23.23	23.25	23.125	23.21	179200.0
2000-10-02 13:00:00	CL	Stock	23.205	23.6	23.2	23.47	302600.0
2000-10-02 14:00:00	CL	Stock	23.45	23.475	23.3	23.475	188000.0
2000-10-02 15:00:00	CL	Stock	23.44	23.55	23.44	23.47	364400.0

> showing 50 of 16,415 rows — these rows as CSV

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