PREVIEW / stock_1hour / 2006-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-27.parquet
  size:    600 KB
  rows:    28,210
  symbols: 2,199

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-27 04:00:00	AAPL	Stock	2.5589	2.5589	2.5589	2.5589	2800.0
2006-02-27 06:00:00	AAPL	Stock	2.5696	2.5696	2.5696	2.5696	14000.0
2006-02-27 07:00:00	AAPL	Stock	2.5625	2.5625	2.5554	2.5625	201600.0
2006-02-27 08:00:00	AAPL	Stock	2.5589	2.5786	2.5521	2.5725	3527776.0
2006-02-27 09:00:00	AAPL	Stock	2.5732	2.5771	2.5304	2.5586	157964940.0
2006-02-27 10:00:00	AAPL	Stock	2.5589	2.5643	2.5232	2.5282	140552216.0
2006-02-27 11:00:00	AAPL	Stock	2.5286	2.5746	2.5264	2.5646	144364892.0
2006-02-27 12:00:00	AAPL	Stock	2.5646	2.5696	2.5329	2.5332	103397672.0
2006-02-27 13:00:00	AAPL	Stock	2.5332	2.55	2.5332	2.5475	70289520.0
2006-02-27 14:00:00	AAPL	Stock	2.5475	2.555	2.5375	2.5407	56441588.0
2006-02-27 15:00:00	AAPL	Stock	2.5411	2.5479	2.5275	2.5336	95814432.0
2006-02-27 16:00:00	AAPL	Stock	2.5321	2.5357	2.5279	2.535	5518632.0
2006-02-27 17:00:00	AAPL	Stock	2.5357	2.5386	2.5325	2.5339	1009316.0
2006-02-27 18:00:00	AAPL	Stock	2.5357	2.5364	2.5343	2.5364	124600.0
2006-02-27 07:00:00	MSFT	Stock	26.63	26.63	26.63	26.63	1000.0
2006-02-27 08:00:00	MSFT	Stock	26.69	26.7	26.64	26.68	16503.0
2006-02-27 09:00:00	MSFT	Stock	26.67	26.89	26.66	26.88	4950476.0
2006-02-27 10:00:00	MSFT	Stock	26.88	26.95	26.82	26.89	6104965.0
2006-02-27 11:00:00	MSFT	Stock	26.89	27.001	26.87	26.98	5780366.0
2006-02-27 12:00:00	MSFT	Stock	26.98	27.11	26.98	27.07	6753146.0
2006-02-27 13:00:00	MSFT	Stock	27.07	27.19	27.069	27.15	4842931.0
2006-02-27 14:00:00	MSFT	Stock	27.16	27.21	27.09	27.132	6210895.0
2006-02-27 15:00:00	MSFT	Stock	27.13	27.26	27.03	27.05	14118746.0
2006-02-27 16:00:00	MSFT	Stock	27.05	27.15	27.05	27.05	400876.0
2006-02-27 17:00:00	MSFT	Stock	27.11	27.11	27.05	27.07	67451.0
2006-02-27 18:00:00	MSFT	Stock	27.05	27.05	27.05	27.05	115000.0
2006-02-27 09:00:00	NVDA	Stock	0.3827	0.3866	0.3814	0.3827	44461800.0
2006-02-27 10:00:00	NVDA	Stock	0.3827	0.3833	0.3794	0.3817	48630600.0
2006-02-27 11:00:00	NVDA	Stock	0.3817	0.3875	0.3817	0.3871	78422880.0
2006-02-27 12:00:00	NVDA	Stock	0.3872	0.3912	0.3871	0.3909	79762320.0
2006-02-27 13:00:00	NVDA	Stock	0.391	0.3958	0.391	0.3952	140686560.0
2006-02-27 14:00:00	NVDA	Stock	0.395	0.3983	0.3943	0.3949	140286360.0
2006-02-27 15:00:00	NVDA	Stock	0.395	0.3966	0.3937	0.3959	117207240.0
2006-02-27 16:00:00	NVDA	Stock	0.3959	0.3965	0.3956	0.3959	1066440.0
2006-02-27 17:00:00	NVDA	Stock	0.3962	0.3963	0.3959	0.3959	159360.0
2006-02-27 18:00:00	NVDA	Stock	0.396	0.3963	0.3959	0.3959	167880.0
2006-02-27 09:00:00	AMZN	Stock	1.9225	1.939	1.915	1.9265	12835900.0
2006-02-27 10:00:00	AMZN	Stock	1.927	1.935	1.902	1.9035	13317260.0
2006-02-27 11:00:00	AMZN	Stock	1.903	1.924	1.9025	1.9235	12806520.0
2006-02-27 12:00:00	AMZN	Stock	1.9235	1.9315	1.9225	1.9305	5772960.0
2006-02-27 13:00:00	AMZN	Stock	1.9305	1.935	1.929	1.9295	6546660.0
2006-02-27 14:00:00	AMZN	Stock	1.9295	1.932	1.9145	1.9245	9268900.0
2006-02-27 15:00:00	AMZN	Stock	1.925	1.9285	1.8965	1.9005	23721440.0
2006-02-27 16:00:00	AMZN	Stock	1.9	1.902	1.896	1.9005	468420.0
2006-02-27 17:00:00	AMZN	Stock	1.9005	1.9005	1.8985	1.8985	68440.0
2006-02-27 09:00:00	CL	Stock	27.185	27.43	27.15	27.375	378000.0
2006-02-27 10:00:00	CL	Stock	27.385	27.425	27.36	27.42	314600.0
2006-02-27 11:00:00	CL	Stock	27.42	27.555	27.375	27.545	394600.0
2006-02-27 12:00:00	CL	Stock	27.555	27.64	27.505	27.64	436200.0
2006-02-27 13:00:00	CL	Stock	27.64	27.685	27.57	27.65	464200.0

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

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