PREVIEW / stock_1hour / 2008-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-08.parquet
  size:    841 KB
  rows:    40,836
  symbols: 3,341

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-08-08 06:00:00	AAPL	Stock	5.8607	5.8607	5.8571	5.8571	10584.0
2008-08-08 07:00:00	AAPL	Stock	5.9061	5.9061	5.85	5.85	263900.0
2008-08-08 08:00:00	AAPL	Stock	5.8543	5.8711	5.8507	5.8679	1656452.0
2008-08-08 09:00:00	AAPL	Stock	5.8664	5.9532	5.845	5.945	104765556.0
2008-08-08 10:00:00	AAPL	Stock	5.9446	5.9725	5.9375	5.953	126891744.0
2008-08-08 11:00:00	AAPL	Stock	5.9532	5.99	5.9411	5.9804	80693704.0
2008-08-08 12:00:00	AAPL	Stock	5.9804	6.0246	5.9721	6.0136	95002264.0
2008-08-08 13:00:00	AAPL	Stock	6.0145	6.0292	6.0011	6.0211	77677908.0
2008-08-08 14:00:00	AAPL	Stock	6.0207	6.0425	6.0143	6.0229	70535836.0
2008-08-08 15:00:00	AAPL	Stock	6.0225	6.0589	6.0025	6.0529	135222892.0
2008-08-08 16:00:00	AAPL	Stock	6.0511	6.0554	5.9877	6.0404	16959628.0
2008-08-08 17:00:00	AAPL	Stock	6.0404	6.0429	6.0361	6.0393	191660.0
2008-08-08 18:00:00	AAPL	Stock	6.0379	6.0464	6.0375	6.0464	173096.0
2008-08-08 19:00:00	AAPL	Stock	6.0468	6.0554	6.0468	6.0539	222908.0
2008-08-08 08:00:00	MSFT	Stock	27.51	27.51	27.4	27.4	600.0
2008-08-08 09:00:00	MSFT	Stock	27.4	27.73	27.19	27.67	9164087.0
2008-08-08 10:00:00	MSFT	Stock	27.68	28.23	27.65	27.86	20832733.0
2008-08-08 11:00:00	MSFT	Stock	27.87	28.06	27.82	28.0	6734030.0
2008-08-08 12:00:00	MSFT	Stock	28.0	28.1	27.9	27.99	4911651.0
2008-08-08 13:00:00	MSFT	Stock	27.995	28.15	27.94	28.07	8306342.0
2008-08-08 14:00:00	MSFT	Stock	28.06	28.18	28.05	28.08	7915859.0
2008-08-08 15:00:00	MSFT	Stock	28.08	28.19	27.96	28.07	17037457.0
2008-08-08 16:00:00	MSFT	Stock	28.09	28.13	27.31	27.31	4570167.0
2008-08-08 17:00:00	MSFT	Stock	28.06	28.07	28.01	28.07	2900.0
2008-08-08 18:00:00	MSFT	Stock	28.07	28.08	28.07	28.08	1912.0
2008-08-08 19:00:00	MSFT	Stock	28.09	28.11	28.09	28.1	2170.0
2008-08-08 08:00:00	NVDA	Stock	0.2875	0.2875	0.2832	0.2838	103000.0
2008-08-08 09:00:00	NVDA	Stock	0.287	0.2875	0.2795	0.2812	64637960.0
2008-08-08 10:00:00	NVDA	Stock	0.2812	0.2852	0.2803	0.2825	140524880.0
2008-08-08 11:00:00	NVDA	Stock	0.2825	0.2828	0.2765	0.2775	137588280.0
2008-08-08 12:00:00	NVDA	Stock	0.2775	0.2792	0.277	0.278	85588720.0
2008-08-08 13:00:00	NVDA	Stock	0.278	0.2783	0.2745	0.2748	133646280.0
2008-08-08 14:00:00	NVDA	Stock	0.2748	0.2763	0.274	0.275	82725720.0
2008-08-08 15:00:00	NVDA	Stock	0.275	0.2765	0.2743	0.2748	183272520.0
2008-08-08 16:00:00	NVDA	Stock	0.275	0.2782	0.2725	0.2748	19221000.0
2008-08-08 17:00:00	NVDA	Stock	0.2748	0.275	0.274	0.275	112160.0
2008-08-08 18:00:00	NVDA	Stock	0.275	0.2752	0.275	0.2752	269880.0
2008-08-08 19:00:00	NVDA	Stock	0.276	0.276	0.2758	0.276	43600.0
2008-08-08 09:00:00	AMZN	Stock	3.831	3.8625	3.8145	3.8355	12703880.0
2008-08-08 10:00:00	AMZN	Stock	3.8345	3.948	3.83	3.911	25796560.0
2008-08-08 11:00:00	AMZN	Stock	3.911	4.0	3.9105	3.9935	23769000.0
2008-08-08 12:00:00	AMZN	Stock	3.993	4.0425	3.9885	4.0255	23443880.0
2008-08-08 13:00:00	AMZN	Stock	4.0265	4.05	4.026	4.028	16007360.0
2008-08-08 14:00:00	AMZN	Stock	4.0275	4.0605	4.0215	4.0425	29858880.0
2008-08-08 15:00:00	AMZN	Stock	4.041	4.05	4.0075	4.023	44494900.0
2008-08-08 16:00:00	AMZN	Stock	4.0175	4.0403	3.9949	4.0403	1784720.0
2008-08-08 17:00:00	AMZN	Stock	4.0255	4.03	4.025	4.03	21040.0
2008-08-08 09:00:00	TLT	Stock	91.7	92.01	91.69	91.87	171928.0
2008-08-08 10:00:00	TLT	Stock	91.87	91.88	91.54	91.62	111910.0
2008-08-08 11:00:00	TLT	Stock	91.62	92.05	91.62	91.96	218199.0

> showing 50 of 40,836 rows — these rows as CSV

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