PREVIEW / stock_1hour / 2008-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-17.parquet
  size:    800 KB
  rows:    40,065
  symbols: 3,329

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-17 05:00:00	AAPL	Stock	3.6268	3.6268	3.6268	3.6268	40600.0
2008-10-17 07:00:00	AAPL	Stock	3.6175	3.6789	3.6175	3.6721	410172.0
2008-10-17 08:00:00	AAPL	Stock	3.6879	3.7268	3.5846	3.6071	6654424.0
2008-10-17 09:00:00	AAPL	Stock	3.6043	3.6043	3.5059	3.5686	291638620.0
2008-10-17 10:00:00	AAPL	Stock	3.5693	3.5886	3.48	3.5589	290292268.0
2008-10-17 11:00:00	AAPL	Stock	3.5589	3.59	3.5	3.5079	177870560.0
2008-10-17 12:00:00	AAPL	Stock	3.5079	3.5707	3.5036	3.5593	146891248.0
2008-10-17 13:00:00	AAPL	Stock	3.5589	3.6443	3.5414	3.585	268213736.0
2008-10-17 14:00:00	AAPL	Stock	3.5839	3.6157	3.5	3.5318	220336508.0
2008-10-17 15:00:00	AAPL	Stock	3.5321	3.5707	3.4646	3.4768	320957616.0
2008-10-17 16:00:00	AAPL	Stock	3.4764	3.5417	3.0664	3.4714	20496112.0
2008-10-17 17:00:00	AAPL	Stock	3.4714	3.4875	3.4714	3.475	664020.0
2008-10-17 18:00:00	AAPL	Stock	3.4786	3.4857	3.4679	3.4786	1320396.0
2008-10-17 19:00:00	AAPL	Stock	3.4689	3.4768	3.4464	3.4714	420196.0
2008-10-17 04:00:00	MSFT	Stock	24.1	24.1	24.1	24.1	100.0
2008-10-17 07:00:00	MSFT	Stock	23.9	23.9	23.9	23.9	4628.0
2008-10-17 08:00:00	MSFT	Stock	23.57	23.96	23.57	23.62	27125.0
2008-10-17 09:00:00	MSFT	Stock	23.65	24.0	23.31	23.93	20979868.0
2008-10-17 10:00:00	MSFT	Stock	23.93	24.45	23.66	24.13	18667052.0
2008-10-17 11:00:00	MSFT	Stock	24.14	24.4	23.99	24.095	12885389.0
2008-10-17 12:00:00	MSFT	Stock	24.09	24.75	24.04	24.65	10788262.0
2008-10-17 13:00:00	MSFT	Stock	24.65	25.11	24.6	24.92	17717670.0
2008-10-17 14:00:00	MSFT	Stock	24.91	25.0	24.32	24.56	15724271.0
2008-10-17 15:00:00	MSFT	Stock	24.56	24.76	23.86	23.9	29432829.0
2008-10-17 16:00:00	MSFT	Stock	23.91	24.279	23.85	23.99	5909536.0
2008-10-17 17:00:00	MSFT	Stock	23.99	23.99	23.96	23.96	5996.0
2008-10-17 18:00:00	MSFT	Stock	23.93	24.0	23.93	23.96	17950.0
2008-10-17 19:00:00	MSFT	Stock	23.94	24.0	23.91	23.92	1890.0
2008-10-17 07:00:00	NVDA	Stock	0.192	0.192	0.192	0.192	40000.0
2008-10-17 08:00:00	NVDA	Stock	0.1875	0.1918	0.1825	0.1858	614000.0
2008-10-17 09:00:00	NVDA	Stock	0.1863	0.1962	0.1835	0.195	156587000.0
2008-10-17 10:00:00	NVDA	Stock	0.1948	0.1958	0.1853	0.1883	132195360.0
2008-10-17 11:00:00	NVDA	Stock	0.1881	0.1925	0.1881	0.1925	92121920.0
2008-10-17 12:00:00	NVDA	Stock	0.1925	0.197	0.1924	0.1962	92552200.0
2008-10-17 13:00:00	NVDA	Stock	0.1962	0.2023	0.196	0.1998	93894880.0
2008-10-17 14:00:00	NVDA	Stock	0.1998	0.2013	0.194	0.1965	93130080.0
2008-10-17 15:00:00	NVDA	Stock	0.1962	0.1988	0.1903	0.1915	154026080.0
2008-10-17 16:00:00	NVDA	Stock	0.1923	0.1939	0.1903	0.1913	1831440.0
2008-10-17 17:00:00	NVDA	Stock	0.1913	0.1913	0.1913	0.1913	8000.0
2008-10-17 18:00:00	NVDA	Stock	0.1913	0.1928	0.1913	0.1928	17000.0
2008-10-17 19:00:00	NVDA	Stock	0.1928	0.1928	0.1928	0.1928	8000.0
2008-10-17 07:00:00	AMZN	Stock	2.5	2.5	2.5	2.5	2000.0
2008-10-17 08:00:00	AMZN	Stock	2.5	2.5	2.461	2.461	131660.0
2008-10-17 09:00:00	AMZN	Stock	2.475	2.528	2.4205	2.517	43339960.0
2008-10-17 10:00:00	AMZN	Stock	2.519	2.597	2.4985	2.5845	39759840.0
2008-10-17 11:00:00	AMZN	Stock	2.5855	2.6185	2.5525	2.5735	25122060.0
2008-10-17 12:00:00	AMZN	Stock	2.573	2.695	2.55	2.6895	30483140.0
2008-10-17 13:00:00	AMZN	Stock	2.6897	2.7215	2.645	2.688	26876560.0
2008-10-17 14:00:00	AMZN	Stock	2.688	2.717	2.612	2.642	38908780.0
2008-10-17 15:00:00	AMZN	Stock	2.6435	2.6875	2.533	2.562	44008460.0

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

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