PREVIEW / stock_1hour / 2008-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-12.parquet
  size:    791 KB
  rows:    40,232
  symbols: 3,345

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-12 06:00:00	AAPL	Stock	3.3139	3.3139	3.3139	3.3139	3780.0
2008-12-12 07:00:00	AAPL	Stock	3.3054	3.3054	3.3054	3.3054	2800.0
2008-12-12 08:00:00	AAPL	Stock	3.3036	3.3386	3.2882	3.3214	2793112.0
2008-12-12 09:00:00	AAPL	Stock	3.3214	3.4186	3.3046	3.41	121609320.0
2008-12-12 10:00:00	AAPL	Stock	3.4111	3.4796	3.4093	3.4675	167187468.0
2008-12-12 11:00:00	AAPL	Stock	3.4671	3.4904	3.4268	3.4464	114193128.0
2008-12-12 12:00:00	AAPL	Stock	3.4475	3.5147	3.4279	3.5071	112590268.0
2008-12-12 13:00:00	AAPL	Stock	3.5064	3.5196	3.4664	3.4899	133946372.0
2008-12-12 14:00:00	AAPL	Stock	3.4896	3.5286	3.4646	3.5121	175560784.0
2008-12-12 15:00:00	AAPL	Stock	3.5121	3.5357	3.4871	3.5132	188470380.0
2008-12-12 16:00:00	AAPL	Stock	3.5131	3.5271	3.4091	3.5143	14155148.0
2008-12-12 17:00:00	AAPL	Stock	3.5143	3.5196	3.5143	3.5179	238980.0
2008-12-12 18:00:00	AAPL	Stock	3.5179	3.5196	3.5096	3.5196	1465044.0
2008-12-12 19:00:00	AAPL	Stock	3.5214	3.5243	3.5179	3.5239	176288.0
2008-12-12 07:00:00	MSFT	Stock	18.79	19.1	18.79	18.85	6658.0
2008-12-12 08:00:00	MSFT	Stock	18.86	19.05	18.85	19.0	79869.0
2008-12-12 09:00:00	MSFT	Stock	18.95	19.85	18.95	19.12	8369508.0
2008-12-12 10:00:00	MSFT	Stock	19.11	19.36	18.7	19.319	20388178.0
2008-12-12 11:00:00	MSFT	Stock	19.312	19.4	19.05	19.27	7930812.0
2008-12-12 12:00:00	MSFT	Stock	19.27	19.59	19.24	19.522	6224900.0
2008-12-12 13:00:00	MSFT	Stock	19.53	19.57	19.1	19.182	6469022.0
2008-12-12 14:00:00	MSFT	Stock	19.18	19.5	19.15	19.44	8710106.0
2008-12-12 15:00:00	MSFT	Stock	19.44	19.53	19.1	19.34	16438907.0
2008-12-12 16:00:00	MSFT	Stock	19.35	19.54	19.19	19.4	2893436.0
2008-12-12 17:00:00	MSFT	Stock	19.4	19.48	19.4	19.48	14140.0
2008-12-12 18:00:00	MSFT	Stock	19.43	19.47	19.4	19.41	13660.0
2008-12-12 19:00:00	MSFT	Stock	19.42	19.47	19.4	19.47	4600.0
2008-12-12 07:00:00	NVDA	Stock	0.1952	0.1952	0.1938	0.1938	99600.0
2008-12-12 08:00:00	NVDA	Stock	0.197	0.2	0.1903	0.1975	658520.0
2008-12-12 09:00:00	NVDA	Stock	0.1975	0.2015	0.1948	0.2013	111119440.0
2008-12-12 10:00:00	NVDA	Stock	0.2015	0.2088	0.1975	0.2078	153560240.0
2008-12-12 11:00:00	NVDA	Stock	0.2078	0.21	0.203	0.2053	56537040.0
2008-12-12 12:00:00	NVDA	Stock	0.2055	0.21	0.2055	0.2098	41391240.0
2008-12-12 13:00:00	NVDA	Stock	0.2098	0.211	0.2068	0.2102	58230400.0
2008-12-12 14:00:00	NVDA	Stock	0.21	0.215	0.2085	0.2148	91125680.0
2008-12-12 15:00:00	NVDA	Stock	0.2145	0.2163	0.212	0.2152	140181600.0
2008-12-12 16:00:00	NVDA	Stock	0.2145	0.217	0.2078	0.2168	3359120.0
2008-12-12 17:00:00	NVDA	Stock	0.217	0.217	0.215	0.215	104000.0
2008-12-12 19:00:00	NVDA	Stock	0.2163	0.2163	0.2163	0.2163	12000.0
2008-12-12 05:00:00	AMZN	Stock	2.3805	2.3805	2.3805	2.3805	9880.0
2008-12-12 08:00:00	AMZN	Stock	2.3535	2.368	2.337	2.3625	167720.0
2008-12-12 09:00:00	AMZN	Stock	2.3575	2.508	2.3575	2.476	27527700.0
2008-12-12 10:00:00	AMZN	Stock	2.475	2.548	2.47	2.523	34388320.0
2008-12-12 11:00:00	AMZN	Stock	2.5235	2.5425	2.488	2.491	15946660.0
2008-12-12 12:00:00	AMZN	Stock	2.4908	2.5295	2.4865	2.515	10526340.0
2008-12-12 13:00:00	AMZN	Stock	2.516	2.5195	2.4755	2.4905	12264540.0
2008-12-12 14:00:00	AMZN	Stock	2.491	2.5615	2.4825	2.55	22124040.0
2008-12-12 15:00:00	AMZN	Stock	2.55	2.569	2.5215	2.567	44971500.0
2008-12-12 16:00:00	AMZN	Stock	2.5585	2.5765	2.5565	2.567	908340.0
2008-12-12 18:00:00	AMZN	Stock	2.567	2.5775	2.567	2.5775	33120.0

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

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