PREVIEW / stock_1hour / 2001-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-18.parquet
  size:    326 KB
  rows:    16,727
  symbols: 1,273

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-18 08:00:00	AAPL	Stock	0.3036	0.3192	0.3036	0.3158	8349600.0
2001-01-18 09:00:00	AAPL	Stock	0.3158	0.3203	0.3092	0.3192	180745600.0
2001-01-18 10:00:00	AAPL	Stock	0.3181	0.3259	0.3181	0.3237	236829600.0
2001-01-18 11:00:00	AAPL	Stock	0.3248	0.3248	0.3203	0.3225	143701600.0
2001-01-18 12:00:00	AAPL	Stock	0.3225	0.3237	0.3181	0.3203	85013600.0
2001-01-18 13:00:00	AAPL	Stock	0.3214	0.3248	0.3203	0.3237	83675200.0
2001-01-18 14:00:00	AAPL	Stock	0.3237	0.3292	0.3225	0.3259	117185600.0
2001-01-18 15:00:00	AAPL	Stock	0.327	0.3348	0.3259	0.3348	207144000.0
2001-01-18 16:00:00	AAPL	Stock	0.3343	0.3404	0.3225	0.3404	18765600.0
2001-01-18 17:00:00	AAPL	Stock	0.3393	0.3415	0.3337	0.3404	1534400.0
2001-01-18 18:00:00	AAPL	Stock	0.3404	0.3415	0.3393	0.3404	425600.0
2001-01-18 08:00:00	MSFT	Stock	26.875	26.875	26.4375	26.6562	183000.0
2001-01-18 09:00:00	MSFT	Stock	26.5312	27.0	26.375	26.4062	9088600.0
2001-01-18 10:00:00	MSFT	Stock	26.4062	27.2188	26.3125	27.1562	10649400.0
2001-01-18 11:00:00	MSFT	Stock	27.1562	27.625	27.1562	27.5625	15857800.0
2001-01-18 12:00:00	MSFT	Stock	27.5	27.875	27.4375	27.8438	12331000.0
2001-01-18 13:00:00	MSFT	Stock	27.8438	27.9375	27.625	27.875	10220200.0
2001-01-18 14:00:00	MSFT	Stock	27.875	28.0938	27.7188	27.8438	13238400.0
2001-01-18 15:00:00	MSFT	Stock	27.8125	28.0312	27.7188	27.7812	14524200.0
2001-01-18 16:00:00	MSFT	Stock	27.7969	29.125	27.3438	29.0	10610800.0
2001-01-18 17:00:00	MSFT	Stock	29.0625	29.5938	27.75	29.2812	3330800.0
2001-01-18 18:00:00	MSFT	Stock	29.3125	29.625	29.3125	29.5938	558000.0
2001-01-18 09:00:00	NVDA	Stock	0.1878	0.1932	0.1833	0.1854	50688000.0
2001-01-18 10:00:00	NVDA	Stock	0.1854	0.1938	0.1828	0.1927	104736000.0
2001-01-18 11:00:00	NVDA	Stock	0.1893	0.199	0.1893	0.1977	117432000.0
2001-01-18 12:00:00	NVDA	Stock	0.1974	0.2068	0.1974	0.2042	83928000.0
2001-01-18 13:00:00	NVDA	Stock	0.2042	0.2094	0.2021	0.2052	103368000.0
2001-01-18 14:00:00	NVDA	Stock	0.2047	0.2146	0.2034	0.213	99240000.0
2001-01-18 15:00:00	NVDA	Stock	0.2133	0.2281	0.2109	0.2219	221712000.0
2001-01-18 16:00:00	NVDA	Stock	0.2228	0.2292	0.2224	0.225	8880000.0
2001-01-18 17:00:00	NVDA	Stock	0.2271	0.2292	0.2271	0.2292	576000.0
2001-01-18 18:00:00	NVDA	Stock	0.2313	0.2313	0.2292	0.2292	312000.0
2001-01-18 08:00:00	AMZN	Stock	0.9172	0.9438	0.9156	0.925	388000.0
2001-01-18 09:00:00	AMZN	Stock	0.9219	0.925	0.8969	0.9	6030000.0
2001-01-18 10:00:00	AMZN	Stock	0.9	0.9219	0.8969	0.9156	10504000.0
2001-01-18 11:00:00	AMZN	Stock	0.9141	0.925	0.9062	0.9156	5870000.0
2001-01-18 12:00:00	AMZN	Stock	0.9141	0.9375	0.9062	0.925	8244000.0
2001-01-18 13:00:00	AMZN	Stock	0.9234	0.9375	0.9188	0.9281	6192000.0
2001-01-18 14:00:00	AMZN	Stock	0.9266	0.9438	0.925	0.9281	8186000.0
2001-01-18 15:00:00	AMZN	Stock	0.9281	0.975	0.925	0.9734	19960000.0
2001-01-18 16:00:00	AMZN	Stock	0.9734	1.0125	0.9219	1.0	5656000.0
2001-01-18 17:00:00	AMZN	Stock	1.0078	1.0375	1.0	1.025	1038000.0
2001-01-18 18:00:00	AMZN	Stock	1.025	1.0344	1.0125	1.025	78000.0
2001-01-18 09:00:00	CL	Stock	28.265	28.5	27.8	28.475	384400.0
2001-01-18 10:00:00	CL	Stock	28.5	28.8	28.265	28.795	555800.0
2001-01-18 11:00:00	CL	Stock	28.85	28.875	28.68	28.825	357200.0
2001-01-18 12:00:00	CL	Stock	28.825	29.045	28.8	28.835	271800.0
2001-01-18 13:00:00	CL	Stock	28.85	29.0	28.825	28.925	508800.0
2001-01-18 14:00:00	CL	Stock	28.925	28.95	28.565	28.625	338400.0
2001-01-18 15:00:00	CL	Stock	28.625	28.65	28.42	28.45	445200.0

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

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