PREVIEW / stock_1hour / 2004-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-07.parquet
  size:    505 KB
  rows:    24,215
  symbols: 1,784

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
2004-06-07 08:00:00	AAPL	Stock	0.5179	0.5229	0.5179	0.5193	442400.0
2004-06-07 09:00:00	AAPL	Stock	0.5196	0.522	0.5145	0.522	21731472.0
2004-06-07 10:00:00	AAPL	Stock	0.5218	0.525	0.5204	0.5214	38708880.0
2004-06-07 11:00:00	AAPL	Stock	0.5213	0.527	0.5205	0.5255	38757208.0
2004-06-07 12:00:00	AAPL	Stock	0.5254	0.5304	0.5254	0.528	36053584.0
2004-06-07 13:00:00	AAPL	Stock	0.5282	0.5314	0.5268	0.5313	34685952.0
2004-06-07 14:00:00	AAPL	Stock	0.5311	0.5338	0.5295	0.5327	39158840.0
2004-06-07 15:00:00	AAPL	Stock	0.5327	0.5354	0.5318	0.5321	65559984.0
2004-06-07 16:00:00	AAPL	Stock	0.5325	0.5348	0.532	0.532	5669944.0
2004-06-07 17:00:00	AAPL	Stock	0.5321	0.5329	0.5321	0.5325	294840.0
2004-06-07 18:00:00	AAPL	Stock	0.533	0.533	0.533	0.533	18648.0
2004-06-07 08:00:00	MSFT	Stock	26.08	26.13	26.08	26.1	51310.0
2004-06-07 09:00:00	MSFT	Stock	26.1	26.14	25.95	26.11	6518636.0
2004-06-07 10:00:00	MSFT	Stock	26.11	26.14	26.05	26.08	6235714.0
2004-06-07 11:00:00	MSFT	Stock	26.07	26.2	26.07	26.17	10817741.0
2004-06-07 12:00:00	MSFT	Stock	26.17	26.25	26.1399	26.17	6308696.0
2004-06-07 13:00:00	MSFT	Stock	26.16	26.241	26.15	26.22	6465520.0
2004-06-07 14:00:00	MSFT	Stock	26.22	26.27	26.16	26.25	9578654.0
2004-06-07 15:00:00	MSFT	Stock	26.25	26.43	26.24	26.41	15994842.0
2004-06-07 16:00:00	MSFT	Stock	26.4	26.485	26.36	26.4329	1480489.0
2004-06-07 17:00:00	MSFT	Stock	26.42	26.42	26.4	26.42	46857.0
2004-06-07 18:00:00	MSFT	Stock	26.4	26.42	26.4	26.41	4533.0
2004-06-07 08:00:00	NVDA	Stock	0.1869	0.1869	0.185	0.185	60000.0
2004-06-07 09:00:00	NVDA	Stock	0.1838	0.1858	0.1837	0.1841	75745080.0
2004-06-07 10:00:00	NVDA	Stock	0.1842	0.1846	0.1832	0.1845	73236720.0
2004-06-07 11:00:00	NVDA	Stock	0.1846	0.1853	0.1845	0.1849	53166960.0
2004-06-07 12:00:00	NVDA	Stock	0.1848	0.1856	0.1848	0.1853	71321040.0
2004-06-07 13:00:00	NVDA	Stock	0.1852	0.1879	0.1851	0.1876	67947960.0
2004-06-07 14:00:00	NVDA	Stock	0.1876	0.1891	0.1875	0.1887	65229120.0
2004-06-07 15:00:00	NVDA	Stock	0.1887	0.1888	0.1864	0.187	154660920.0
2004-06-07 16:00:00	NVDA	Stock	0.1869	0.1875	0.1865	0.1869	2267880.0
2004-06-07 17:00:00	NVDA	Stock	0.1861	0.1868	0.1854	0.1857	561480.0
2004-06-07 18:00:00	NVDA	Stock	0.1854	0.1862	0.1854	0.1862	324000.0
2004-06-07 08:00:00	AMZN	Stock	2.579	2.58	2.57	2.574	171000.0
2004-06-07 09:00:00	AMZN	Stock	2.574	2.5995	2.558	2.585	23356280.0
2004-06-07 10:00:00	AMZN	Stock	2.5855	2.5905	2.5325	2.542	35506560.0
2004-06-07 11:00:00	AMZN	Stock	2.542	2.5655	2.5415	2.559	24107920.0
2004-06-07 12:00:00	AMZN	Stock	2.5595	2.5665	2.5575	2.5605	9139240.0
2004-06-07 13:00:00	AMZN	Stock	2.561	2.575	2.5595	2.5705	13886360.0
2004-06-07 14:00:00	AMZN	Stock	2.5705	2.5745	2.5595	2.5675	9213140.0
2004-06-07 15:00:00	AMZN	Stock	2.568	2.59	2.5625	2.588	28311380.0
2004-06-07 16:00:00	AMZN	Stock	2.5875	2.5965	2.5676	2.5868	4715940.0
2004-06-07 17:00:00	AMZN	Stock	2.5885	2.5905	2.588	2.5905	523920.0
2004-06-07 18:00:00	AMZN	Stock	2.588	2.591	2.585	2.586	46000.0
2004-06-07 09:00:00	CL	Stock	28.465	28.63	28.465	28.585	189600.0
2004-06-07 10:00:00	CL	Stock	28.585	28.71	28.56	28.65	245800.0
2004-06-07 11:00:00	CL	Stock	28.63	28.695	28.6	28.65	210000.0
2004-06-07 12:00:00	CL	Stock	28.655	28.74	28.63	28.735	165200.0
2004-06-07 13:00:00	CL	Stock	28.725	28.75	28.675	28.75	275400.0
2004-06-07 14:00:00	CL	Stock	28.745	28.785	28.69	28.76	258400.0

> showing 50 of 24,215 rows — these rows as CSV

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