PREVIEW / stock_1hour / 2008-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-07.parquet
  size:    845 KB
  rows:    41,958
  symbols: 3,378

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-10-07 07:00:00	AAPL	Stock	3.5143	3.5625	3.5143	3.5411	377328.0
2008-10-07 08:00:00	AAPL	Stock	3.5411	3.5411	3.425	3.4343	6745648.0
2008-10-07 09:00:00	AAPL	Stock	3.4343	3.625	3.3432	3.3654	263319168.0
2008-10-07 10:00:00	AAPL	Stock	3.3661	3.5132	3.3232	3.4214	328493060.0
2008-10-07 11:00:00	AAPL	Stock	3.4214	3.4393	3.3754	3.4107	177074492.0
2008-10-07 12:00:00	AAPL	Stock	3.4111	3.4111	3.3089	3.3532	172348036.0
2008-10-07 13:00:00	AAPL	Stock	3.3529	3.4104	3.2589	3.2636	245819168.0
2008-10-07 14:00:00	AAPL	Stock	3.2632	3.3746	3.2568	3.2896	257679716.0
2008-10-07 15:00:00	AAPL	Stock	3.2896	3.3029	3.1768	3.1918	364120036.0
2008-10-07 16:00:00	AAPL	Stock	3.1846	3.4836	3.1761	3.19	36991948.0
2008-10-07 17:00:00	AAPL	Stock	3.1936	3.1936	3.1786	3.1868	776356.0
2008-10-07 18:00:00	AAPL	Stock	3.1857	3.1857	3.1782	3.1839	1294608.0
2008-10-07 19:00:00	AAPL	Stock	3.1796	3.1875	3.1779	3.1786	1792252.0
2008-10-07 06:00:00	MSFT	Stock	24.91	24.91	24.91	24.91	1040.0
2008-10-07 07:00:00	MSFT	Stock	25.14	25.14	24.99	25.05	13700.0
2008-10-07 08:00:00	MSFT	Stock	25.05	25.1	24.55	24.6	98439.0
2008-10-07 09:00:00	MSFT	Stock	24.6	25.23	24.47	24.55	12816903.0
2008-10-07 10:00:00	MSFT	Stock	24.55	24.7	24.31	24.345	17989969.0
2008-10-07 11:00:00	MSFT	Stock	24.35	24.35	24.04	24.27	15538200.0
2008-10-07 12:00:00	MSFT	Stock	24.27	24.33	23.97	24.062	12534245.0
2008-10-07 13:00:00	MSFT	Stock	24.06	24.31	23.55	23.56	19685632.0
2008-10-07 14:00:00	MSFT	Stock	23.56	24.21	23.54	23.8	21527377.0
2008-10-07 15:00:00	MSFT	Stock	23.8	23.95	23.14	23.16	29639502.0
2008-10-07 16:00:00	MSFT	Stock	23.2	24.89	23.11	23.19	11871071.0
2008-10-07 17:00:00	MSFT	Stock	23.18	23.23	23.16	23.22	19630.0
2008-10-07 18:00:00	MSFT	Stock	23.23	23.23	23.16	23.17	17651.0
2008-10-07 19:00:00	MSFT	Stock	23.17	23.25	23.15	23.17	13484.0
2008-10-07 08:00:00	NVDA	Stock	0.2	0.2038	0.1962	0.1962	876960.0
2008-10-07 09:00:00	NVDA	Stock	0.1965	0.2045	0.1865	0.1908	133879760.0
2008-10-07 10:00:00	NVDA	Stock	0.1908	0.1933	0.1853	0.1863	157056200.0
2008-10-07 11:00:00	NVDA	Stock	0.1863	0.1938	0.1855	0.1918	144431840.0
2008-10-07 12:00:00	NVDA	Stock	0.1918	0.1948	0.1833	0.185	140453640.0
2008-10-07 13:00:00	NVDA	Stock	0.185	0.1905	0.183	0.183	156375200.0
2008-10-07 14:00:00	NVDA	Stock	0.1833	0.1905	0.1825	0.1844	120493760.0
2008-10-07 15:00:00	NVDA	Stock	0.1845	0.186	0.1795	0.1815	155967520.0
2008-10-07 16:00:00	NVDA	Stock	0.1815	0.2033	0.181	0.181	14640600.0
2008-10-07 17:00:00	NVDA	Stock	0.1818	0.1845	0.1795	0.1795	172000.0
2008-10-07 18:00:00	NVDA	Stock	0.1818	0.182	0.1818	0.182	26720.0
2008-10-07 19:00:00	NVDA	Stock	0.182	0.1825	0.179	0.179	190000.0
2008-10-07 07:00:00	AMZN	Stock	3.3	3.3	3.3	3.3	4000.0
2008-10-07 08:00:00	AMZN	Stock	3.255	3.26	3.183	3.188	51320.0
2008-10-07 09:00:00	AMZN	Stock	3.188	3.3215	3.111	3.1745	30701180.0
2008-10-07 10:00:00	AMZN	Stock	3.1735	3.275	3.119	3.188	40751840.0
2008-10-07 11:00:00	AMZN	Stock	3.1895	3.2075	3.107	3.1325	19918160.0
2008-10-07 12:00:00	AMZN	Stock	3.132	3.1325	3.0505	3.0585	18917580.0
2008-10-07 13:00:00	AMZN	Stock	3.058	3.1325	2.925	2.9468	40725780.0
2008-10-07 14:00:00	AMZN	Stock	2.946	3.0825	2.9275	2.9535	37348100.0
2008-10-07 15:00:00	AMZN	Stock	2.953	3.0215	2.926	2.928	50484400.0
2008-10-07 16:00:00	AMZN	Stock	2.9325	3.2925	2.926	3.253	3831120.0
2008-10-07 17:00:00	AMZN	Stock	3.253	3.253	2.9325	2.9515	1707000.0

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

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