PREVIEW / stock_1hour / 2008-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-19.parquet
  size:    787 KB
  rows:    40,210
  symbols: 3,320

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-19 07:00:00	AAPL	Stock	3.2093	3.2107	3.2018	3.2036	184184.0
2008-11-19 08:00:00	AAPL	Stock	3.1918	3.1925	3.1596	3.1618	1931160.0
2008-11-19 09:00:00	AAPL	Stock	3.1629	3.2489	3.1629	3.2239	136416252.0
2008-11-19 10:00:00	AAPL	Stock	3.2239	3.2707	3.1968	3.2071	215895568.0
2008-11-19 11:00:00	AAPL	Stock	3.2068	3.2293	3.1596	3.1743	148822128.0
2008-11-19 12:00:00	AAPL	Stock	3.1743	3.1893	3.1529	3.1868	102138960.0
2008-11-19 13:00:00	AAPL	Stock	3.1864	3.1989	3.1346	3.1661	111821024.0
2008-11-19 14:00:00	AAPL	Stock	3.1671	3.1954	3.14	3.1861	152513396.0
2008-11-19 15:00:00	AAPL	Stock	3.1861	3.2064	3.0793	3.0793	264618508.0
2008-11-19 16:00:00	AAPL	Stock	3.0793	3.2375	3.0789	3.0846	27374508.0
2008-11-19 17:00:00	AAPL	Stock	3.0857	3.0893	3.0829	3.0889	596876.0
2008-11-19 18:00:00	AAPL	Stock	3.0893	3.0929	3.0825	3.0825	263956.0
2008-11-19 19:00:00	AAPL	Stock	3.085	3.0875	3.0768	3.0829	218148.0
2008-11-19 07:00:00	MSFT	Stock	19.3	19.5	19.3	19.5	600.0
2008-11-19 08:00:00	MSFT	Stock	19.5	19.62	19.38	19.42	45034.0
2008-11-19 09:00:00	MSFT	Stock	19.37	19.92	19.37	19.68	6812249.0
2008-11-19 10:00:00	MSFT	Stock	19.68	19.95	19.5	19.522	14571749.0
2008-11-19 11:00:00	MSFT	Stock	19.52	19.56	18.8	19.0	16996387.0
2008-11-19 12:00:00	MSFT	Stock	19.0	19.1	18.87	18.98	8212645.0
2008-11-19 13:00:00	MSFT	Stock	18.982	19.12	18.78	18.99	8532410.0
2008-11-19 14:00:00	MSFT	Stock	18.99	19.24	18.75	19.159	13446764.0
2008-11-19 15:00:00	MSFT	Stock	19.155	19.2	18.25	18.27	28106398.0
2008-11-19 16:00:00	MSFT	Stock	18.28	19.71	18.25	18.34	4667378.0
2008-11-19 17:00:00	MSFT	Stock	18.34	19.065	18.3	18.36	39059.0
2008-11-19 18:00:00	MSFT	Stock	18.35	18.38	18.3	18.35	27205.0
2008-11-19 19:00:00	MSFT	Stock	18.35	18.45	18.35	18.36	12818.0
2008-11-19 08:00:00	NVDA	Stock	0.1652	0.1652	0.1638	0.1638	67000.0
2008-11-19 09:00:00	NVDA	Stock	0.1685	0.1695	0.1665	0.1695	46757440.0
2008-11-19 10:00:00	NVDA	Stock	0.1693	0.1725	0.1658	0.1658	81579160.0
2008-11-19 11:00:00	NVDA	Stock	0.1658	0.167	0.1628	0.1645	46631920.0
2008-11-19 12:00:00	NVDA	Stock	0.1642	0.165	0.1625	0.1635	38511080.0
2008-11-19 13:00:00	NVDA	Stock	0.1635	0.1645	0.1608	0.1618	51272160.0
2008-11-19 14:00:00	NVDA	Stock	0.1618	0.1625	0.1585	0.1612	59222880.0
2008-11-19 15:00:00	NVDA	Stock	0.1612	0.1628	0.155	0.155	150535720.0
2008-11-19 16:00:00	NVDA	Stock	0.156	0.1628	0.1548	0.1558	9060720.0
2008-11-19 17:00:00	NVDA	Stock	0.1558	0.1625	0.1548	0.1625	149040.0
2008-11-19 18:00:00	NVDA	Stock	0.157	0.157	0.157	0.157	20000.0
2008-11-19 19:00:00	NVDA	Stock	0.155	0.155	0.1548	0.155	44000.0
2008-11-19 08:00:00	AMZN	Stock	1.8795	1.8795	1.873	1.875	54300.0
2008-11-19 09:00:00	AMZN	Stock	1.873	1.95	1.873	1.9145	28880160.0
2008-11-19 10:00:00	AMZN	Stock	1.9145	1.949	1.852	1.858	43867760.0
2008-11-19 11:00:00	AMZN	Stock	1.858	1.886	1.8015	1.8315	36739780.0
2008-11-19 12:00:00	AMZN	Stock	1.8315	1.8435	1.8015	1.819	22177700.0
2008-11-19 13:00:00	AMZN	Stock	1.8185	1.846	1.8075	1.8395	14577700.0
2008-11-19 14:00:00	AMZN	Stock	1.84	1.866	1.822	1.857	33735740.0
2008-11-19 15:00:00	AMZN	Stock	1.8565	1.874	1.7875	1.792	58138500.0
2008-11-19 16:00:00	AMZN	Stock	1.792	1.8825	1.7855	1.7975	11202600.0
2008-11-19 17:00:00	AMZN	Stock	1.7845	1.7975	1.7845	1.7875	22800.0
2008-11-19 18:00:00	AMZN	Stock	1.79	1.7915	1.785	1.7915	31200.0
2008-11-19 19:00:00	AMZN	Stock	1.785	1.785	1.785	1.785	4000.0

> showing 50 of 40,210 rows — these rows as CSV

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