PREVIEW / stock_1hour / 2000-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-16.parquet
  size:    297 KB
  rows:    15,486
  symbols: 1,237

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-10-16 08:00:00	AAPL	Stock	0.3906	0.3951	0.3906	0.3929	4508000.0
2000-10-16 09:00:00	AAPL	Stock	0.3929	0.4152	0.3912	0.4074	138611200.0
2000-10-16 10:00:00	AAPL	Stock	0.4063	0.4152	0.4018	0.4051	126268800.0
2000-10-16 11:00:00	AAPL	Stock	0.4051	0.4068	0.4007	0.4029	54560800.0
2000-10-16 12:00:00	AAPL	Stock	0.4018	0.404	0.394	0.3984	87068800.0
2000-10-16 13:00:00	AAPL	Stock	0.3973	0.4007	0.3895	0.3906	73309600.0
2000-10-16 14:00:00	AAPL	Stock	0.3906	0.3929	0.3862	0.3906	86833600.0
2000-10-16 15:00:00	AAPL	Stock	0.3917	0.3929	0.3817	0.3839	160008800.0
2000-10-16 16:00:00	AAPL	Stock	0.3839	0.4029	0.375	0.3839	26992000.0
2000-10-16 17:00:00	AAPL	Stock	0.3839	0.3884	0.3839	0.3839	134400.0
2000-10-16 18:00:00	AAPL	Stock	0.3884	0.3884	0.3884	0.3884	5600.0
2000-10-16 08:00:00	MSFT	Stock	27.125	27.25	26.8438	27.0	312000.0
2000-10-16 09:00:00	MSFT	Stock	27.0	27.0	26.0312	26.0312	11516400.0
2000-10-16 10:00:00	MSFT	Stock	26.0312	26.1875	25.2188	25.25	19691000.0
2000-10-16 11:00:00	MSFT	Stock	25.25	25.3125	25.125	25.2188	18587400.0
2000-10-16 12:00:00	MSFT	Stock	25.1875	25.3125	25.0	25.1562	11361400.0
2000-10-16 13:00:00	MSFT	Stock	25.1562	25.1875	24.7812	24.8438	16894800.0
2000-10-16 14:00:00	MSFT	Stock	24.8125	25.1562	24.8125	24.9062	14189000.0
2000-10-16 15:00:00	MSFT	Stock	24.9688	25.3125	24.7812	25.2188	16583000.0
2000-10-16 16:00:00	MSFT	Stock	25.2188	25.9062	24.9531	25.5625	4024800.0
2000-10-16 17:00:00	MSFT	Stock	25.5469	25.625	25.4375	25.5781	95800.0
2000-10-16 18:00:00	MSFT	Stock	25.5312	25.5938	25.4688	25.5	16000.0
2000-10-16 08:00:00	NVDA	Stock	0.2712	0.2719	0.2712	0.2719	1656000.0
2000-10-16 09:00:00	NVDA	Stock	0.2719	0.2719	0.2589	0.2695	41760000.0
2000-10-16 10:00:00	NVDA	Stock	0.269	0.2698	0.2617	0.2625	37512000.0
2000-10-16 11:00:00	NVDA	Stock	0.2625	0.2688	0.2604	0.2646	26640000.0
2000-10-16 12:00:00	NVDA	Stock	0.2641	0.2661	0.2604	0.2635	20688000.0
2000-10-16 13:00:00	NVDA	Stock	0.2635	0.2643	0.2615	0.2628	42816000.0
2000-10-16 14:00:00	NVDA	Stock	0.2628	0.2685	0.2625	0.2659	60936000.0
2000-10-16 15:00:00	NVDA	Stock	0.2656	0.2677	0.2641	0.2646	67896000.0
2000-10-16 16:00:00	NVDA	Stock	0.2651	0.2661	0.2646	0.2646	2832000.0
2000-10-16 08:00:00	AMZN	Stock	1.3531	1.5	1.3516	1.4031	82000.0
2000-10-16 09:00:00	AMZN	Stock	1.4	1.4219	1.3188	1.35	14412000.0
2000-10-16 10:00:00	AMZN	Stock	1.35	1.3563	1.3094	1.3156	10214000.0
2000-10-16 11:00:00	AMZN	Stock	1.3125	1.3156	1.2656	1.2938	18776000.0
2000-10-16 12:00:00	AMZN	Stock	1.2938	1.2938	1.2594	1.2688	12876000.0
2000-10-16 13:00:00	AMZN	Stock	1.2672	1.2812	1.2313	1.2313	13882000.0
2000-10-16 14:00:00	AMZN	Stock	1.2375	1.2562	1.2188	1.2469	19876000.0
2000-10-16 15:00:00	AMZN	Stock	1.2469	1.2594	1.2062	1.2156	30492000.0
2000-10-16 16:00:00	AMZN	Stock	1.2156	1.3203	1.2125	1.2469	2114000.0
2000-10-16 17:00:00	AMZN	Stock	1.2156	1.2469	1.2156	1.2469	54000.0
2000-10-16 18:00:00	AMZN	Stock	1.2469	1.25	1.2469	1.2469	10000.0
2000-10-16 09:00:00	CL	Stock	24.9	25.15	24.9	25.025	335000.0
2000-10-16 10:00:00	CL	Stock	25.025	25.195	24.975	25.16	444000.0
2000-10-16 11:00:00	CL	Stock	25.155	25.475	25.13	25.475	509200.0
2000-10-16 12:00:00	CL	Stock	25.475	25.95	25.475	25.86	796600.0
2000-10-16 13:00:00	CL	Stock	25.865	26.0	25.8	25.91	342600.0
2000-10-16 14:00:00	CL	Stock	25.905	25.99	25.83	25.955	361000.0
2000-10-16 15:00:00	CL	Stock	25.95	26.015	25.84	25.84	878600.0
2000-10-16 16:00:00	CL	Stock	25.825	25.865	25.795	25.865	915800.0

> showing 50 of 15,486 rows — these rows as CSV

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