PREVIEW / stock_1hour / 2001-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-02-23.parquet
  size:    353 KB
  rows:    16,568
  symbols: 1,271

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-02-23 08:00:00	AAPL	Stock	0.3292	0.3304	0.327	0.327	50400.0
2001-02-23 09:00:00	AAPL	Stock	0.3304	0.3371	0.3292	0.3337	21896000.0
2001-02-23 10:00:00	AAPL	Stock	0.3337	0.3348	0.3304	0.3326	30307200.0
2001-02-23 11:00:00	AAPL	Stock	0.3326	0.3348	0.3292	0.3292	36971200.0
2001-02-23 12:00:00	AAPL	Stock	0.3292	0.3326	0.327	0.3304	32681600.0
2001-02-23 13:00:00	AAPL	Stock	0.3315	0.3315	0.3259	0.3292	16178400.0
2001-02-23 14:00:00	AAPL	Stock	0.3292	0.3337	0.3276	0.3315	41143200.0
2001-02-23 15:00:00	AAPL	Stock	0.3292	0.3359	0.3281	0.3359	98666400.0
2001-02-23 16:00:00	AAPL	Stock	0.3348	0.3371	0.3337	0.3359	8377600.0
2001-02-23 17:00:00	AAPL	Stock	0.3348	0.3348	0.3348	0.3348	179200.0
2001-02-23 08:00:00	MSFT	Stock	27.4688	27.5938	27.0938	27.25	416000.0
2001-02-23 09:00:00	MSFT	Stock	27.1875	28.1875	27.0938	27.9844	14852600.0
2001-02-23 10:00:00	MSFT	Stock	28.0	28.4688	27.6562	27.9688	18637200.0
2001-02-23 11:00:00	MSFT	Stock	27.9688	28.5	27.9375	28.1875	9893800.0
2001-02-23 12:00:00	MSFT	Stock	28.1875	28.25	27.625	28.0	9321600.0
2001-02-23 13:00:00	MSFT	Stock	28.0	28.0469	27.6875	27.7812	7146600.0
2001-02-23 14:00:00	MSFT	Stock	27.7812	28.1875	27.6562	27.75	11269800.0
2001-02-23 15:00:00	MSFT	Stock	27.7812	28.75	27.5625	28.4062	14367000.0
2001-02-23 16:00:00	MSFT	Stock	28.4062	28.5	28.0156	28.3438	2351800.0
2001-02-23 17:00:00	MSFT	Stock	28.3438	28.375	28.3125	28.3125	56800.0
2001-02-23 18:00:00	MSFT	Stock	28.375	28.375	28.3125	28.3125	3600.0
2001-02-23 08:00:00	NVDA	Stock	0.2385	0.2385	0.2375	0.2375	48000.0
2001-02-23 09:00:00	NVDA	Stock	0.2389	0.2458	0.2389	0.2417	66552000.0
2001-02-23 10:00:00	NVDA	Stock	0.2415	0.2422	0.2299	0.2307	168624000.0
2001-02-23 11:00:00	NVDA	Stock	0.2313	0.232	0.2229	0.224	196728000.0
2001-02-23 12:00:00	NVDA	Stock	0.224	0.2271	0.2188	0.225	143208000.0
2001-02-23 13:00:00	NVDA	Stock	0.2263	0.2294	0.2198	0.2211	62592000.0
2001-02-23 14:00:00	NVDA	Stock	0.2212	0.2305	0.2203	0.2283	157128000.0
2001-02-23 15:00:00	NVDA	Stock	0.2284	0.232	0.2245	0.2264	159336000.0
2001-02-23 16:00:00	NVDA	Stock	0.2268	0.2273	0.2198	0.2264	22656000.0
2001-02-23 17:00:00	NVDA	Stock	0.2276	0.2276	0.2276	0.2276	120000.0
2001-02-23 18:00:00	NVDA	Stock	0.2292	0.2292	0.2292	0.2292	48000.0
2001-02-23 08:00:00	AMZN	Stock	0.5875	0.5969	0.575	0.575	38000.0
2001-02-23 09:00:00	AMZN	Stock	0.5938	0.6	0.575	0.5812	8838000.0
2001-02-23 10:00:00	AMZN	Stock	0.5844	0.5875	0.575	0.5781	14294000.0
2001-02-23 11:00:00	AMZN	Stock	0.5781	0.5812	0.5656	0.5688	15194000.0
2001-02-23 12:00:00	AMZN	Stock	0.5688	0.5812	0.5531	0.5594	15190000.0
2001-02-23 13:00:00	AMZN	Stock	0.5562	0.5719	0.5562	0.5625	7160000.0
2001-02-23 14:00:00	AMZN	Stock	0.5625	0.5906	0.5594	0.5812	14482000.0
2001-02-23 15:00:00	AMZN	Stock	0.5781	0.6031	0.5781	0.5938	22480000.0
2001-02-23 16:00:00	AMZN	Stock	0.5906	0.6	0.5594	0.5938	1600000.0
2001-02-23 17:00:00	AMZN	Stock	0.5906	0.5969	0.5906	0.5938	114000.0
2001-02-23 18:00:00	AMZN	Stock	0.575	0.575	0.575	0.575	8000.0
2001-02-23 09:00:00	CL	Stock	29.5	29.545	29.335	29.36	259000.0
2001-02-23 10:00:00	CL	Stock	29.35	29.45	28.7	29.15	481600.0
2001-02-23 11:00:00	CL	Stock	29.15	29.245	29.005	29.065	296800.0
2001-02-23 12:00:00	CL	Stock	29.055	29.075	28.9	29.0	280600.0
2001-02-23 13:00:00	CL	Stock	28.995	28.995	28.81	28.9	232000.0
2001-02-23 14:00:00	CL	Stock	28.9	29.0	28.785	28.96	476200.0
2001-02-23 15:00:00	CL	Stock	28.96	29.4	28.925	29.195	625000.0

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

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