PREVIEW / stock_1hour / 2001-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-14.parquet
  size:    370 KB
  rows:    17,680
  symbols: 1,353

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-11-14 08:00:00	AAPL	Stock	0.3482	0.3509	0.3482	0.3509	996800.0
2001-11-14 09:00:00	AAPL	Stock	0.3513	0.3554	0.3475	0.352	36814400.0
2001-11-14 10:00:00	AAPL	Stock	0.352	0.3534	0.3438	0.3493	53620000.0
2001-11-14 11:00:00	AAPL	Stock	0.3493	0.3509	0.3463	0.3482	22814400.0
2001-11-14 12:00:00	AAPL	Stock	0.3479	0.3482	0.3438	0.3445	17640000.0
2001-11-14 13:00:00	AAPL	Stock	0.3443	0.3472	0.342	0.3444	16760800.0
2001-11-14 14:00:00	AAPL	Stock	0.3444	0.3495	0.3429	0.3479	15573600.0
2001-11-14 15:00:00	AAPL	Stock	0.3475	0.3541	0.3464	0.3502	49761600.0
2001-11-14 16:00:00	AAPL	Stock	0.3504	0.3514	0.3491	0.3502	4116000.0
2001-11-14 17:00:00	AAPL	Stock	0.3502	0.3502	0.3482	0.3482	100800.0
2001-11-14 18:00:00	AAPL	Stock	0.3482	0.3482	0.3482	0.3482	11200.0
2001-11-14 08:00:00	MSFT	Stock	34.25	34.25	33.9475	34.15	294204.0
2001-11-14 09:00:00	MSFT	Stock	34.15	34.175	33.81	33.94	10331000.0
2001-11-14 10:00:00	MSFT	Stock	33.945	34.0	33.395	33.5195	11637000.0
2001-11-14 11:00:00	MSFT	Stock	33.515	33.66	33.435	33.55	6070600.0
2001-11-14 12:00:00	MSFT	Stock	33.555	33.62	33.295	33.33	4711400.0
2001-11-14 13:00:00	MSFT	Stock	33.325	33.445	32.9	33.04	13046800.0
2001-11-14 14:00:00	MSFT	Stock	33.035	33.125	32.9	33.035	14069400.0
2001-11-14 15:00:00	MSFT	Stock	33.03	33.075	32.895	32.98	21062200.0
2001-11-14 16:00:00	MSFT	Stock	32.98	33.3341	32.9	32.975	4124400.0
2001-11-14 17:00:00	MSFT	Stock	32.97	32.975	32.85	32.865	40000.0
2001-11-14 18:00:00	MSFT	Stock	32.865	32.875	32.85	32.855	8000.0
2001-11-14 08:00:00	NVDA	Stock	0.4542	0.459	0.4533	0.4574	1056000.0
2001-11-14 09:00:00	NVDA	Stock	0.4574	0.4592	0.4521	0.4534	184056000.0
2001-11-14 10:00:00	NVDA	Stock	0.4534	0.4571	0.4335	0.4371	229824000.0
2001-11-14 11:00:00	NVDA	Stock	0.4367	0.4426	0.4358	0.4401	162672000.0
2001-11-14 12:00:00	NVDA	Stock	0.4402	0.4404	0.4285	0.4285	110028000.0
2001-11-14 13:00:00	NVDA	Stock	0.4286	0.4321	0.4267	0.4317	108888000.0
2001-11-14 14:00:00	NVDA	Stock	0.4317	0.4396	0.43	0.4385	122628000.0
2001-11-14 15:00:00	NVDA	Stock	0.4377	0.4437	0.4347	0.4389	181476000.0
2001-11-14 16:00:00	NVDA	Stock	0.4389	0.4416	0.4343	0.4389	9996000.0
2001-11-14 17:00:00	NVDA	Stock	0.4389	0.4389	0.4341	0.4356	612000.0
2001-11-14 18:00:00	NVDA	Stock	0.4373	0.4375	0.4365	0.4366	120000.0
2001-11-14 08:00:00	AMZN	Stock	0.3705	0.385	0.37	0.3845	1370000.0
2001-11-14 09:00:00	AMZN	Stock	0.3825	0.416	0.38	0.4105	108472000.0
2001-11-14 10:00:00	AMZN	Stock	0.4105	0.43	0.4065	0.4165	110954000.0
2001-11-14 11:00:00	AMZN	Stock	0.4165	0.4325	0.4155	0.431	41438000.0
2001-11-14 12:00:00	AMZN	Stock	0.4305	0.4355	0.4235	0.4335	40736000.0
2001-11-14 13:00:00	AMZN	Stock	0.433	0.452	0.433	0.4465	79870000.0
2001-11-14 14:00:00	AMZN	Stock	0.4455	0.465	0.4365	0.463	64384000.0
2001-11-14 15:00:00	AMZN	Stock	0.4626	0.4745	0.4585	0.4745	98392000.0
2001-11-14 16:00:00	AMZN	Stock	0.474	0.477	0.4481	0.4745	9454000.0
2001-11-14 17:00:00	AMZN	Stock	0.475	0.4775	0.4735	0.475	372000.0
2001-11-14 18:00:00	AMZN	Stock	0.475	0.48	0.4745	0.4775	228000.0
2001-11-14 09:00:00	CL	Stock	28.93	28.93	28.675	28.89	441000.0
2001-11-14 10:00:00	CL	Stock	28.875	28.885	28.7	28.85	433600.0
2001-11-14 11:00:00	CL	Stock	28.85	28.97	28.845	28.9	312400.0
2001-11-14 12:00:00	CL	Stock	28.9	28.935	28.825	28.825	268600.0
2001-11-14 13:00:00	CL	Stock	28.81	28.95	28.8	28.81	277800.0
2001-11-14 14:00:00	CL	Stock	28.82	28.875	28.77	28.86	268000.0

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

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