PREVIEW / stock_1hour / 2006-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-15.parquet
  size:    609 KB
  rows:    29,010
  symbols: 2,289

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
2006-06-15 05:00:00	AAPL	Stock	2.0571	2.0571	2.0571	2.0571	98000.0
2006-06-15 06:00:00	AAPL	Stock	2.0589	2.0643	2.0571	2.0643	74088.0
2006-06-15 07:00:00	AAPL	Stock	2.0643	2.0661	2.0518	2.0518	232400.0
2006-06-15 08:00:00	AAPL	Stock	2.0571	2.0768	2.0471	2.0646	4903584.0
2006-06-15 09:00:00	AAPL	Stock	2.0632	2.0661	2.0268	2.0361	163883272.0
2006-06-15 10:00:00	AAPL	Stock	2.0357	2.0821	2.035	2.0604	244020420.0
2006-06-15 11:00:00	AAPL	Stock	2.0604	2.0679	2.0504	2.0571	98759080.0
2006-06-15 12:00:00	AAPL	Stock	2.0571	2.0571	2.0446	2.0507	65290400.0
2006-06-15 13:00:00	AAPL	Stock	2.0507	2.0804	2.0446	2.0779	108658200.0
2006-06-15 14:00:00	AAPL	Stock	2.0779	2.1243	2.0768	2.1229	259129640.0
2006-06-15 15:00:00	AAPL	Stock	2.1232	2.1336	2.1132	2.1211	227611076.0
2006-06-15 16:00:00	AAPL	Stock	2.12	2.125	2.1171	2.1211	2628528.0
2006-06-15 17:00:00	AAPL	Stock	2.1211	2.1221	2.1146	2.1214	1733536.0
2006-06-15 18:00:00	AAPL	Stock	2.1211	2.1232	2.1211	2.1232	112084.0
2006-06-15 07:00:00	MSFT	Stock	22.01	22.1	22.01	22.05	24941.0
2006-06-15 08:00:00	MSFT	Stock	22.05	22.09	21.88	22.01	10274270.0
2006-06-15 09:00:00	MSFT	Stock	22.02	22.05	21.85	21.929	10217452.0
2006-06-15 10:00:00	MSFT	Stock	21.92	22.05	21.91	22.04	17586270.0
2006-06-15 11:00:00	MSFT	Stock	22.04	22.13	21.96	21.98	13526087.0
2006-06-15 12:00:00	MSFT	Stock	21.98	22.05	21.85	21.88	8436692.0
2006-06-15 13:00:00	MSFT	Stock	21.88	21.89	21.8	21.86	6849780.0
2006-06-15 14:00:00	MSFT	Stock	21.86	21.99	21.8	21.96	12393493.0
2006-06-15 15:00:00	MSFT	Stock	21.95	22.09	21.86	22.09	23749408.0
2006-06-15 16:00:00	MSFT	Stock	22.04	22.7	21.5	21.98	13920260.0
2006-06-15 17:00:00	MSFT	Stock	21.97	22.07	21.93	21.96	1287645.0
2006-06-15 18:00:00	MSFT	Stock	21.96	22.05	21.96	21.98	76855.0
2006-06-15 04:00:00	NVDA	Stock	0.3472	0.3472	0.3472	0.3472	54000.0
2006-06-15 05:00:00	NVDA	Stock	0.349	0.3507	0.349	0.3507	174000.0
2006-06-15 07:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	60000.0
2006-06-15 08:00:00	NVDA	Stock	0.3508	0.3533	0.3485	0.353	5799000.0
2006-06-15 09:00:00	NVDA	Stock	0.3528	0.3633	0.3407	0.3621	148783980.0
2006-06-15 10:00:00	NVDA	Stock	0.3622	0.3647	0.3603	0.3638	113719020.0
2006-06-15 11:00:00	NVDA	Stock	0.364	0.3675	0.3633	0.3658	107094780.0
2006-06-15 12:00:00	NVDA	Stock	0.3657	0.3663	0.3633	0.3653	60300180.0
2006-06-15 13:00:00	NVDA	Stock	0.3655	0.3658	0.3615	0.3648	70984440.0
2006-06-15 14:00:00	NVDA	Stock	0.365	0.3687	0.364	0.3682	116717880.0
2006-06-15 15:00:00	NVDA	Stock	0.3683	0.3717	0.3663	0.3705	197410380.0
2006-06-15 16:00:00	NVDA	Stock	0.3697	0.3717	0.3697	0.3708	890340.0
2006-06-15 17:00:00	NVDA	Stock	0.3715	0.3747	0.37	0.374	316800.0
2006-06-15 08:00:00	AMZN	Stock	1.6875	1.6875	1.6875	1.6875	19400.0
2006-06-15 09:00:00	AMZN	Stock	1.6865	1.6995	1.686	1.6975	11172780.0
2006-06-15 10:00:00	AMZN	Stock	1.698	1.7015	1.6835	1.6975	12293320.0
2006-06-15 11:00:00	AMZN	Stock	1.698	1.71	1.6975	1.704	15012740.0
2006-06-15 12:00:00	AMZN	Stock	1.7035	1.706	1.7015	1.7045	9337000.0
2006-06-15 13:00:00	AMZN	Stock	1.7045	1.7105	1.701	1.71	8010460.0
2006-06-15 14:00:00	AMZN	Stock	1.71	1.7375	1.7095	1.735	20762860.0
2006-06-15 15:00:00	AMZN	Stock	1.735	1.7585	1.7315	1.748	43235300.0
2006-06-15 16:00:00	AMZN	Stock	1.7475	1.7515	1.746	1.75	252140.0
2006-06-15 18:00:00	AMZN	Stock	1.75	1.75	1.75	1.75	8380.0
2006-06-15 09:00:00	CL	Stock	30.055	30.315	29.825	29.99	658000.0

> showing 50 of 29,010 rows — these rows as CSV

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