PREVIEW / stock_1hour / 2000-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-21.parquet
  size:    294 KB
  rows:    15,069
  symbols: 1,191

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-07-21 08:00:00	AAPL	Stock	0.9799	0.9833	0.9799	0.9833	145600.0
2000-07-21 09:00:00	AAPL	Stock	0.9821	0.9933	0.9704	0.99	35879200.0
2000-07-21 10:00:00	AAPL	Stock	0.99	0.9911	0.952	0.9554	57999200.0
2000-07-21 11:00:00	AAPL	Stock	0.9554	0.9621	0.952	0.9576	19303200.0
2000-07-21 12:00:00	AAPL	Stock	0.9576	0.9587	0.9453	0.9498	22209600.0
2000-07-21 13:00:00	AAPL	Stock	0.9498	0.9542	0.9487	0.9531	12202400.0
2000-07-21 14:00:00	AAPL	Stock	0.9531	0.9576	0.9509	0.9542	7392000.0
2000-07-21 15:00:00	AAPL	Stock	0.9542	0.9676	0.9509	0.9554	26992000.0
2000-07-21 16:00:00	AAPL	Stock	0.9554	0.9576	0.9509	0.9565	6636000.0
2000-07-21 17:00:00	AAPL	Stock	0.9565	0.9576	0.9509	0.9576	33600.0
2000-07-21 18:00:00	AAPL	Stock	0.9576	0.9576	0.9576	0.9576	5600.0
2000-07-21 08:00:00	MSFT	Stock	37.3125	37.4375	37.0	37.2812	137200.0
2000-07-21 09:00:00	MSFT	Stock	37.3125	37.5	37.125	37.2188	7547000.0
2000-07-21 10:00:00	MSFT	Stock	37.2188	37.2188	36.6562	36.6875	8786800.0
2000-07-21 11:00:00	MSFT	Stock	36.6875	36.7812	36.2812	36.375	8873600.0
2000-07-21 12:00:00	MSFT	Stock	36.375	36.4375	36.25	36.3125	5262600.0
2000-07-21 13:00:00	MSFT	Stock	36.3125	36.3125	35.9375	36.0938	7099000.0
2000-07-21 14:00:00	MSFT	Stock	36.0938	36.25	35.9688	36.0312	6340600.0
2000-07-21 15:00:00	MSFT	Stock	36.0	36.4375	36.0	36.1875	8731000.0
2000-07-21 16:00:00	MSFT	Stock	36.1719	36.5625	36.1562	36.1562	2722000.0
2000-07-21 17:00:00	MSFT	Stock	36.1875	36.4062	36.1562	36.1875	18200.0
2000-07-21 18:00:00	MSFT	Stock	36.1875	36.25	36.1562	36.1562	4600.0
2000-07-21 09:00:00	NVDA	Stock	0.2885	0.2958	0.2833	0.2893	27288000.0
2000-07-21 10:00:00	NVDA	Stock	0.2906	0.2917	0.2885	0.2901	43512000.0
2000-07-21 11:00:00	NVDA	Stock	0.2904	0.2911	0.2885	0.2896	19728000.0
2000-07-21 12:00:00	NVDA	Stock	0.2896	0.2898	0.2875	0.2891	26952000.0
2000-07-21 13:00:00	NVDA	Stock	0.2885	0.2901	0.2875	0.2891	38088000.0
2000-07-21 14:00:00	NVDA	Stock	0.2891	0.2917	0.2875	0.2909	39408000.0
2000-07-21 15:00:00	NVDA	Stock	0.2909	0.2914	0.2875	0.2904	42432000.0
2000-07-21 16:00:00	NVDA	Stock	0.2906	0.2909	0.2875	0.2875	14064000.0
2000-07-21 18:00:00	NVDA	Stock	0.2875	0.2875	0.2875	0.2875	216000.0
2000-07-21 08:00:00	AMZN	Stock	2.0594	2.0594	2.0156	2.0188	272000.0
2000-07-21 09:00:00	AMZN	Stock	2.025	2.125	2.0188	2.0875	16012000.0
2000-07-21 10:00:00	AMZN	Stock	2.0859	2.0938	2.0344	2.0938	17444000.0
2000-07-21 11:00:00	AMZN	Stock	2.0875	2.1125	2.0844	2.1	20490000.0
2000-07-21 12:00:00	AMZN	Stock	2.0969	2.1	2.0625	2.0625	9058000.0
2000-07-21 13:00:00	AMZN	Stock	2.0625	2.0719	2.0312	2.0344	9452000.0
2000-07-21 14:00:00	AMZN	Stock	2.0344	2.0656	2.0344	2.0531	4748000.0
2000-07-21 15:00:00	AMZN	Stock	2.0625	2.0813	2.0469	2.0531	13440000.0
2000-07-21 16:00:00	AMZN	Stock	2.0531	2.125	2.05	2.0562	2230000.0
2000-07-21 09:00:00	CL	Stock	28.0625	28.125	27.6875	27.875	758200.0
2000-07-21 10:00:00	CL	Stock	27.875	28.2812	27.8125	28.25	842000.0
2000-07-21 11:00:00	CL	Stock	28.2812	28.4375	28.1875	28.375	457000.0
2000-07-21 12:00:00	CL	Stock	28.4062	28.625	28.3438	28.5	493200.0
2000-07-21 13:00:00	CL	Stock	28.4688	28.5312	28.3438	28.375	492600.0
2000-07-21 14:00:00	CL	Stock	28.375	28.4062	28.2812	28.3125	284000.0
2000-07-21 15:00:00	CL	Stock	28.3125	28.5	28.125	28.3438	531400.0
2000-07-21 16:00:00	CL	Stock	28.3125	28.3438	28.3125	28.3125	137400.0
2000-07-21 17:00:00	CL	Stock	28.3125	28.3125	28.3125	28.3125	4000.0

> showing 49 of 15,069 rows — these rows as CSV

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