PREVIEW / stock_1hour / 2001-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-05.parquet
  size:    364 KB
  rows:    17,171
  symbols: 1,329

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-09-05 08:00:00	AAPL	Stock	0.326	0.3273	0.326	0.3273	319200.0
2001-09-05 09:00:00	AAPL	Stock	0.3259	0.3384	0.3257	0.3375	38007200.0
2001-09-05 10:00:00	AAPL	Stock	0.3375	0.3375	0.3292	0.3316	54471200.0
2001-09-05 11:00:00	AAPL	Stock	0.3319	0.3338	0.3295	0.3316	29825600.0
2001-09-05 12:00:00	AAPL	Stock	0.3316	0.3346	0.3302	0.3302	31416000.0
2001-09-05 13:00:00	AAPL	Stock	0.3302	0.3304	0.3236	0.3271	90636000.0
2001-09-05 14:00:00	AAPL	Stock	0.3277	0.3333	0.3243	0.3291	35140000.0
2001-09-05 15:00:00	AAPL	Stock	0.3291	0.3313	0.3245	0.3313	47622400.0
2001-09-05 16:00:00	AAPL	Stock	0.3313	0.333	0.3245	0.327	4978400.0
2001-09-05 17:00:00	AAPL	Stock	0.3313	0.3313	0.3313	0.3313	739200.0
2001-09-05 08:00:00	MSFT	Stock	28.0	28.18	28.0	28.15	87400.0
2001-09-05 09:00:00	MSFT	Stock	28.15	28.4855	27.96	28.225	10390600.0
2001-09-05 10:00:00	MSFT	Stock	28.225	28.45	27.97	28.225	11594600.0
2001-09-05 11:00:00	MSFT	Stock	28.235	28.33	27.99	28.09	6296800.0
2001-09-05 12:00:00	MSFT	Stock	28.085	28.115	27.88	27.925	7582400.0
2001-09-05 13:00:00	MSFT	Stock	27.925	28.275	27.645	28.175	9917000.0
2001-09-05 14:00:00	MSFT	Stock	28.2255	29.195	28.0	28.705	18224600.0
2001-09-05 15:00:00	MSFT	Stock	28.71	29.015	28.4995	28.875	18600000.0
2001-09-05 16:00:00	MSFT	Stock	28.865	29.195	27.695	28.845	2139800.0
2001-09-05 17:00:00	MSFT	Stock	28.84	28.875	28.84	28.875	187200.0
2001-09-05 18:00:00	MSFT	Stock	28.875	28.885	28.865	28.885	5800.0
2001-09-05 08:00:00	NVDA	Stock	0.3279	0.3304	0.3279	0.329	1608000.0
2001-09-05 09:00:00	NVDA	Stock	0.3292	0.3338	0.3229	0.3305	371568000.0
2001-09-05 10:00:00	NVDA	Stock	0.3307	0.3318	0.3221	0.3292	393768000.0
2001-09-05 11:00:00	NVDA	Stock	0.3292	0.3306	0.325	0.327	161976000.0
2001-09-05 12:00:00	NVDA	Stock	0.327	0.327	0.3178	0.3199	184584000.0
2001-09-05 13:00:00	NVDA	Stock	0.3199	0.3243	0.3148	0.323	306096000.0
2001-09-05 14:00:00	NVDA	Stock	0.3228	0.3379	0.3212	0.3334	436272000.0
2001-09-05 15:00:00	NVDA	Stock	0.3335	0.3371	0.3285	0.3354	409200000.0
2001-09-05 16:00:00	NVDA	Stock	0.3355	0.3367	0.315	0.3344	19968000.0
2001-09-05 17:00:00	NVDA	Stock	0.3354	0.3355	0.3354	0.3355	504000.0
2001-09-05 18:00:00	NVDA	Stock	0.3369	0.3371	0.3369	0.3371	120000.0
2001-09-05 09:00:00	AMZN	Stock	0.434	0.434	0.41	0.412	10558000.0
2001-09-05 10:00:00	AMZN	Stock	0.4115	0.4125	0.386	0.396	45226000.0
2001-09-05 11:00:00	AMZN	Stock	0.396	0.396	0.3425	0.344	87200000.0
2001-09-05 12:00:00	AMZN	Stock	0.344	0.3655	0.3425	0.36	44718000.0
2001-09-05 13:00:00	AMZN	Stock	0.36	0.393	0.358	0.3825	68242000.0
2001-09-05 14:00:00	AMZN	Stock	0.383	0.4095	0.344	0.398	38698000.0
2001-09-05 15:00:00	AMZN	Stock	0.398	0.3995	0.3805	0.381	39446000.0
2001-09-05 16:00:00	AMZN	Stock	0.381	0.3945	0.3675	0.3835	48302000.0
2001-09-05 17:00:00	AMZN	Stock	0.3825	0.385	0.3825	0.385	152000.0
2001-09-05 18:00:00	AMZN	Stock	0.385	0.3875	0.385	0.3875	22000.0
2001-09-05 09:00:00	CL	Stock	27.4	27.4	27.005	27.325	381800.0
2001-09-05 10:00:00	CL	Stock	27.325	27.75	27.155	27.75	1111800.0
2001-09-05 11:00:00	CL	Stock	27.725	28.0	27.725	27.9	992000.0
2001-09-05 12:00:00	CL	Stock	27.89	28.025	27.815	27.99	669800.0
2001-09-05 13:00:00	CL	Stock	27.975	28.025	27.85	27.865	584200.0
2001-09-05 14:00:00	CL	Stock	27.865	28.1	27.865	27.94	724400.0
2001-09-05 15:00:00	CL	Stock	27.94	27.97	27.75	27.87	1377800.0
2001-09-05 16:00:00	CL	Stock	27.87	27.91	27.815	27.865	295800.0

> showing 50 of 17,171 rows — these rows as CSV

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