PREVIEW / stock_1hour / 2000-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-05.parquet
  size:    276 KB
  rows:    14,095
  symbols: 1,157

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-05-05 09:00:00	AAPL	Stock	0.9894	1.0246	0.9886	1.0179	52404800.0
2000-05-05 10:00:00	AAPL	Stock	1.0162	1.0246	1.0112	1.0162	63369600.0
2000-05-05 11:00:00	AAPL	Stock	1.0156	1.0162	1.0106	1.0123	20260800.0
2000-05-05 12:00:00	AAPL	Stock	1.0128	1.0145	1.01	1.0123	20260800.0
2000-05-05 13:00:00	AAPL	Stock	1.0112	1.0201	1.0112	1.0145	15254400.0
2000-05-05 14:00:00	AAPL	Stock	1.0134	1.0234	1.0134	1.0223	31606400.0
2000-05-05 15:00:00	AAPL	Stock	1.0223	1.0234	1.0045	1.0109	67827200.0
2000-05-05 16:00:00	AAPL	Stock	1.0106	1.0112	1.01	1.01	168000.0
2000-05-05 09:00:00	MSFT	Stock	35.125	35.2188	34.9375	35.0312	7024400.0
2000-05-05 10:00:00	MSFT	Stock	35.0312	35.9062	34.9688	35.5312	8028600.0
2000-05-05 11:00:00	MSFT	Stock	35.5625	35.625	35.375	35.4375	4296800.0
2000-05-05 12:00:00	MSFT	Stock	35.4375	35.5938	35.375	35.4375	3651000.0
2000-05-05 13:00:00	MSFT	Stock	35.4375	35.75	35.4062	35.5938	2772600.0
2000-05-05 14:00:00	MSFT	Stock	35.5938	35.6875	35.5625	35.625	2661400.0
2000-05-05 15:00:00	MSFT	Stock	35.625	35.6875	35.3438	35.5625	5233000.0
2000-05-05 16:00:00	MSFT	Stock	35.5625	35.5625	35.5312	35.5625	373400.0
2000-05-05 09:00:00	NVDA	Stock	0.1827	0.1896	0.1802	0.188	38688000.0
2000-05-05 10:00:00	NVDA	Stock	0.1876	0.1964	0.1865	0.1891	55440000.0
2000-05-05 11:00:00	NVDA	Stock	0.1898	0.1906	0.1885	0.1896	14160000.0
2000-05-05 12:00:00	NVDA	Stock	0.1897	0.1906	0.1885	0.1898	9888000.0
2000-05-05 13:00:00	NVDA	Stock	0.1888	0.1911	0.1885	0.1911	7776000.0
2000-05-05 14:00:00	NVDA	Stock	0.1902	0.1945	0.1902	0.1932	14928000.0
2000-05-05 15:00:00	NVDA	Stock	0.1932	0.194	0.1896	0.1917	17856000.0
2000-05-05 16:00:00	NVDA	Stock	0.1919	0.1919	0.1919	0.1919	48000.0
2000-05-05 09:00:00	AMZN	Stock	2.7312	2.8	2.7063	2.7875	8198000.0
2000-05-05 10:00:00	AMZN	Stock	2.7875	2.8125	2.75	2.7688	14280000.0
2000-05-05 11:00:00	AMZN	Stock	2.775	2.8313	2.75	2.8156	9040000.0
2000-05-05 12:00:00	AMZN	Stock	2.8156	2.8938	2.8125	2.8719	12316000.0
2000-05-05 13:00:00	AMZN	Stock	2.875	2.9313	2.85	2.8875	12880000.0
2000-05-05 14:00:00	AMZN	Stock	2.8875	2.9062	2.8656	2.9	5848000.0
2000-05-05 15:00:00	AMZN	Stock	2.9	2.925	2.85	2.925	14252000.0
2000-05-05 16:00:00	AMZN	Stock	2.925	2.925	2.9219	2.925	524000.0
2000-05-05 09:00:00	CL	Stock	28.125	28.375	27.875	27.9375	363800.0
2000-05-05 10:00:00	CL	Stock	27.9375	28.4375	27.9062	28.3438	458800.0
2000-05-05 11:00:00	CL	Stock	28.3125	28.4375	28.0625	28.125	264600.0
2000-05-05 12:00:00	CL	Stock	28.0625	28.2812	28.0	28.0938	144800.0
2000-05-05 13:00:00	CL	Stock	28.0625	28.3438	28.0312	28.2188	173200.0
2000-05-05 14:00:00	CL	Stock	28.2188	28.4375	28.125	28.4062	113800.0
2000-05-05 15:00:00	CL	Stock	28.4062	29.0312	28.3125	28.5625	755000.0
2000-05-05 16:00:00	CL	Stock	28.5625	28.5625	28.5625	28.5625	39400.0

> showing 40 of 14,095 rows — these rows as CSV

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