PREVIEW / stock_1hour / 2006-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-23.parquet
  size:    597 KB
  rows:    28,258
  symbols: 2,189

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-23 05:00:00	AAPL	Stock	2.5661	2.5661	2.5625	2.5625	30240.0
2006-02-23 06:00:00	AAPL	Stock	2.5625	2.5625	2.5625	2.5625	14560.0
2006-02-23 07:00:00	AAPL	Stock	2.5607	2.5607	2.5464	2.5518	145600.0
2006-02-23 08:00:00	AAPL	Stock	2.5536	2.5575	2.5489	2.5532	2349872.0
2006-02-23 09:00:00	AAPL	Stock	2.5532	2.585	2.5511	2.5761	160472648.0
2006-02-23 10:00:00	AAPL	Stock	2.5764	2.6036	2.565	2.6004	199973088.0
2006-02-23 11:00:00	AAPL	Stock	2.6004	2.6071	2.5871	2.5882	107573564.0
2006-02-23 12:00:00	AAPL	Stock	2.5879	2.6021	2.5811	2.6004	87614436.0
2006-02-23 13:00:00	AAPL	Stock	2.6006	2.6036	2.5893	2.5976	53577216.0
2006-02-23 14:00:00	AAPL	Stock	2.5975	2.5993	2.5718	2.5739	80971772.0
2006-02-23 15:00:00	AAPL	Stock	2.5743	2.5829	2.5571	2.5618	140885808.0
2006-02-23 16:00:00	AAPL	Stock	2.5621	2.5996	2.5536	2.5575	3423028.0
2006-02-23 17:00:00	AAPL	Stock	2.5579	2.5632	2.5561	2.5604	685720.0
2006-02-23 18:00:00	AAPL	Stock	2.5593	2.5625	2.5589	2.5625	284788.0
2006-02-23 07:00:00	MSFT	Stock	26.64	26.75	26.64	26.73	1818.0
2006-02-23 08:00:00	MSFT	Stock	26.74	26.74	26.7	26.71	5696.0
2006-02-23 09:00:00	MSFT	Stock	26.7	26.75	26.58	26.61	4263059.0
2006-02-23 10:00:00	MSFT	Stock	26.61	26.67	26.54	26.62	5727044.0
2006-02-23 11:00:00	MSFT	Stock	26.62	26.71	26.6	26.648	3752476.0
2006-02-23 12:00:00	MSFT	Stock	26.65	26.72	26.59	26.71	3685174.0
2006-02-23 13:00:00	MSFT	Stock	26.71	26.83	26.6	26.81	6601099.0
2006-02-23 14:00:00	MSFT	Stock	26.802	26.87	26.75	26.8	7126014.0
2006-02-23 15:00:00	MSFT	Stock	26.801	26.89	26.63	26.66	11396059.0
2006-02-23 16:00:00	MSFT	Stock	26.66	26.756	26.63	26.66	309803.0
2006-02-23 17:00:00	MSFT	Stock	26.66	26.67	26.64	26.64	675167.0
2006-02-23 18:00:00	MSFT	Stock	26.67	26.67	26.67	26.67	700.0
2006-02-23 08:00:00	NVDA	Stock	0.3858	0.3858	0.3858	0.3858	60000.0
2006-02-23 09:00:00	NVDA	Stock	0.3878	0.3878	0.3821	0.3833	54191280.0
2006-02-23 10:00:00	NVDA	Stock	0.3833	0.3873	0.3822	0.3857	57343560.0
2006-02-23 11:00:00	NVDA	Stock	0.3857	0.3879	0.3841	0.3859	60199800.0
2006-02-23 12:00:00	NVDA	Stock	0.3858	0.3861	0.3835	0.3846	33757440.0
2006-02-23 13:00:00	NVDA	Stock	0.3847	0.3853	0.3836	0.3843	22205760.0
2006-02-23 14:00:00	NVDA	Stock	0.3842	0.3847	0.3835	0.3841	37179120.0
2006-02-23 15:00:00	NVDA	Stock	0.3841	0.3841	0.3795	0.3805	92967480.0
2006-02-23 16:00:00	NVDA	Stock	0.3806	0.3807	0.3803	0.3803	4204200.0
2006-02-23 17:00:00	NVDA	Stock	0.3802	0.381	0.3792	0.3796	507600.0
2006-02-23 08:00:00	AMZN	Stock	1.9475	1.9475	1.932	1.932	6000.0
2006-02-23 09:00:00	AMZN	Stock	1.934	1.9375	1.8975	1.9044	33426240.0
2006-02-23 10:00:00	AMZN	Stock	1.902	1.9255	1.8985	1.921	47508560.0
2006-02-23 11:00:00	AMZN	Stock	1.9205	1.9305	1.916	1.919	19111600.0
2006-02-23 12:00:00	AMZN	Stock	1.9185	1.92	1.91	1.918	15793540.0
2006-02-23 13:00:00	AMZN	Stock	1.9175	1.9215	1.913	1.9135	8988800.0
2006-02-23 14:00:00	AMZN	Stock	1.9136	1.915	1.901	1.912	12975000.0
2006-02-23 15:00:00	AMZN	Stock	1.912	1.9135	1.8935	1.8945	36193720.0
2006-02-23 16:00:00	AMZN	Stock	1.8935	1.9055	1.8925	1.894	2712800.0
2006-02-23 17:00:00	AMZN	Stock	1.894	1.897	1.894	1.8955	72540.0
2006-02-23 09:00:00	CL	Stock	27.175	27.22	27.125	27.195	300200.0
2006-02-23 10:00:00	CL	Stock	27.19	27.295	27.17	27.265	438200.0
2006-02-23 11:00:00	CL	Stock	27.267	27.35	27.265	27.295	362400.0
2006-02-23 12:00:00	CL	Stock	27.295	27.495	27.295	27.455	328400.0

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

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