PREVIEW / stock_1hour / 2008-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-15.parquet
  size:    831 KB
  rows:    40,159
  symbols: 3,306

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-05-15 07:00:00	AAPL	Stock	6.6875	6.7143	6.6875	6.71	578816.0
2008-05-15 08:00:00	AAPL	Stock	6.7089	6.7189	6.6918	6.6989	5874484.0
2008-05-15 09:00:00	AAPL	Stock	6.6971	6.6996	6.5786	6.6639	170490908.0
2008-05-15 10:00:00	AAPL	Stock	6.6641	6.7011	6.6111	6.6794	163758224.0
2008-05-15 11:00:00	AAPL	Stock	6.68	6.6964	6.6543	6.6889	93776648.0
2008-05-15 12:00:00	AAPL	Stock	6.6893	6.7586	6.6846	6.7364	113076432.0
2008-05-15 13:00:00	AAPL	Stock	6.7368	6.7489	6.7221	6.7375	65572864.0
2008-05-15 14:00:00	AAPL	Stock	6.7375	6.7429	6.6825	6.7207	111939184.0
2008-05-15 15:00:00	AAPL	Stock	6.7204	6.7821	6.7161	6.7732	119760088.0
2008-05-15 16:00:00	AAPL	Stock	6.7732	6.7786	6.6933	6.7686	14182756.0
2008-05-15 17:00:00	AAPL	Stock	6.77	6.7807	6.6948	6.78	544376.0
2008-05-15 18:00:00	AAPL	Stock	6.7807	6.7821	6.7771	6.7818	258664.0
2008-05-15 19:00:00	AAPL	Stock	6.7818	6.7821	6.7768	6.7811	310352.0
2008-05-15 08:00:00	MSFT	Stock	29.83	30.02	29.83	29.98	8433.0
2008-05-15 09:00:00	MSFT	Stock	29.99	30.15	29.93	30.13	5871055.0
2008-05-15 10:00:00	MSFT	Stock	30.13	30.15	29.98	30.06	5656819.0
2008-05-15 11:00:00	MSFT	Stock	30.07	30.17	29.98	30.148	6767132.0
2008-05-15 12:00:00	MSFT	Stock	30.14	30.41	30.14	30.36	8326030.0
2008-05-15 13:00:00	MSFT	Stock	30.35	30.45	30.26	30.34	6300927.0
2008-05-15 14:00:00	MSFT	Stock	30.34	30.38	30.24	30.32	6538694.0
2008-05-15 15:00:00	MSFT	Stock	30.32	30.53	30.3	30.47	10383314.0
2008-05-15 16:00:00	MSFT	Stock	30.47	30.47	30.13	30.37	2395593.0
2008-05-15 17:00:00	MSFT	Stock	30.39	30.4	30.37	30.37	2150.0
2008-05-15 18:00:00	MSFT	Stock	30.37	30.39	30.37	30.39	1200.0
2008-05-15 19:00:00	MSFT	Stock	30.39	30.44	30.37	30.44	7343.0
2008-05-15 08:00:00	NVDA	Stock	0.5545	0.5582	0.5545	0.557	151400.0
2008-05-15 09:00:00	NVDA	Stock	0.557	0.5608	0.548	0.5608	68436840.0
2008-05-15 10:00:00	NVDA	Stock	0.5608	0.5732	0.557	0.5708	183225240.0
2008-05-15 11:00:00	NVDA	Stock	0.571	0.578	0.5692	0.575	162315080.0
2008-05-15 12:00:00	NVDA	Stock	0.5748	0.5858	0.5738	0.5835	141997520.0
2008-05-15 13:00:00	NVDA	Stock	0.5832	0.5935	0.5825	0.5925	180580160.0
2008-05-15 14:00:00	NVDA	Stock	0.5928	0.597	0.588	0.5883	144258480.0
2008-05-15 15:00:00	NVDA	Stock	0.5883	0.5948	0.5883	0.5943	238303720.0
2008-05-15 16:00:00	NVDA	Stock	0.5912	0.5968	0.5811	0.5948	16239240.0
2008-05-15 17:00:00	NVDA	Stock	0.5945	0.595	0.5688	0.5688	10669440.0
2008-05-15 18:00:00	NVDA	Stock	0.595	0.5955	0.5948	0.595	427000.0
2008-05-15 19:00:00	NVDA	Stock	0.595	0.5963	0.595	0.5952	415400.0
2008-05-15 08:00:00	AMZN	Stock	3.747	3.7475	3.747	3.7475	24000.0
2008-05-15 09:00:00	AMZN	Stock	3.743	3.744	3.6775	3.7345	17022320.0
2008-05-15 10:00:00	AMZN	Stock	3.7345	3.7595	3.703	3.7525	15919100.0
2008-05-15 11:00:00	AMZN	Stock	3.7515	3.7625	3.738	3.751	9434540.0
2008-05-15 12:00:00	AMZN	Stock	3.751	3.794	3.7412	3.7845	16124120.0
2008-05-15 13:00:00	AMZN	Stock	3.784	3.816	3.784	3.8005	15692300.0
2008-05-15 14:00:00	AMZN	Stock	3.8005	3.815	3.7725	3.786	11235760.0
2008-05-15 15:00:00	AMZN	Stock	3.7857	3.8145	3.7025	3.8055	47399460.0
2008-05-15 16:00:00	AMZN	Stock	3.8035	3.814	3.7665	3.7676	4621820.0
2008-05-15 17:00:00	AMZN	Stock	3.795	3.795	3.795	3.795	10000.0
2008-05-15 19:00:00	AMZN	Stock	3.7975	3.8	3.7875	3.795	66000.0
2008-05-15 09:00:00	TLT	Stock	91.0	91.49	91.0	91.41	137519.0
2008-05-15 10:00:00	TLT	Stock	91.42	91.52	91.25	91.45	312660.0

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

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