PREVIEW / stock_1hour / 2008-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-25.parquet
  size:    815 KB
  rows:    39,549
  symbols: 3,322

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
2008-07-25 06:00:00	AAPL	Stock	5.6757	5.6757	5.6757	5.6757	2800.0
2008-07-25 07:00:00	AAPL	Stock	5.7104	5.7104	5.6757	5.6825	30240.0
2008-07-25 08:00:00	AAPL	Stock	5.7	5.7375	5.6896	5.73	2947868.0
2008-07-25 09:00:00	AAPL	Stock	5.7304	5.7489	5.6661	5.7243	95771760.0
2008-07-25 10:00:00	AAPL	Stock	5.7236	5.7646	5.7039	5.75	126979356.0
2008-07-25 11:00:00	AAPL	Stock	5.7501	5.785	5.7343	5.7768	72368520.0
2008-07-25 12:00:00	AAPL	Stock	5.7764	5.7768	5.7386	5.7682	49277844.0
2008-07-25 13:00:00	AAPL	Stock	5.7693	5.7857	5.7332	5.7611	70178836.0
2008-07-25 14:00:00	AAPL	Stock	5.76	5.8214	5.7579	5.8157	92129184.0
2008-07-25 15:00:00	AAPL	Stock	5.8168	5.8196	5.7646	5.7875	93799356.0
2008-07-25 16:00:00	AAPL	Stock	5.7882	5.7942	5.7546	5.79	17814692.0
2008-07-25 17:00:00	AAPL	Stock	5.7857	5.7964	5.7839	5.7954	95396.0
2008-07-25 18:00:00	AAPL	Stock	5.7982	5.7982	5.79	5.7964	693000.0
2008-07-25 19:00:00	AAPL	Stock	5.795	5.7975	5.7946	5.7946	66500.0
2008-07-25 20:00:00	AAPL	Stock	5.7514	5.7514	5.7514	5.7514	75600.0
2008-07-25 07:00:00	MSFT	Stock	25.44	25.44	25.44	25.44	100.0
2008-07-25 08:00:00	MSFT	Stock	25.6	25.6	25.5	25.59	27672.0
2008-07-25 09:00:00	MSFT	Stock	25.58	25.73	25.5	25.66	6137252.0
2008-07-25 10:00:00	MSFT	Stock	25.64	25.9	25.622	25.839	8695781.0
2008-07-25 11:00:00	MSFT	Stock	25.83	25.93	25.75	25.91	6732087.0
2008-07-25 12:00:00	MSFT	Stock	25.9	25.92	25.73	25.77	3438312.0
2008-07-25 13:00:00	MSFT	Stock	25.77	25.82	25.69	25.78	4631990.0
2008-07-25 14:00:00	MSFT	Stock	25.78	25.93	25.7	25.912	6625082.0
2008-07-25 15:00:00	MSFT	Stock	25.92	26.22	25.88	26.14	15527384.0
2008-07-25 16:00:00	MSFT	Stock	26.14	26.184	25.833	26.08	3736469.0
2008-07-25 17:00:00	MSFT	Stock	26.13	26.16	26.13	26.16	56950.0
2008-07-25 18:00:00	MSFT	Stock	26.15	26.21	26.15	26.15	146285.0
2008-07-25 19:00:00	MSFT	Stock	26.16	26.2	26.15	26.15	2169.0
2008-07-25 07:00:00	NVDA	Stock	0.2758	0.2758	0.2758	0.2758	4000.0
2008-07-25 08:00:00	NVDA	Stock	0.2778	0.2788	0.2765	0.2788	517000.0
2008-07-25 09:00:00	NVDA	Stock	0.2775	0.2792	0.2728	0.2778	84588400.0
2008-07-25 10:00:00	NVDA	Stock	0.2778	0.2798	0.2743	0.2755	124236760.0
2008-07-25 11:00:00	NVDA	Stock	0.2755	0.285	0.275	0.2832	225865560.0
2008-07-25 12:00:00	NVDA	Stock	0.2832	0.2835	0.2792	0.2815	114929720.0
2008-07-25 13:00:00	NVDA	Stock	0.2815	0.2862	0.2803	0.286	100067000.0
2008-07-25 14:00:00	NVDA	Stock	0.286	0.288	0.2848	0.288	124851360.0
2008-07-25 15:00:00	NVDA	Stock	0.288	0.29	0.287	0.289	224758760.0
2008-07-25 16:00:00	NVDA	Stock	0.2888	0.289	0.2821	0.2875	13139440.0
2008-07-25 17:00:00	NVDA	Stock	0.2875	0.2875	0.2875	0.2875	68000.0
2008-07-25 18:00:00	NVDA	Stock	0.287	0.2885	0.287	0.2885	56000.0
2008-07-25 19:00:00	NVDA	Stock	0.2885	0.2892	0.2875	0.2892	190000.0
2008-07-25 07:00:00	AMZN	Stock	3.9995	4.0	3.9995	4.0	79600.0
2008-07-25 08:00:00	AMZN	Stock	3.9995	4.0	3.9435	3.9875	359540.0
2008-07-25 09:00:00	AMZN	Stock	3.9875	4.047	3.95	3.994	35497540.0
2008-07-25 10:00:00	AMZN	Stock	3.9945	4.025	3.906	3.986	40729260.0
2008-07-25 11:00:00	AMZN	Stock	3.9855	3.988	3.9335	3.9425	16838700.0
2008-07-25 12:00:00	AMZN	Stock	3.9415	3.952	3.9215	3.9484	13715220.0
2008-07-25 13:00:00	AMZN	Stock	3.948	3.958	3.925	3.9425	18844320.0
2008-07-25 14:00:00	AMZN	Stock	3.9435	3.9545	3.935	3.9465	11443420.0
2008-07-25 15:00:00	AMZN	Stock	3.9475	3.9535	3.9135	3.9135	31652020.0

> showing 50 of 39,549 rows — these rows as CSV

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