PREVIEW / stock_1hour / 2006-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-09.parquet
  size:    604 KB
  rows:    28,427
  symbols: 2,196

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-02-09 04:00:00	AAPL	Stock	2.4661	2.4661	2.4661	2.4661	2800.0
2006-02-09 05:00:00	AAPL	Stock	2.4811	2.4811	2.4811	2.4811	5600.0
2006-02-09 07:00:00	AAPL	Stock	2.475	2.4893	2.475	2.4789	137200.0
2006-02-09 08:00:00	AAPL	Stock	2.4768	2.4782	2.4536	2.4657	2504600.0
2006-02-09 09:00:00	AAPL	Stock	2.4675	2.4725	2.4146	2.4639	157978184.0
2006-02-09 10:00:00	AAPL	Stock	2.4646	2.4686	2.4286	2.4411	136082044.0
2006-02-09 11:00:00	AAPL	Stock	2.4414	2.4443	2.4182	2.4221	109480168.0
2006-02-09 12:00:00	AAPL	Stock	2.4225	2.4304	2.4086	2.4154	86553236.0
2006-02-09 13:00:00	AAPL	Stock	2.415	2.4204	2.3982	2.4129	90281100.0
2006-02-09 14:00:00	AAPL	Stock	2.4129	2.4132	2.3714	2.3736	143698436.0
2006-02-09 15:00:00	AAPL	Stock	2.3739	2.3782	2.3046	2.3186	400627276.0
2006-02-09 16:00:00	AAPL	Stock	2.3193	2.3214	2.3107	2.3143	5997040.0
2006-02-09 17:00:00	AAPL	Stock	2.3146	2.3214	2.3129	2.3193	1324064.0
2006-02-09 18:00:00	AAPL	Stock	2.3161	2.3196	2.3146	2.3146	509852.0
2006-02-09 08:00:00	MSFT	Stock	26.9	27.0	26.9	27.0	21525.0
2006-02-09 09:00:00	MSFT	Stock	26.96	27.03	26.75	26.85	8241801.0
2006-02-09 10:00:00	MSFT	Stock	26.85	27.03	26.77	26.939	10509509.0
2006-02-09 11:00:00	MSFT	Stock	26.93	26.94	26.83	26.86	5163638.0
2006-02-09 12:00:00	MSFT	Stock	26.86	26.96	26.85	26.9	4747442.0
2006-02-09 13:00:00	MSFT	Stock	26.9	27.0	26.89	26.96	4917918.0
2006-02-09 14:00:00	MSFT	Stock	26.95	26.96	26.82	26.83	5367576.0
2006-02-09 15:00:00	MSFT	Stock	26.838	26.84	26.65	26.66	11159162.0
2006-02-09 16:00:00	MSFT	Stock	26.66	26.91	26.62	26.7	290918.0
2006-02-09 17:00:00	MSFT	Stock	26.72	26.74	26.6	26.66	54040.0
2006-02-09 08:00:00	NVDA	Stock	0.3764	0.3764	0.3764	0.3764	12000.0
2006-02-09 09:00:00	NVDA	Stock	0.3774	0.3791	0.3748	0.3788	46752360.0
2006-02-09 10:00:00	NVDA	Stock	0.379	0.3812	0.3787	0.3801	60392520.0
2006-02-09 11:00:00	NVDA	Stock	0.3801	0.3805	0.3782	0.3793	38070960.0
2006-02-09 12:00:00	NVDA	Stock	0.3792	0.3806	0.3789	0.3792	42464400.0
2006-02-09 13:00:00	NVDA	Stock	0.3792	0.3806	0.3775	0.3776	36096240.0
2006-02-09 14:00:00	NVDA	Stock	0.3775	0.3776	0.3727	0.3733	49148040.0
2006-02-09 15:00:00	NVDA	Stock	0.3732	0.3733	0.3656	0.368	133122600.0
2006-02-09 16:00:00	NVDA	Stock	0.3677	0.369	0.3677	0.3687	12604320.0
2006-02-09 17:00:00	NVDA	Stock	0.3679	0.3679	0.3679	0.3679	36000.0
2006-02-09 09:00:00	AMZN	Stock	1.917	1.95	1.917	1.9355	24962800.0
2006-02-09 10:00:00	AMZN	Stock	1.9355	1.942	1.9225	1.9255	22935000.0
2006-02-09 11:00:00	AMZN	Stock	1.9265	1.937	1.917	1.935	10694000.0
2006-02-09 12:00:00	AMZN	Stock	1.935	1.9435	1.935	1.9415	13459380.0
2006-02-09 13:00:00	AMZN	Stock	1.941	1.9435	1.9275	1.9295	15709120.0
2006-02-09 14:00:00	AMZN	Stock	1.9295	1.931	1.9085	1.9165	19643780.0
2006-02-09 15:00:00	AMZN	Stock	1.916	1.916	1.8965	1.8995	29350200.0
2006-02-09 16:00:00	AMZN	Stock	1.9025	1.909	1.8995	1.909	96560.0
2006-02-09 17:00:00	AMZN	Stock	1.9	1.908	1.8995	1.8995	35180.0
2006-02-09 09:00:00	CL	Stock	26.84	26.965	26.82	26.945	328400.0
2006-02-09 10:00:00	CL	Stock	26.965	26.97	26.86	26.885	356000.0
2006-02-09 11:00:00	CL	Stock	26.88	26.985	26.85	26.98	361200.0
2006-02-09 12:00:00	CL	Stock	26.98	27.135	26.975	27.04	368200.0
2006-02-09 13:00:00	CL	Stock	27.04	27.095	27.01	27.06	346800.0
2006-02-09 14:00:00	CL	Stock	27.065	27.07	26.985	26.99	368600.0
2006-02-09 15:00:00	CL	Stock	26.995	26.995	26.85	26.885	792600.0

> showing 50 of 28,427 rows — these rows as CSV

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