PREVIEW / stock_1hour / 2002-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-17.parquet
  size:    409 KB
  rows:    18,865
  symbols: 1,405

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
2002-04-17 08:00:00	AAPL	Stock	0.4634	0.465	0.4625	0.4625	1943200.0
2002-04-17 09:00:00	AAPL	Stock	0.4618	0.4638	0.4532	0.4595	45460800.0
2002-04-17 10:00:00	AAPL	Stock	0.4595	0.4602	0.4545	0.458	59343200.0
2002-04-17 11:00:00	AAPL	Stock	0.4577	0.4596	0.4563	0.4588	21156800.0
2002-04-17 12:00:00	AAPL	Stock	0.4589	0.4607	0.458	0.4605	17438400.0
2002-04-17 13:00:00	AAPL	Stock	0.4607	0.4638	0.4593	0.4623	31085600.0
2002-04-17 14:00:00	AAPL	Stock	0.4621	0.4641	0.4588	0.4634	30256800.0
2002-04-17 15:00:00	AAPL	Stock	0.463	0.4673	0.4598	0.4661	118776000.0
2002-04-17 16:00:00	AAPL	Stock	0.4663	0.4713	0.4527	0.4607	34087200.0
2002-04-17 17:00:00	AAPL	Stock	0.4595	0.4663	0.4575	0.4607	21056000.0
2002-04-17 18:00:00	AAPL	Stock	0.4605	0.4663	0.458	0.4621	504000.0
2002-04-17 08:00:00	MSFT	Stock	29.2	29.25	28.94	28.97	190400.0
2002-04-17 09:00:00	MSFT	Stock	29.0	29.14	28.535	28.575	8734200.0
2002-04-17 10:00:00	MSFT	Stock	28.585	28.9	28.37	28.665	12246400.0
2002-04-17 11:00:00	MSFT	Stock	28.69	28.695	28.475	28.605	5641200.0
2002-04-17 12:00:00	MSFT	Stock	28.605	28.6555	28.36	28.56	4789400.0
2002-04-17 13:00:00	MSFT	Stock	28.555	28.58	28.425	28.505	3418800.0
2002-04-17 14:00:00	MSFT	Stock	28.505	28.525	28.23	28.35	5030000.0
2002-04-17 15:00:00	MSFT	Stock	28.35	28.425	28.21	28.32	9498200.0
2002-04-17 16:00:00	MSFT	Stock	28.315	28.5388	28.295	28.3	1687000.0
2002-04-17 17:00:00	MSFT	Stock	28.315	28.45	28.275	28.325	418800.0
2002-04-17 18:00:00	MSFT	Stock	28.345	28.35	28.315	28.35	62600.0
2002-04-17 08:00:00	NVDA	Stock	0.3337	0.3408	0.3329	0.3375	1092000.0
2002-04-17 09:00:00	NVDA	Stock	0.3375	0.3407	0.3252	0.3299	194436000.0
2002-04-17 10:00:00	NVDA	Stock	0.3298	0.3387	0.3278	0.3349	237828000.0
2002-04-17 11:00:00	NVDA	Stock	0.335	0.3358	0.3307	0.3347	72588000.0
2002-04-17 12:00:00	NVDA	Stock	0.3348	0.3351	0.3323	0.3339	63756000.0
2002-04-17 13:00:00	NVDA	Stock	0.3344	0.3354	0.3309	0.3346	67620000.0
2002-04-17 14:00:00	NVDA	Stock	0.3348	0.3383	0.3317	0.3383	112764000.0
2002-04-17 15:00:00	NVDA	Stock	0.3384	0.3385	0.3352	0.3358	143088000.0
2002-04-17 16:00:00	NVDA	Stock	0.3357	0.3368	0.3337	0.3337	10704000.0
2002-04-17 17:00:00	NVDA	Stock	0.3357	0.3365	0.3346	0.3365	1800000.0
2002-04-17 18:00:00	NVDA	Stock	0.3357	0.3366	0.3338	0.3338	444000.0
2002-04-17 08:00:00	AMZN	Stock	0.712	0.712	0.7075	0.71	112000.0
2002-04-17 09:00:00	AMZN	Stock	0.71	0.725	0.71	0.724	29402000.0
2002-04-17 10:00:00	AMZN	Stock	0.724	0.7485	0.7225	0.7455	29368000.0
2002-04-17 11:00:00	AMZN	Stock	0.746	0.75	0.739	0.742	20362000.0
2002-04-17 12:00:00	AMZN	Stock	0.7425	0.7425	0.7315	0.7321	11502000.0
2002-04-17 13:00:00	AMZN	Stock	0.732	0.7325	0.7275	0.73	9578000.0
2002-04-17 14:00:00	AMZN	Stock	0.73	0.737	0.721	0.734	15654000.0
2002-04-17 15:00:00	AMZN	Stock	0.734	0.7445	0.731	0.7445	26054000.0
2002-04-17 16:00:00	AMZN	Stock	0.7445	0.747	0.735	0.735	6870000.0
2002-04-17 17:00:00	AMZN	Stock	0.741	0.741	0.741	0.741	534000.0
2002-04-17 18:00:00	AMZN	Stock	0.741	0.741	0.741	0.741	78000.0
2002-04-17 09:00:00	CL	Stock	29.175	29.4	29.175	29.375	346600.0
2002-04-17 10:00:00	CL	Stock	29.38	29.38	29.15	29.185	964800.0
2002-04-17 11:00:00	CL	Stock	29.195	29.195	28.8	28.825	791000.0
2002-04-17 12:00:00	CL	Stock	28.82	29.0	28.82	28.965	344400.0
2002-04-17 13:00:00	CL	Stock	28.965	29.05	28.905	29.035	418000.0
2002-04-17 14:00:00	CL	Stock	29.035	29.035	28.875	29.0	363800.0

> showing 50 of 18,865 rows — these rows as CSV

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