PREVIEW / stock_1hour / 2001-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-09.parquet
  size:    311 KB
  rows:    16,069
  symbols: 1,259

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-09 08:00:00	AAPL	Stock	0.298	0.2991	0.2913	0.2913	845600.0
2001-01-09 09:00:00	AAPL	Stock	0.2958	0.3036	0.2958	0.2991	36388800.0
2001-01-09 10:00:00	AAPL	Stock	0.2991	0.3103	0.2991	0.3047	59634400.0
2001-01-09 11:00:00	AAPL	Stock	0.3047	0.308	0.3013	0.3069	42140000.0
2001-01-09 12:00:00	AAPL	Stock	0.3058	0.3069	0.2958	0.3013	37979200.0
2001-01-09 13:00:00	AAPL	Stock	0.3025	0.3147	0.3002	0.3125	168548800.0
2001-01-09 14:00:00	AAPL	Stock	0.3125	0.3136	0.3047	0.3119	92752800.0
2001-01-09 15:00:00	AAPL	Stock	0.3114	0.3136	0.3047	0.3058	83479200.0
2001-01-09 16:00:00	AAPL	Stock	0.3069	0.3103	0.3036	0.3092	14834400.0
2001-01-09 17:00:00	AAPL	Stock	0.3069	0.3069	0.3047	0.3069	1540000.0
2001-01-09 18:00:00	AAPL	Stock	0.3047	0.3058	0.3047	0.3058	39200.0
2001-01-09 08:00:00	MSFT	Stock	24.3125	24.5625	24.25	24.5	55600.0
2001-01-09 09:00:00	MSFT	Stock	24.5	25.9375	24.5	25.7188	20169200.0
2001-01-09 10:00:00	MSFT	Stock	25.6875	25.9688	25.5	25.9062	20760800.0
2001-01-09 11:00:00	MSFT	Stock	25.875	26.2188	25.7188	25.9688	17206800.0
2001-01-09 12:00:00	MSFT	Stock	25.9375	26.0625	25.7188	25.9062	7869400.0
2001-01-09 13:00:00	MSFT	Stock	25.9062	26.25	25.7188	25.9062	9928000.0
2001-01-09 14:00:00	MSFT	Stock	25.9062	26.2812	25.75	26.25	9116600.0
2001-01-09 15:00:00	MSFT	Stock	26.25	26.3125	25.75	25.9062	14942400.0
2001-01-09 16:00:00	MSFT	Stock	25.9062	26.0469	24.9688	25.6875	3305800.0
2001-01-09 17:00:00	MSFT	Stock	25.7812	25.9688	25.75	25.8125	696600.0
2001-01-09 18:00:00	MSFT	Stock	25.75	25.7812	25.75	25.75	3200.0
2001-01-09 09:00:00	NVDA	Stock	0.1716	0.1716	0.1659	0.1688	38448000.0
2001-01-09 10:00:00	NVDA	Stock	0.1688	0.176	0.1685	0.1732	50568000.0
2001-01-09 11:00:00	NVDA	Stock	0.1729	0.1734	0.1667	0.1701	37032000.0
2001-01-09 12:00:00	NVDA	Stock	0.1698	0.1714	0.1641	0.1659	19032000.0
2001-01-09 13:00:00	NVDA	Stock	0.1659	0.1706	0.1633	0.1695	26304000.0
2001-01-09 14:00:00	NVDA	Stock	0.1695	0.174	0.1681	0.174	39288000.0
2001-01-09 15:00:00	NVDA	Stock	0.174	0.1742	0.1703	0.1729	53592000.0
2001-01-09 16:00:00	NVDA	Stock	0.1727	0.1729	0.1698	0.1729	2808000.0
2001-01-09 17:00:00	NVDA	Stock	0.1729	0.1729	0.1729	0.1729	216000.0
2001-01-09 08:00:00	AMZN	Stock	0.7125	0.7625	0.6562	0.7	8564000.0
2001-01-09 09:00:00	AMZN	Stock	0.7062	0.7781	0.6875	0.7656	91104000.0
2001-01-09 10:00:00	AMZN	Stock	0.7656	0.8031	0.7438	0.7594	93352000.0
2001-01-09 11:00:00	AMZN	Stock	0.7594	0.7859	0.7469	0.7688	41560000.0
2001-01-09 12:00:00	AMZN	Stock	0.7688	0.775	0.7531	0.7719	22334000.0
2001-01-09 13:00:00	AMZN	Stock	0.7719	0.7844	0.7688	0.775	23474000.0
2001-01-09 14:00:00	AMZN	Stock	0.775	0.8	0.7688	0.7969	43526000.0
2001-01-09 15:00:00	AMZN	Stock	0.7969	0.8312	0.7844	0.8188	99516000.0
2001-01-09 16:00:00	AMZN	Stock	0.8156	0.825	0.7219	0.8125	3578000.0
2001-01-09 17:00:00	AMZN	Stock	0.8094	0.8125	0.8031	0.8031	180000.0
2001-01-09 18:00:00	AMZN	Stock	0.8188	0.8188	0.8062	0.8062	44000.0
2001-01-09 09:00:00	CL	Stock	29.625	29.72	29.34	29.4	714600.0
2001-01-09 10:00:00	CL	Stock	29.38	29.38	28.975	29.145	1024400.0
2001-01-09 11:00:00	CL	Stock	29.145	29.525	29.145	29.49	630600.0
2001-01-09 12:00:00	CL	Stock	29.485	29.575	29.4	29.525	451000.0
2001-01-09 13:00:00	CL	Stock	29.53	29.71	29.42	29.65	347800.0
2001-01-09 14:00:00	CL	Stock	29.61	30.075	29.55	29.93	672800.0
2001-01-09 15:00:00	CL	Stock	29.93	29.98	29.825	29.955	683400.0
2001-01-09 16:00:00	CL	Stock	29.945	29.975	29.945	29.955	175600.0

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

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