PREVIEW / stock_1hour / 2008-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-28.parquet
  size:    819 KB
  rows:    39,542
  symbols: 3,308

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-28 07:00:00	AAPL	Stock	6.2479	6.2479	6.2479	6.2479	2800.0
2008-08-28 08:00:00	AAPL	Stock	6.2007	6.2639	6.2007	6.2618	2479260.0
2008-08-28 09:00:00	AAPL	Stock	6.2618	6.2946	6.2436	6.2746	63055384.0
2008-08-28 10:00:00	AAPL	Stock	6.2746	6.2929	6.27	6.2825	62524000.0
2008-08-28 11:00:00	AAPL	Stock	6.2825	6.2875	6.2614	6.2743	41393744.0
2008-08-28 12:00:00	AAPL	Stock	6.2732	6.2757	6.2236	6.2486	54209652.0
2008-08-28 13:00:00	AAPL	Stock	6.2475	6.2643	6.2268	6.2318	42406476.0
2008-08-28 14:00:00	AAPL	Stock	6.2309	6.2332	6.1761	6.2046	62820856.0
2008-08-28 15:00:00	AAPL	Stock	6.2046	6.2207	6.1696	6.1996	81818436.0
2008-08-28 16:00:00	AAPL	Stock	6.2054	6.2516	6.1782	6.1879	12136376.0
2008-08-28 17:00:00	AAPL	Stock	6.1889	6.1911	6.1857	6.1889	228676.0
2008-08-28 18:00:00	AAPL	Stock	6.1875	6.1929	6.1857	6.1861	302120.0
2008-08-28 19:00:00	AAPL	Stock	6.1946	6.1946	6.1875	6.1929	154728.0
2008-08-28 08:00:00	MSFT	Stock	27.6	27.68	27.6	27.67	6408.0
2008-08-28 09:00:00	MSFT	Stock	27.68	27.96	27.6	27.75	8211461.0
2008-08-28 10:00:00	MSFT	Stock	27.75	27.87	27.65	27.82	8894267.0
2008-08-28 11:00:00	MSFT	Stock	27.82	27.9	27.73	27.87	6940704.0
2008-08-28 12:00:00	MSFT	Stock	27.87	27.88	27.77	27.83	4979749.0
2008-08-28 13:00:00	MSFT	Stock	27.84	27.96	27.81	27.95	3814965.0
2008-08-28 14:00:00	MSFT	Stock	27.95	28.01	27.87	27.96	6285607.0
2008-08-28 15:00:00	MSFT	Stock	27.96	27.98	27.85	27.92	6150881.0
2008-08-28 16:00:00	MSFT	Stock	27.91	27.95	27.56	27.76	2500690.0
2008-08-28 17:00:00	MSFT	Stock	27.8	27.8	27.76	27.76	10168.0
2008-08-28 18:00:00	MSFT	Stock	27.77	27.77	27.77	27.77	2050.0
2008-08-28 19:00:00	MSFT	Stock	27.77	27.77	27.76	27.76	4615.0
2008-08-28 20:00:00	MSFT	Stock	27.75	27.75	27.75	27.75	1530.0
2008-08-28 09:00:00	NVDA	Stock	0.3303	0.3338	0.3256	0.3293	59502920.0
2008-08-28 10:00:00	NVDA	Stock	0.3293	0.33	0.3253	0.328	56210680.0
2008-08-28 11:00:00	NVDA	Stock	0.328	0.3293	0.326	0.3285	46446520.0
2008-08-28 12:00:00	NVDA	Stock	0.3285	0.3293	0.3263	0.3285	46545680.0
2008-08-28 13:00:00	NVDA	Stock	0.3285	0.3286	0.3275	0.328	24414240.0
2008-08-28 14:00:00	NVDA	Stock	0.328	0.3303	0.3263	0.3295	49975080.0
2008-08-28 15:00:00	NVDA	Stock	0.3293	0.33	0.3275	0.3283	62711120.0
2008-08-28 16:00:00	NVDA	Stock	0.3285	0.3298	0.325	0.3298	8760280.0
2008-08-28 17:00:00	NVDA	Stock	0.3268	0.3268	0.325	0.325	1821520.0
2008-08-28 18:00:00	NVDA	Stock	0.3268	0.3268	0.3243	0.3243	272960.0
2008-08-28 19:00:00	NVDA	Stock	0.326	0.326	0.325	0.325	217320.0
2008-08-28 08:00:00	AMZN	Stock	4.1175	4.1215	4.1175	4.1215	18000.0
2008-08-28 09:00:00	AMZN	Stock	4.111	4.128	4.087	4.1185	9154660.0
2008-08-28 10:00:00	AMZN	Stock	4.1185	4.1635	4.1025	4.148	30659660.0
2008-08-28 11:00:00	AMZN	Stock	4.148	4.1775	4.138	4.175	26424140.0
2008-08-28 12:00:00	AMZN	Stock	4.1725	4.175	4.134	4.141	19087280.0
2008-08-28 13:00:00	AMZN	Stock	4.141	4.17	4.131	4.15	22254440.0
2008-08-28 14:00:00	AMZN	Stock	4.15	4.1825	4.13	4.1695	14098900.0
2008-08-28 15:00:00	AMZN	Stock	4.1705	4.1795	4.161	4.1715	32068380.0
2008-08-28 16:00:00	AMZN	Stock	4.171	4.171	4.0865	4.0865	2568140.0
2008-08-28 17:00:00	AMZN	Stock	4.1585	4.1585	4.1455	4.15	20000.0
2008-08-28 19:00:00	AMZN	Stock	4.155	4.155	4.155	4.155	4000.0
2008-08-28 09:00:00	TLT	Stock	93.88	94.02	93.81	93.93	213437.0
2008-08-28 10:00:00	TLT	Stock	93.89	93.96	93.69	93.7	320373.0

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

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