PREVIEW / stock_1hour / 2001-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-09.parquet
  size:    351 KB
  rows:    16,248
  symbols: 1,268

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
2001-03-09 08:00:00	AAPL	Stock	0.3661	0.3683	0.3661	0.3683	834400.0
2001-03-09 09:00:00	AAPL	Stock	0.3644	0.3694	0.3616	0.3627	49403200.0
2001-03-09 10:00:00	AAPL	Stock	0.3616	0.3638	0.3571	0.3638	67004000.0
2001-03-09 11:00:00	AAPL	Stock	0.3627	0.365	0.3583	0.3616	46334400.0
2001-03-09 12:00:00	AAPL	Stock	0.3627	0.365	0.3583	0.3605	24903200.0
2001-03-09 13:00:00	AAPL	Stock	0.3605	0.3616	0.3583	0.3616	22114400.0
2001-03-09 14:00:00	AAPL	Stock	0.3605	0.3616	0.3594	0.3594	17253600.0
2001-03-09 15:00:00	AAPL	Stock	0.3605	0.3627	0.3583	0.3605	49985600.0
2001-03-09 16:00:00	AAPL	Stock	0.3605	0.3638	0.3583	0.3616	11603200.0
2001-03-09 17:00:00	AAPL	Stock	0.3616	0.3616	0.3616	0.3616	543200.0
2001-03-09 08:00:00	MSFT	Stock	28.8125	29.1875	28.8125	29.0	792000.0
2001-03-09 09:00:00	MSFT	Stock	29.0	29.0938	28.7812	28.875	10866000.0
2001-03-09 10:00:00	MSFT	Stock	28.875	28.9062	28.4375	28.5625	17875800.0
2001-03-09 11:00:00	MSFT	Stock	28.5	28.5312	28.1562	28.2812	9250000.0
2001-03-09 12:00:00	MSFT	Stock	28.2812	28.375	28.0312	28.0625	6487600.0
2001-03-09 13:00:00	MSFT	Stock	28.0938	28.3438	28.0625	28.3125	3703200.0
2001-03-09 14:00:00	MSFT	Stock	28.3438	28.375	27.5	27.5938	16898200.0
2001-03-09 15:00:00	MSFT	Stock	27.5938	28.5625	27.4375	28.3125	30029200.0
2001-03-09 16:00:00	MSFT	Stock	28.3125	28.5938	27.9375	28.0	2899600.0
2001-03-09 17:00:00	MSFT	Stock	28.3438	28.3438	28.0625	28.0625	74600.0
2001-03-09 18:00:00	MSFT	Stock	28.125	28.125	28.0	28.0625	10800.0
2001-03-09 08:00:00	NVDA	Stock	0.2146	0.2146	0.2125	0.2146	768000.0
2001-03-09 09:00:00	NVDA	Stock	0.2167	0.2188	0.2052	0.2096	177624000.0
2001-03-09 10:00:00	NVDA	Stock	0.2107	0.2107	0.2052	0.207	133800000.0
2001-03-09 11:00:00	NVDA	Stock	0.2073	0.2083	0.2052	0.2083	82128000.0
2001-03-09 12:00:00	NVDA	Stock	0.2083	0.2096	0.2073	0.2089	66552000.0
2001-03-09 13:00:00	NVDA	Stock	0.2091	0.2091	0.1987	0.1995	141432000.0
2001-03-09 14:00:00	NVDA	Stock	0.199	0.2	0.1891	0.1919	182136000.0
2001-03-09 15:00:00	NVDA	Stock	0.1919	0.2104	0.1911	0.2083	244368000.0
2001-03-09 16:00:00	NVDA	Stock	0.2086	0.2125	0.2063	0.2083	45960000.0
2001-03-09 17:00:00	NVDA	Stock	0.2099	0.2107	0.2073	0.2073	1416000.0
2001-03-09 08:00:00	AMZN	Stock	0.5375	0.575	0.5375	0.5688	582000.0
2001-03-09 09:00:00	AMZN	Stock	0.5656	0.5844	0.5594	0.5812	19338000.0
2001-03-09 10:00:00	AMZN	Stock	0.5781	0.6	0.5781	0.5938	24598000.0
2001-03-09 11:00:00	AMZN	Stock	0.5938	0.6094	0.5844	0.5859	19522000.0
2001-03-09 12:00:00	AMZN	Stock	0.5875	0.5938	0.5844	0.5906	17110000.0
2001-03-09 13:00:00	AMZN	Stock	0.5906	0.6125	0.5906	0.6	14320000.0
2001-03-09 14:00:00	AMZN	Stock	0.5969	0.6125	0.5969	0.6094	21334000.0
2001-03-09 15:00:00	AMZN	Stock	0.6094	0.625	0.5969	0.6156	42938000.0
2001-03-09 16:00:00	AMZN	Stock	0.6141	0.6188	0.5969	0.6125	2238000.0
2001-03-09 17:00:00	AMZN	Stock	0.6031	0.6156	0.6	0.6156	52000.0
2001-03-09 18:00:00	AMZN	Stock	0.6125	0.6234	0.6063	0.6063	174000.0
2001-03-09 09:00:00	CL	Stock	30.0	30.05	29.63	29.675	290600.0
2001-03-09 10:00:00	CL	Stock	29.675	29.68	29.25	29.325	340000.0
2001-03-09 11:00:00	CL	Stock	29.3	29.41	29.23	29.375	251000.0
2001-03-09 12:00:00	CL	Stock	29.355	29.375	29.215	29.35	184200.0
2001-03-09 13:00:00	CL	Stock	29.35	29.435	29.275	29.385	150400.0
2001-03-09 14:00:00	CL	Stock	29.39	29.46	29.1	29.15	237600.0
2001-03-09 15:00:00	CL	Stock	29.11	29.425	29.11	29.405	592400.0
2001-03-09 16:00:00	CL	Stock	29.4	29.45	29.4	29.45	122800.0

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

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