PREVIEW / stock_1hour / 2008-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-18.parquet
  size:    805 KB
  rows:    41,109
  symbols: 3,329

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-11-18 06:00:00	AAPL	Stock	3.11	3.11	3.0925	3.0925	8400.0
2008-11-18 07:00:00	AAPL	Stock	3.1286	3.1368	3.1264	3.1364	190064.0
2008-11-18 08:00:00	AAPL	Stock	3.1357	3.2536	3.1339	3.2204	6550656.0
2008-11-18 09:00:00	AAPL	Stock	3.2239	3.2496	3.1643	3.1775	150491012.0
2008-11-18 10:00:00	AAPL	Stock	3.1779	3.2311	3.1579	3.2104	207198880.0
2008-11-18 11:00:00	AAPL	Stock	3.2104	3.2232	3.1786	3.2204	125860000.0
2008-11-18 12:00:00	AAPL	Stock	3.2204	3.2304	3.1686	3.1811	101055304.0
2008-11-18 13:00:00	AAPL	Stock	3.1825	3.1825	3.1186	3.1471	147810068.0
2008-11-18 14:00:00	AAPL	Stock	3.1471	3.1689	3.1021	3.115	154535080.0
2008-11-18 15:00:00	AAPL	Stock	3.115	3.2139	3.1096	3.2118	260762068.0
2008-11-18 16:00:00	AAPL	Stock	3.2143	3.2332	3.1396	3.2114	44465232.0
2008-11-18 17:00:00	AAPL	Stock	3.2089	3.2139	3.2082	3.2139	798420.0
2008-11-18 18:00:00	AAPL	Stock	3.2118	3.2118	3.2075	3.2075	625464.0
2008-11-18 19:00:00	AAPL	Stock	3.2054	3.2071	3.1964	3.1964	431704.0
2008-11-18 07:00:00	MSFT	Stock	19.17	19.2	19.16	19.2	800.0
2008-11-18 08:00:00	MSFT	Stock	19.23	19.83	19.14	19.74	148569.0
2008-11-18 09:00:00	MSFT	Stock	19.74	19.74	19.21	19.3	8097514.0
2008-11-18 10:00:00	MSFT	Stock	19.3	19.56	19.09	19.45	13825344.0
2008-11-18 11:00:00	MSFT	Stock	19.45	19.51	19.19	19.51	10189780.0
2008-11-18 12:00:00	MSFT	Stock	19.51	19.54	19.23	19.24	8517845.0
2008-11-18 13:00:00	MSFT	Stock	19.24	19.24	18.76	18.9	12643330.0
2008-11-18 14:00:00	MSFT	Stock	18.9	19.06	18.75	18.87	15999005.0
2008-11-18 15:00:00	MSFT	Stock	18.87	19.66	18.84	19.6	28547448.0
2008-11-18 16:00:00	MSFT	Stock	19.6	19.8	18.871	19.6	9041279.0
2008-11-18 17:00:00	MSFT	Stock	19.58	19.62	19.51	19.52	213933.0
2008-11-18 18:00:00	MSFT	Stock	19.62	19.62	19.51	19.55	190852.0
2008-11-18 19:00:00	MSFT	Stock	19.53	19.53	19.5	19.5	12510.0
2008-11-18 08:00:00	NVDA	Stock	0.1763	0.1818	0.1763	0.1803	267320.0
2008-11-18 09:00:00	NVDA	Stock	0.1803	0.1808	0.1738	0.175	51838760.0
2008-11-18 10:00:00	NVDA	Stock	0.175	0.175	0.172	0.1735	62569160.0
2008-11-18 11:00:00	NVDA	Stock	0.1734	0.174	0.1708	0.1736	50259360.0
2008-11-18 12:00:00	NVDA	Stock	0.1738	0.1738	0.1688	0.1695	55294520.0
2008-11-18 13:00:00	NVDA	Stock	0.1695	0.1698	0.1652	0.1668	59873120.0
2008-11-18 14:00:00	NVDA	Stock	0.167	0.168	0.1645	0.1645	52039320.0
2008-11-18 15:00:00	NVDA	Stock	0.1645	0.17	0.164	0.1698	179409200.0
2008-11-18 16:00:00	NVDA	Stock	0.169	0.171	0.1638	0.168	17181320.0
2008-11-18 17:00:00	NVDA	Stock	0.1698	0.1698	0.168	0.1693	1468840.0
2008-11-18 18:00:00	NVDA	Stock	0.1695	0.1698	0.169	0.1698	220000.0
2008-11-18 19:00:00	NVDA	Stock	0.1695	0.1695	0.1682	0.1682	260000.0
2008-11-18 07:00:00	AMZN	Stock	1.9345	1.935	1.93	1.935	45500.0
2008-11-18 08:00:00	AMZN	Stock	1.935	1.995	1.935	1.993	1026880.0
2008-11-18 09:00:00	AMZN	Stock	1.9935	2.033	1.955	1.9715	26978360.0
2008-11-18 10:00:00	AMZN	Stock	1.9715	2.009	1.931	1.996	34343840.0
2008-11-18 11:00:00	AMZN	Stock	1.996	1.997	1.94	1.961	20964260.0
2008-11-18 12:00:00	AMZN	Stock	1.96	1.96	1.889	1.895	36814140.0
2008-11-18 13:00:00	AMZN	Stock	1.8949	1.8949	1.804	1.84	48988640.0
2008-11-18 14:00:00	AMZN	Stock	1.84	1.846	1.807	1.8235	45730400.0
2008-11-18 15:00:00	AMZN	Stock	1.824	1.9235	1.817	1.9235	71085920.0
2008-11-18 16:00:00	AMZN	Stock	1.915	1.9764	1.8285	1.8334	4058680.0
2008-11-18 17:00:00	AMZN	Stock	1.922	1.9295	1.922	1.922	791380.0

> showing 50 of 41,109 rows — these rows as CSV

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