PREVIEW / stock_1hour / 2000-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-24.parquet
  size:    296 KB
  rows:    15,345
  symbols: 1,212

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-08-24 08:00:00	AAPL	Stock	0.9855	0.9855	0.9688	0.9688	128800.0
2000-08-24 09:00:00	AAPL	Stock	0.9688	0.9855	0.9531	0.9643	36668800.0
2000-08-24 10:00:00	AAPL	Stock	0.9637	0.9721	0.9598	0.9643	53082400.0
2000-08-24 11:00:00	AAPL	Stock	0.9648	0.971	0.9643	0.9688	26331200.0
2000-08-24 12:00:00	AAPL	Stock	0.9676	0.9699	0.9643	0.9643	13977600.0
2000-08-24 13:00:00	AAPL	Stock	0.9643	0.9721	0.9632	0.9676	19493600.0
2000-08-24 14:00:00	AAPL	Stock	0.9688	1.0	0.9665	0.9967	85624000.0
2000-08-24 15:00:00	AAPL	Stock	1.0	1.0112	0.9911	1.0033	61762400.0
2000-08-24 16:00:00	AAPL	Stock	1.0011	1.0045	0.976	1.0017	5773600.0
2000-08-24 17:00:00	AAPL	Stock	1.0011	1.0011	1.0011	1.0011	11200.0
2000-08-24 18:00:00	AAPL	Stock	1.0011	1.0011	1.0	1.0	72800.0
2000-08-24 08:00:00	MSFT	Stock	35.3906	35.5312	35.3906	35.4375	28000.0
2000-08-24 09:00:00	MSFT	Stock	35.4375	35.4375	35.1562	35.1562	4563000.0
2000-08-24 10:00:00	MSFT	Stock	35.1562	35.4375	35.0312	35.125	8455800.0
2000-08-24 11:00:00	MSFT	Stock	35.0938	35.1562	35.0312	35.0312	3835000.0
2000-08-24 12:00:00	MSFT	Stock	35.0625	35.125	34.9688	35.0312	6484400.0
2000-08-24 13:00:00	MSFT	Stock	35.0312	35.2188	35.0312	35.0938	2676200.0
2000-08-24 14:00:00	MSFT	Stock	35.0938	35.2812	35.0625	35.25	3651800.0
2000-08-24 15:00:00	MSFT	Stock	35.25	35.5938	35.25	35.5312	9935600.0
2000-08-24 16:00:00	MSFT	Stock	35.5312	35.625	35.2031	35.5625	2241600.0
2000-08-24 17:00:00	MSFT	Stock	35.5	35.5	35.5	35.5	2800.0
2000-08-24 18:00:00	MSFT	Stock	35.5	35.5	35.4062	35.4062	2600.0
2000-08-24 08:00:00	NVDA	Stock	0.3125	0.3125	0.3115	0.312	1128000.0
2000-08-24 09:00:00	NVDA	Stock	0.312	0.3167	0.3073	0.313	89376000.0
2000-08-24 10:00:00	NVDA	Stock	0.312	0.3146	0.3047	0.3078	75624000.0
2000-08-24 11:00:00	NVDA	Stock	0.3078	0.3099	0.3063	0.3094	26136000.0
2000-08-24 12:00:00	NVDA	Stock	0.3094	0.3112	0.3094	0.3102	16272000.0
2000-08-24 13:00:00	NVDA	Stock	0.3102	0.3109	0.3089	0.3109	12288000.0
2000-08-24 14:00:00	NVDA	Stock	0.3099	0.3143	0.3099	0.3141	35760000.0
2000-08-24 15:00:00	NVDA	Stock	0.3142	0.3237	0.3128	0.3161	65760000.0
2000-08-24 16:00:00	NVDA	Stock	0.3161	0.3206	0.3063	0.3063	4368000.0
2000-08-24 08:00:00	AMZN	Stock	1.95	2.05	1.925	1.975	342000.0
2000-08-24 09:00:00	AMZN	Stock	1.9531	1.9938	1.9531	1.9906	14882000.0
2000-08-24 10:00:00	AMZN	Stock	1.9906	2.025	1.9781	1.9906	32650000.0
2000-08-24 11:00:00	AMZN	Stock	1.9906	2.0	1.9781	1.9812	7352000.0
2000-08-24 12:00:00	AMZN	Stock	1.9812	1.9875	1.9656	1.9688	6524000.0
2000-08-24 13:00:00	AMZN	Stock	1.9688	1.9875	1.9656	1.9844	6312000.0
2000-08-24 14:00:00	AMZN	Stock	1.9844	1.9969	1.9812	1.9812	10856000.0
2000-08-24 15:00:00	AMZN	Stock	1.9844	1.9906	1.9406	1.9688	12782000.0
2000-08-24 16:00:00	AMZN	Stock	1.9688	1.9781	1.9547	1.9719	936000.0
2000-08-24 17:00:00	AMZN	Stock	1.9688	1.9719	1.9688	1.9719	22000.0
2000-08-24 18:00:00	AMZN	Stock	1.9688	1.975	1.9688	1.975	28000.0
2000-08-24 09:00:00	CL	Stock	26.0	26.4062	26.0	26.4062	485400.0
2000-08-24 10:00:00	CL	Stock	26.375	26.4062	26.0	26.0625	424400.0
2000-08-24 11:00:00	CL	Stock	26.0625	26.25	26.0	26.1875	464800.0
2000-08-24 12:00:00	CL	Stock	26.1562	26.2188	26.0938	26.0938	104000.0
2000-08-24 13:00:00	CL	Stock	26.0938	26.2188	26.0938	26.2188	203000.0
2000-08-24 14:00:00	CL	Stock	26.1875	26.5312	26.1875	26.375	351200.0
2000-08-24 15:00:00	CL	Stock	26.375	26.4688	26.3125	26.4062	357800.0
2000-08-24 16:00:00	CL	Stock	26.4062	26.4062	26.4062	26.4062	58600.0

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

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