PREVIEW / stock_1hour / 2000-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-21.parquet
  size:    289 KB
  rows:    15,207
  symbols: 1,209

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-21 08:00:00	AAPL	Stock	0.8996	0.8996	0.8996	0.8996	22400.0
2000-08-21 09:00:00	AAPL	Stock	0.8984	0.9208	0.8973	0.9174	27188000.0
2000-08-21 10:00:00	AAPL	Stock	0.9152	0.9196	0.8951	0.9051	23228800.0
2000-08-21 11:00:00	AAPL	Stock	0.9029	0.9152	0.9018	0.9107	13552000.0
2000-08-21 12:00:00	AAPL	Stock	0.9107	0.9208	0.9107	0.9152	14504000.0
2000-08-21 13:00:00	AAPL	Stock	0.9163	0.9174	0.8996	0.9007	17477600.0
2000-08-21 14:00:00	AAPL	Stock	0.8996	0.9074	0.8895	0.8929	11900000.0
2000-08-21 15:00:00	AAPL	Stock	0.8929	0.9018	0.8862	0.9007	23503200.0
2000-08-21 16:00:00	AAPL	Stock	0.9018	0.9018	0.8951	0.9007	2480800.0
2000-08-21 17:00:00	AAPL	Stock	0.8996	0.8996	0.8996	0.8996	5600.0
2000-08-21 18:00:00	AAPL	Stock	0.8951	0.8973	0.8951	0.8973	28000.0
2000-08-21 08:00:00	MSFT	Stock	35.5	35.5312	35.0	35.5	42000.0
2000-08-21 09:00:00	MSFT	Stock	35.5	35.625	35.0938	35.25	5422000.0
2000-08-21 10:00:00	MSFT	Stock	35.25	35.3125	35.125	35.2812	5200400.0
2000-08-21 11:00:00	MSFT	Stock	35.3125	35.3438	35.125	35.1875	3069000.0
2000-08-21 12:00:00	MSFT	Stock	35.1875	35.25	35.0625	35.0938	4003600.0
2000-08-21 13:00:00	MSFT	Stock	35.125	35.25	35.0	35.0938	5479200.0
2000-08-21 14:00:00	MSFT	Stock	35.0938	35.1875	35.0	35.0938	4130400.0
2000-08-21 15:00:00	MSFT	Stock	35.0625	35.3125	35.0	35.3125	4688600.0
2000-08-21 16:00:00	MSFT	Stock	35.2812	35.3125	35.0625	35.3125	1772200.0
2000-08-21 17:00:00	MSFT	Stock	35.3125	35.375	35.1875	35.1875	3200.0
2000-08-21 18:00:00	MSFT	Stock	35.25	35.25	35.25	35.25	200.0
2000-08-21 08:00:00	NVDA	Stock	0.3281	0.3313	0.3281	0.3292	120000.0
2000-08-21 09:00:00	NVDA	Stock	0.3292	0.3333	0.3255	0.3281	58368000.0
2000-08-21 10:00:00	NVDA	Stock	0.3281	0.3383	0.3271	0.3359	149688000.0
2000-08-21 11:00:00	NVDA	Stock	0.3354	0.3365	0.3292	0.3315	33648000.0
2000-08-21 12:00:00	NVDA	Stock	0.3315	0.3315	0.3266	0.3271	32544000.0
2000-08-21 13:00:00	NVDA	Stock	0.3271	0.3292	0.3224	0.3271	31080000.0
2000-08-21 14:00:00	NVDA	Stock	0.3271	0.3305	0.3224	0.327	44280000.0
2000-08-21 15:00:00	NVDA	Stock	0.3266	0.3313	0.324	0.3255	71160000.0
2000-08-21 16:00:00	NVDA	Stock	0.325	0.3417	0.313	0.3198	22176000.0
2000-08-21 17:00:00	NVDA	Stock	0.3198	0.3198	0.2918	0.3073	10104000.0
2000-08-21 18:00:00	NVDA	Stock	0.3073	0.3125	0.3073	0.3096	1752000.0
2000-08-21 08:00:00	AMZN	Stock	1.9406	1.95	1.9406	1.9469	22000.0
2000-08-21 09:00:00	AMZN	Stock	1.9438	1.9562	1.8938	1.9031	10282000.0
2000-08-21 10:00:00	AMZN	Stock	1.9031	1.9688	1.9	1.95	10730000.0
2000-08-21 11:00:00	AMZN	Stock	1.95	1.9688	1.9406	1.9594	7678000.0
2000-08-21 12:00:00	AMZN	Stock	1.9609	1.9938	1.95	1.9594	8226000.0
2000-08-21 13:00:00	AMZN	Stock	1.9625	1.975	1.9125	1.9188	8366000.0
2000-08-21 14:00:00	AMZN	Stock	1.9125	1.9219	1.85	1.8688	17836000.0
2000-08-21 15:00:00	AMZN	Stock	1.8656	1.8781	1.85	1.8688	15832000.0
2000-08-21 16:00:00	AMZN	Stock	1.875	1.8812	1.8562	1.8781	872000.0
2000-08-21 17:00:00	AMZN	Stock	1.875	1.8781	1.875	1.8781	14000.0
2000-08-21 09:00:00	CL	Stock	26.5	26.75	26.2812	26.375	492600.0
2000-08-21 10:00:00	CL	Stock	26.375	26.5625	26.2188	26.3125	445000.0
2000-08-21 11:00:00	CL	Stock	26.2812	26.3438	26.1875	26.2812	190800.0
2000-08-21 12:00:00	CL	Stock	26.2812	26.2812	26.0938	26.125	137600.0
2000-08-21 13:00:00	CL	Stock	26.125	26.25	26.0938	26.2188	242000.0
2000-08-21 14:00:00	CL	Stock	26.1875	26.25	26.0938	26.1875	233400.0
2000-08-21 15:00:00	CL	Stock	26.1875	26.375	26.1562	26.3125	584800.0

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

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