PREVIEW / stock_1hour / 2001-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-08.parquet
  size:    310 KB
  rows:    16,233
  symbols: 1,255

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-01-08 08:00:00	AAPL	Stock	0.2946	0.3025	0.2924	0.2946	425600.0
2001-01-08 09:00:00	AAPL	Stock	0.2946	0.3036	0.2924	0.2969	35369600.0
2001-01-08 10:00:00	AAPL	Stock	0.2958	0.298	0.2879	0.2935	48916000.0
2001-01-08 11:00:00	AAPL	Stock	0.2946	0.298	0.2891	0.2935	31724000.0
2001-01-08 12:00:00	AAPL	Stock	0.2935	0.298	0.2868	0.2879	77632800.0
2001-01-08 13:00:00	AAPL	Stock	0.2879	0.2924	0.2846	0.2868	70347200.0
2001-01-08 14:00:00	AAPL	Stock	0.2879	0.2879	0.2846	0.2868	28823200.0
2001-01-08 15:00:00	AAPL	Stock	0.2857	0.2969	0.2846	0.2969	38976000.0
2001-01-08 16:00:00	AAPL	Stock	0.2969	0.298	0.2852	0.298	10920000.0
2001-01-08 17:00:00	AAPL	Stock	0.2958	0.3002	0.2946	0.2958	1114400.0
2001-01-08 18:00:00	AAPL	Stock	0.2958	0.298	0.2958	0.298	207200.0
2001-01-08 08:00:00	MSFT	Stock	24.75	24.75	24.0	24.25	234600.0
2001-01-08 09:00:00	MSFT	Stock	24.2812	24.875	24.25	24.4375	11216400.0
2001-01-08 10:00:00	MSFT	Stock	24.4375	24.6875	24.1875	24.3438	11131200.0
2001-01-08 11:00:00	MSFT	Stock	24.3438	24.4062	23.8125	23.875	8407600.0
2001-01-08 12:00:00	MSFT	Stock	23.8438	24.1875	23.3438	23.375	6987600.0
2001-01-08 13:00:00	MSFT	Stock	23.375	24.2188	23.375	23.9531	10573400.0
2001-01-08 14:00:00	MSFT	Stock	23.9531	24.0312	23.5	23.5625	7219600.0
2001-01-08 15:00:00	MSFT	Stock	23.5625	24.5	23.4062	24.5	14342000.0
2001-01-08 16:00:00	MSFT	Stock	24.5	24.75	23.875	24.7344	3430200.0
2001-01-08 17:00:00	MSFT	Stock	24.625	24.7344	23.75	24.6562	70200.0
2001-01-08 18:00:00	MSFT	Stock	24.5625	24.6562	24.5625	24.6562	12800.0
2001-01-08 08:00:00	NVDA	Stock	0.1547	0.1547	0.1547	0.1547	240000.0
2001-01-08 09:00:00	NVDA	Stock	0.1521	0.1635	0.15	0.1552	49296000.0
2001-01-08 10:00:00	NVDA	Stock	0.1552	0.1685	0.1542	0.1677	71832000.0
2001-01-08 11:00:00	NVDA	Stock	0.1677	0.1719	0.1656	0.168	87744000.0
2001-01-08 12:00:00	NVDA	Stock	0.168	0.176	0.1625	0.1643	76584000.0
2001-01-08 13:00:00	NVDA	Stock	0.1643	0.1688	0.1609	0.1646	81240000.0
2001-01-08 14:00:00	NVDA	Stock	0.1646	0.1667	0.1589	0.1607	35688000.0
2001-01-08 15:00:00	NVDA	Stock	0.1607	0.1708	0.1578	0.1693	113640000.0
2001-01-08 16:00:00	NVDA	Stock	0.1693	0.1708	0.1656	0.1708	6000000.0
2001-01-08 08:00:00	AMZN	Stock	0.75	0.75	0.7094	0.7313	158000.0
2001-01-08 09:00:00	AMZN	Stock	0.7281	0.7781	0.7219	0.7375	20680000.0
2001-01-08 10:00:00	AMZN	Stock	0.7375	0.7563	0.7094	0.725	19526000.0
2001-01-08 11:00:00	AMZN	Stock	0.7219	0.7375	0.7031	0.725	8594000.0
2001-01-08 12:00:00	AMZN	Stock	0.7234	0.7281	0.6906	0.7	10034000.0
2001-01-08 13:00:00	AMZN	Stock	0.7	0.7281	0.6969	0.7188	9448000.0
2001-01-08 14:00:00	AMZN	Stock	0.7188	0.7219	0.6906	0.6938	15074000.0
2001-01-08 15:00:00	AMZN	Stock	0.6938	0.7531	0.6875	0.75	31546000.0
2001-01-08 16:00:00	AMZN	Stock	0.75	0.8625	0.7125	0.75	43290000.0
2001-01-08 17:00:00	AMZN	Stock	0.7578	0.875	0.725	0.75	29072000.0
2001-01-08 18:00:00	AMZN	Stock	0.75	0.7594	0.7469	0.75	3630000.0
2001-01-08 09:00:00	CL	Stock	28.805	29.245	28.805	29.0	525800.0
2001-01-08 10:00:00	CL	Stock	29.005	29.35	28.94	29.305	842200.0
2001-01-08 11:00:00	CL	Stock	29.285	29.65	29.25	29.425	642000.0
2001-01-08 12:00:00	CL	Stock	29.43	29.49	29.2	29.25	293800.0
2001-01-08 13:00:00	CL	Stock	29.25	29.4	29.05	29.085	402000.0
2001-01-08 14:00:00	CL	Stock	29.05	29.35	29.0	29.35	352200.0
2001-01-08 15:00:00	CL	Stock	29.35	29.575	29.25	29.425	1209600.0
2001-01-08 16:00:00	CL	Stock	29.42	29.43	29.42	29.43	58000.0

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

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