PREVIEW / stock_1hour / 2006-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-01.parquet
  size:    602 KB
  rows:    29,346
  symbols: 2,307

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-08-01 04:00:00	AAPL	Stock	2.4268	2.4286	2.4214	2.425	126000.0
2006-08-01 08:00:00	AAPL	Stock	2.4268	2.4286	2.4107	2.4125	1300236.0
2006-08-01 09:00:00	AAPL	Stock	2.4125	2.4261	2.3989	2.4225	91237552.0
2006-08-01 10:00:00	AAPL	Stock	2.4225	2.4243	2.3836	2.3839	134116892.0
2006-08-01 11:00:00	AAPL	Stock	2.3839	2.4011	2.3793	2.3971	85321180.0
2006-08-01 12:00:00	AAPL	Stock	2.3971	2.3971	2.3729	2.3782	77085624.0
2006-08-01 13:00:00	AAPL	Stock	2.3779	2.3782	2.355	2.3707	95125912.0
2006-08-01 14:00:00	AAPL	Stock	2.3704	2.3886	2.3693	2.3771	104614300.0
2006-08-01 15:00:00	AAPL	Stock	2.3771	2.4046	2.3686	2.4014	108491152.0
2006-08-01 16:00:00	AAPL	Stock	2.4018	2.4079	2.3986	2.4014	1783712.0
2006-08-01 17:00:00	AAPL	Stock	2.4014	2.4014	2.3993	2.4014	189700.0
2006-08-01 18:00:00	AAPL	Stock	2.4	2.4018	2.3996	2.4018	99064.0
2006-08-01 07:00:00	MSFT	Stock	24.08	24.08	24.08	24.08	200.0
2006-08-01 08:00:00	MSFT	Stock	24.06	24.18	24.06	24.1	58600.0
2006-08-01 09:00:00	MSFT	Stock	24.1	24.13	24.01	24.06	3777743.0
2006-08-01 10:00:00	MSFT	Stock	24.06	24.2	23.85	24.1	14660385.0
2006-08-01 11:00:00	MSFT	Stock	24.1	24.13	24.02	24.08	6886372.0
2006-08-01 12:00:00	MSFT	Stock	24.08	24.09	24.0	24.03	3713204.0
2006-08-01 13:00:00	MSFT	Stock	24.02	24.04	23.94	23.97	4599131.0
2006-08-01 14:00:00	MSFT	Stock	23.97	24.06	23.9	23.96	4584845.0
2006-08-01 15:00:00	MSFT	Stock	23.96	24.1	23.9	23.99	8140124.0
2006-08-01 16:00:00	MSFT	Stock	23.99	24.05	23.98	24.02	643066.0
2006-08-01 17:00:00	MSFT	Stock	23.99	24.02	23.99	24.02	809.0
2006-08-01 18:00:00	MSFT	Stock	24.01	24.06	23.99	23.99	1986.0
2006-08-01 08:00:00	NVDA	Stock	0.3705	0.3742	0.365	0.365	465600.0
2006-08-01 09:00:00	NVDA	Stock	0.365	0.3665	0.3552	0.3562	72246420.0
2006-08-01 10:00:00	NVDA	Stock	0.3563	0.3608	0.353	0.3588	109697160.0
2006-08-01 11:00:00	NVDA	Stock	0.3587	0.3602	0.3557	0.36	58659060.0
2006-08-01 12:00:00	NVDA	Stock	0.36	0.3605	0.3533	0.3565	45680460.0
2006-08-01 13:00:00	NVDA	Stock	0.3567	0.3567	0.3513	0.3523	66569640.0
2006-08-01 14:00:00	NVDA	Stock	0.3522	0.3523	0.3475	0.3477	99181620.0
2006-08-01 15:00:00	NVDA	Stock	0.3477	0.3563	0.3477	0.3543	123142560.0
2006-08-01 16:00:00	NVDA	Stock	0.3543	0.3558	0.354	0.3558	1812000.0
2006-08-01 17:00:00	NVDA	Stock	0.355	0.355	0.3542	0.3542	35460.0
2006-08-01 06:00:00	AMZN	Stock	1.3445	1.3445	1.3445	1.3445	10000.0
2006-08-01 08:00:00	AMZN	Stock	1.3375	1.3445	1.326	1.326	553000.0
2006-08-01 09:00:00	AMZN	Stock	1.3265	1.3445	1.321	1.3295	20130420.0
2006-08-01 10:00:00	AMZN	Stock	1.3295	1.332	1.3085	1.3135	45746540.0
2006-08-01 11:00:00	AMZN	Stock	1.3135	1.3155	1.2935	1.2985	48646380.0
2006-08-01 12:00:00	AMZN	Stock	1.2985	1.3	1.294	1.298	33743500.0
2006-08-01 13:00:00	AMZN	Stock	1.2985	1.2985	1.293	1.2935	21354680.0
2006-08-01 14:00:00	AMZN	Stock	1.293	1.3065	1.292	1.3045	42262380.0
2006-08-01 15:00:00	AMZN	Stock	1.304	1.317	1.302	1.316	44325460.0
2006-08-01 16:00:00	AMZN	Stock	1.315	1.317	1.3085	1.3135	591160.0
2006-08-01 18:00:00	AMZN	Stock	1.311	1.3115	1.311	1.3115	17000.0
2006-08-01 09:00:00	CL	Stock	29.56	29.59	29.3	29.36	347200.0
2006-08-01 10:00:00	CL	Stock	29.38	29.39	29.15	29.21	922000.0
2006-08-01 11:00:00	CL	Stock	29.215	29.29	29.175	29.265	510800.0
2006-08-01 12:00:00	CL	Stock	29.27	29.305	29.215	29.29	430800.0
2006-08-01 13:00:00	CL	Stock	29.295	29.295	29.17	29.225	235000.0

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

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