PREVIEW / stock_1hour / 2000-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-17.parquet
  size:    303 KB
  rows:    15,468
  symbols: 1,201

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-17 08:00:00	AAPL	Stock	1.0446	1.0558	1.0446	1.0446	789600.0
2000-07-17 09:00:00	AAPL	Stock	1.0536	1.0536	1.0279	1.0352	23531200.0
2000-07-17 10:00:00	AAPL	Stock	1.0352	1.0502	1.0257	1.0368	58167200.0
2000-07-17 11:00:00	AAPL	Stock	1.0379	1.0491	1.0346	1.0379	38998400.0
2000-07-17 12:00:00	AAPL	Stock	1.0368	1.0379	1.0201	1.0279	32659200.0
2000-07-17 13:00:00	AAPL	Stock	1.029	1.0335	1.0234	1.0324	19437600.0
2000-07-17 14:00:00	AAPL	Stock	1.0313	1.0446	1.0234	1.0402	35929600.0
2000-07-17 15:00:00	AAPL	Stock	1.0396	1.0446	1.0357	1.0413	38203200.0
2000-07-17 16:00:00	AAPL	Stock	1.0413	1.0446	1.0357	1.0446	2447200.0
2000-07-17 17:00:00	AAPL	Stock	1.0446	1.0469	1.0379	1.0458	207200.0
2000-07-17 18:00:00	AAPL	Stock	1.0458	1.0458	1.0458	1.0458	22400.0
2000-07-17 08:00:00	MSFT	Stock	39.0	39.5	39.0	39.5	72600.0
2000-07-17 09:00:00	MSFT	Stock	39.4375	39.5	38.7812	38.8438	7049000.0
2000-07-17 10:00:00	MSFT	Stock	38.8125	39.125	38.75	38.9688	9051000.0
2000-07-17 11:00:00	MSFT	Stock	39.0	39.625	38.875	39.375	8249400.0
2000-07-17 12:00:00	MSFT	Stock	39.375	39.6562	39.25	39.625	7553000.0
2000-07-17 13:00:00	MSFT	Stock	39.625	39.7812	39.5	39.625	4452800.0
2000-07-17 14:00:00	MSFT	Stock	39.6562	39.6562	39.1875	39.3125	5931800.0
2000-07-17 15:00:00	MSFT	Stock	39.3125	39.375	38.9688	39.125	9212600.0
2000-07-17 16:00:00	MSFT	Stock	39.125	39.6875	39.0312	39.0938	1149000.0
2000-07-17 17:00:00	MSFT	Stock	39.0938	39.125	39.0	39.0625	42800.0
2000-07-17 18:00:00	MSFT	Stock	39.0938	39.25	39.0938	39.0938	6400.0
2000-07-17 09:00:00	NVDA	Stock	0.3083	0.3125	0.3031	0.3063	15528000.0
2000-07-17 10:00:00	NVDA	Stock	0.3063	0.3083	0.3052	0.3077	18144000.0
2000-07-17 11:00:00	NVDA	Stock	0.3078	0.3104	0.3057	0.3081	13392000.0
2000-07-17 12:00:00	NVDA	Stock	0.3078	0.3078	0.3039	0.3042	7368000.0
2000-07-17 13:00:00	NVDA	Stock	0.304	0.3063	0.3036	0.3052	7248000.0
2000-07-17 14:00:00	NVDA	Stock	0.3052	0.307	0.3052	0.306	8976000.0
2000-07-17 15:00:00	NVDA	Stock	0.306	0.3063	0.3031	0.3042	27024000.0
2000-07-17 16:00:00	NVDA	Stock	0.3042	0.3057	0.3042	0.3057	2304000.0
2000-07-17 08:00:00	AMZN	Stock	2.1062	2.175	2.1	2.125	296000.0
2000-07-17 09:00:00	AMZN	Stock	2.1312	2.1969	2.0813	2.0875	30350000.0
2000-07-17 10:00:00	AMZN	Stock	2.0844	2.125	2.0625	2.1	21880000.0
2000-07-17 11:00:00	AMZN	Stock	2.1	2.1062	2.075	2.0828	14694000.0
2000-07-17 12:00:00	AMZN	Stock	2.0844	2.0938	2.0625	2.0625	12180000.0
2000-07-17 13:00:00	AMZN	Stock	2.0656	2.1	2.0125	2.0875	20006000.0
2000-07-17 14:00:00	AMZN	Stock	2.0875	2.0969	2.0562	2.0562	10306000.0
2000-07-17 15:00:00	AMZN	Stock	2.0562	2.0906	2.05	2.0594	12568000.0
2000-07-17 16:00:00	AMZN	Stock	2.0594	2.1422	2.0562	2.0813	1636000.0
2000-07-17 17:00:00	AMZN	Stock	2.075	2.0875	2.0516	2.075	58000.0
2000-07-17 18:00:00	AMZN	Stock	2.0828	2.0828	2.0594	2.0594	8000.0
2000-07-17 09:00:00	CL	Stock	26.6875	26.8125	26.375	26.8125	507600.0
2000-07-17 10:00:00	CL	Stock	26.7812	26.8438	26.375	26.375	812400.0
2000-07-17 11:00:00	CL	Stock	26.375	26.875	26.3438	26.8125	656200.0
2000-07-17 12:00:00	CL	Stock	26.8438	27.375	26.8125	27.2812	606800.0
2000-07-17 13:00:00	CL	Stock	27.2812	27.4062	27.25	27.3438	501200.0
2000-07-17 14:00:00	CL	Stock	27.3125	27.8125	27.2812	27.7188	502800.0
2000-07-17 15:00:00	CL	Stock	27.6875	27.7188	27.4688	27.5	1023000.0
2000-07-17 16:00:00	CL	Stock	27.4688	27.5625	27.4531	27.4688	77400.0
2000-07-17 17:00:00	CL	Stock	27.4688	27.4688	27.4688	27.4688	10000.0

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

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