PREVIEW / stock_1hour / 2008-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-26.parquet
  size:    804 KB
  rows:    39,389
  symbols: 3,303

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-26 05:00:00	AAPL	Stock	6.1361	6.1868	6.1361	6.1868	5600.0
2008-08-26 07:00:00	AAPL	Stock	6.1868	6.2036	6.1696	6.1786	69496.0
2008-08-26 08:00:00	AAPL	Stock	6.1782	6.1943	6.1589	6.1786	1344252.0
2008-08-26 09:00:00	AAPL	Stock	6.175	6.2354	6.1571	6.2279	71935052.0
2008-08-26 10:00:00	AAPL	Stock	6.2286	6.2457	6.1946	6.235	89276796.0
2008-08-26 11:00:00	AAPL	Stock	6.235	6.2389	6.1829	6.2075	48334832.0
2008-08-26 12:00:00	AAPL	Stock	6.2079	6.23	6.1939	6.2014	37350264.0
2008-08-26 13:00:00	AAPL	Stock	6.2004	6.2161	6.1761	6.1837	35388724.0
2008-08-26 14:00:00	AAPL	Stock	6.1839	6.2089	6.1679	6.1721	50880200.0
2008-08-26 15:00:00	AAPL	Stock	6.1718	6.2214	6.1718	6.2021	69171900.0
2008-08-26 16:00:00	AAPL	Stock	6.2092	6.2092	6.1965	6.2011	35715624.0
2008-08-26 17:00:00	AAPL	Stock	6.2036	6.2036	6.1961	6.2036	215180.0
2008-08-26 18:00:00	AAPL	Stock	6.2036	6.205	6.2036	6.2036	28364.0
2008-08-26 19:00:00	AAPL	Stock	6.2029	6.2032	6.1982	6.2018	200116.0
2008-08-26 07:00:00	MSFT	Stock	27.61	27.61	27.61	27.61	100.0
2008-08-26 09:00:00	MSFT	Stock	27.63	27.71	27.43	27.54	4647352.0
2008-08-26 10:00:00	MSFT	Stock	27.54	27.72	27.52	27.69	4969293.0
2008-08-26 11:00:00	MSFT	Stock	27.68	27.705	27.48	27.48	5435541.0
2008-08-26 12:00:00	MSFT	Stock	27.48	27.54	27.36	27.403	3220576.0
2008-08-26 13:00:00	MSFT	Stock	27.41	27.43	27.18	27.241	4974722.0
2008-08-26 14:00:00	MSFT	Stock	27.24	27.36	27.17	27.19	5184828.0
2008-08-26 15:00:00	MSFT	Stock	27.199	27.33	27.17	27.29	7218118.0
2008-08-26 16:00:00	MSFT	Stock	27.29	27.419	27.22	27.27	8325421.0
2008-08-26 17:00:00	MSFT	Stock	27.28	27.52	27.26	27.29	154200.0
2008-08-26 18:00:00	MSFT	Stock	27.3	27.3	27.29	27.3	1160.0
2008-08-26 08:00:00	NVDA	Stock	0.3378	0.3378	0.3368	0.3373	276000.0
2008-08-26 09:00:00	NVDA	Stock	0.3362	0.339	0.3288	0.3298	81986960.0
2008-08-26 10:00:00	NVDA	Stock	0.3295	0.3313	0.327	0.331	99040760.0
2008-08-26 11:00:00	NVDA	Stock	0.3313	0.3314	0.3278	0.3278	65192160.0
2008-08-26 12:00:00	NVDA	Stock	0.3275	0.3303	0.327	0.3291	72761680.0
2008-08-26 13:00:00	NVDA	Stock	0.329	0.3298	0.3263	0.3268	55513560.0
2008-08-26 14:00:00	NVDA	Stock	0.3265	0.3278	0.3238	0.3238	98596600.0
2008-08-26 15:00:00	NVDA	Stock	0.324	0.3283	0.3238	0.327	106194840.0
2008-08-26 16:00:00	NVDA	Stock	0.327	0.3283	0.3265	0.327	31815400.0
2008-08-26 17:00:00	NVDA	Stock	0.327	0.327	0.3258	0.3258	68000.0
2008-08-26 18:00:00	NVDA	Stock	0.327	0.327	0.327	0.327	45200.0
2008-08-26 19:00:00	NVDA	Stock	0.3273	0.3275	0.3273	0.3275	8000.0
2008-08-26 09:00:00	AMZN	Stock	4.137	4.156	4.094	4.1035	7156540.0
2008-08-26 10:00:00	AMZN	Stock	4.1045	4.1295	4.0925	4.1295	10316020.0
2008-08-26 11:00:00	AMZN	Stock	4.1295	4.1395	4.0855	4.0995	9984860.0
2008-08-26 12:00:00	AMZN	Stock	4.0995	4.1125	4.0825	4.1005	7454640.0
2008-08-26 13:00:00	AMZN	Stock	4.0995	4.1045	4.0755	4.0825	7641560.0
2008-08-26 14:00:00	AMZN	Stock	4.082	4.094	4.0655	4.067	9785260.0
2008-08-26 15:00:00	AMZN	Stock	4.067	4.094	4.0625	4.0885	15077220.0
2008-08-26 16:00:00	AMZN	Stock	4.091	4.0958	4.0812	4.0865	18437880.0
2008-08-26 17:00:00	AMZN	Stock	4.085	4.085	4.082	4.082	50000.0
2008-08-26 18:00:00	AMZN	Stock	4.082	4.0845	4.082	4.0845	20900.0
2008-08-26 19:00:00	AMZN	Stock	4.0825	4.0825	4.0825	4.0825	4220.0
2008-08-26 09:00:00	TLT	Stock	94.01	94.02	93.89	93.93	108647.0
2008-08-26 10:00:00	TLT	Stock	93.93	93.94	93.74	93.89	285095.0

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

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