PREVIEW / stock_1hour / 2008-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-30.parquet
  size:    868 KB
  rows:    43,092
  symbols: 3,381

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-12-30 04:00:00	AAPL	Stock	3.1293	3.1443	3.1293	3.1443	8400.0
2008-12-30 05:00:00	AAPL	Stock	3.1539	3.1539	3.1536	3.1536	19600.0
2008-12-30 07:00:00	AAPL	Stock	3.1536	3.1782	3.1343	3.1429	364168.0
2008-12-30 08:00:00	AAPL	Stock	3.1339	3.1482	3.1143	3.1275	1693440.0
2008-12-30 09:00:00	AAPL	Stock	3.1275	3.1411	3.1079	3.1146	63026768.0
2008-12-30 10:00:00	AAPL	Stock	3.1146	3.1296	3.0939	3.1179	100682260.0
2008-12-30 11:00:00	AAPL	Stock	3.1175	3.1446	3.1039	3.1393	85056664.0
2008-12-30 12:00:00	AAPL	Stock	3.1393	3.1436	3.0257	3.0675	208477164.0
2008-12-30 13:00:00	AAPL	Stock	3.0675	3.0979	3.0464	3.0696	206787028.0
2008-12-30 14:00:00	AAPL	Stock	3.0696	3.0921	3.0579	3.065	119223972.0
2008-12-30 15:00:00	AAPL	Stock	3.065	3.0886	3.0575	3.0818	157630732.0
2008-12-30 16:00:00	AAPL	Stock	3.0821	3.0963	3.0654	3.0786	18266164.0
2008-12-30 17:00:00	AAPL	Stock	3.0768	3.0818	3.0725	3.0768	488404.0
2008-12-30 18:00:00	AAPL	Stock	3.0768	3.085	3.0768	3.0832	1393784.0
2008-12-30 19:00:00	AAPL	Stock	3.0829	3.0854	3.0782	3.0843	308084.0
2008-12-30 04:00:00	MSFT	Stock	19.13	19.16	19.13	19.16	600.0
2008-12-30 07:00:00	MSFT	Stock	19.15	19.15	19.1	19.1	3100.0
2008-12-30 08:00:00	MSFT	Stock	18.96	19.14	18.95	19.07	17408.0
2008-12-30 09:00:00	MSFT	Stock	19.03	19.18	19.0	19.14	4761641.0
2008-12-30 10:00:00	MSFT	Stock	19.14	19.24	19.09	19.21	5008783.0
2008-12-30 11:00:00	MSFT	Stock	19.22	19.43	19.13	19.42	6090370.0
2008-12-30 12:00:00	MSFT	Stock	19.42	19.49	19.22	19.315	4573069.0
2008-12-30 13:00:00	MSFT	Stock	19.32	19.34	19.22	19.29	3192437.0
2008-12-30 14:00:00	MSFT	Stock	19.29	19.29	19.18	19.22	4609002.0
2008-12-30 15:00:00	MSFT	Stock	19.22	19.35	19.15	19.32	10105292.0
2008-12-30 16:00:00	MSFT	Stock	19.33	19.36	19.05	19.3	2592028.0
2008-12-30 17:00:00	MSFT	Stock	19.31	19.37	19.31	19.34	12232.0
2008-12-30 18:00:00	MSFT	Stock	19.32	19.37	19.31	19.37	2319.0
2008-12-30 19:00:00	MSFT	Stock	19.37	19.38	19.37	19.37	3923.0
2008-12-30 08:00:00	NVDA	Stock	0.1952	0.1958	0.1938	0.1958	256000.0
2008-12-30 09:00:00	NVDA	Stock	0.1952	0.1998	0.1918	0.1933	30608000.0
2008-12-30 10:00:00	NVDA	Stock	0.1933	0.198	0.1925	0.1975	61073600.0
2008-12-30 11:00:00	NVDA	Stock	0.1978	0.2035	0.1977	0.2027	88308680.0
2008-12-30 12:00:00	NVDA	Stock	0.203	0.203	0.1965	0.1972	73721400.0
2008-12-30 13:00:00	NVDA	Stock	0.1972	0.2	0.197	0.2	30102960.0
2008-12-30 14:00:00	NVDA	Stock	0.2	0.2013	0.1985	0.2	31337520.0
2008-12-30 15:00:00	NVDA	Stock	0.2	0.2007	0.199	0.2005	71732640.0
2008-12-30 16:00:00	NVDA	Stock	0.2013	0.2018	0.2005	0.2005	190600.0
2008-12-30 17:00:00	NVDA	Stock	0.199	0.2005	0.199	0.2005	262040.0
2008-12-30 19:00:00	NVDA	Stock	0.1978	0.2005	0.1978	0.2005	40000.0
2008-12-30 08:00:00	AMZN	Stock	2.4755	2.4825	2.475	2.4825	76000.0
2008-12-30 09:00:00	AMZN	Stock	2.5	2.5	2.4465	2.4515	9023280.0
2008-12-30 10:00:00	AMZN	Stock	2.4505	2.4985	2.437	2.4915	20782980.0
2008-12-30 11:00:00	AMZN	Stock	2.492	2.5565	2.481	2.5485	22473480.0
2008-12-30 12:00:00	AMZN	Stock	2.5475	2.5605	2.5275	2.556	17227460.0
2008-12-30 13:00:00	AMZN	Stock	2.5545	2.558	2.518	2.5205	11527380.0
2008-12-30 14:00:00	AMZN	Stock	2.5205	2.53	2.5062	2.5115	9103760.0
2008-12-30 15:00:00	AMZN	Stock	2.5125	2.5445	2.507	2.5375	26535360.0
2008-12-30 16:00:00	AMZN	Stock	2.541	2.542	2.5295	2.53	245380.0
2008-12-30 17:00:00	AMZN	Stock	2.53	2.538	2.53	2.538	84140.0

> showing 50 of 43,092 rows — these rows as CSV

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