PREVIEW / stock_1hour / 2008-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-10.parquet
  size:    887 KB
  rows:    45,053
  symbols: 3,414

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-10 04:00:00	AAPL	Stock	3.1179	3.1207	3.1179	3.1207	56000.0
2008-10-10 05:00:00	AAPL	Stock	3.0714	3.1211	3.0361	3.0536	195328.0
2008-10-10 06:00:00	AAPL	Stock	3.0696	3.0889	3.0536	3.0875	59276.0
2008-10-10 07:00:00	AAPL	Stock	3.1064	3.1586	3.0796	3.0811	766528.0
2008-10-10 08:00:00	AAPL	Stock	3.1007	3.1107	3.0375	3.0411	5241068.0
2008-10-10 09:00:00	AAPL	Stock	3.0425	3.3357	3.0039	3.3086	265536964.0
2008-10-10 10:00:00	AAPL	Stock	3.3071	3.4643	3.2357	3.2971	390048148.0
2008-10-10 11:00:00	AAPL	Stock	3.2975	3.3429	3.2143	3.2468	266998648.0
2008-10-10 12:00:00	AAPL	Stock	3.2464	3.3496	3.2389	3.3382	226190020.0
2008-10-10 13:00:00	AAPL	Stock	3.3386	3.4107	3.2843	3.3093	240247700.0
2008-10-10 14:00:00	AAPL	Stock	3.3082	3.4086	3.2539	3.2921	291098444.0
2008-10-10 15:00:00	AAPL	Stock	3.2921	3.5714	3.2721	3.4696	426720616.0
2008-10-10 16:00:00	AAPL	Stock	3.4796	3.532	3.3333	3.4786	69147512.0
2008-10-10 17:00:00	AAPL	Stock	3.4786	3.4982	3.4571	3.4786	492324.0
2008-10-10 18:00:00	AAPL	Stock	3.4571	3.5	3.4464	3.4911	718200.0
2008-10-10 19:00:00	AAPL	Stock	3.4857	3.4857	3.4571	3.4696	390404.0
2008-10-10 04:00:00	MSFT	Stock	21.7	21.7	21.7	21.7	200.0
2008-10-10 05:00:00	MSFT	Stock	21.7	21.7	21.67	21.67	16516.0
2008-10-10 06:00:00	MSFT	Stock	21.66	21.75	21.65	21.75	3100.0
2008-10-10 07:00:00	MSFT	Stock	22.1	22.21	21.9	21.9	16271.0
2008-10-10 08:00:00	MSFT	Stock	21.9	22.01	21.76	21.8	150945.0
2008-10-10 09:00:00	MSFT	Stock	21.8	22.2	20.65	21.8	26980545.0
2008-10-10 10:00:00	MSFT	Stock	21.79	22.29	20.85	21.12	35858472.0
2008-10-10 11:00:00	MSFT	Stock	21.12	21.53	20.85	21.014	28610955.0
2008-10-10 12:00:00	MSFT	Stock	21.014	21.57	20.86	21.32	22284267.0
2008-10-10 13:00:00	MSFT	Stock	21.32	21.38	20.75	20.8	19497335.0
2008-10-10 14:00:00	MSFT	Stock	20.82	21.41	20.76	21.02	21330719.0
2008-10-10 15:00:00	MSFT	Stock	21.01	22.35	20.98	21.5	52940700.0
2008-10-10 16:00:00	MSFT	Stock	21.5	22.65	21.387	21.9	12082289.0
2008-10-10 17:00:00	MSFT	Stock	21.407	22.052	21.407	21.98	445587.0
2008-10-10 18:00:00	MSFT	Stock	21.5	22.0	21.5	21.99	55500.0
2008-10-10 19:00:00	MSFT	Stock	21.9	21.9	21.8	21.9	6312.0
2008-10-10 08:00:00	NVDA	Stock	0.1713	0.1713	0.165	0.167	1262800.0
2008-10-10 09:00:00	NVDA	Stock	0.167	0.1753	0.157	0.1728	142275840.0
2008-10-10 10:00:00	NVDA	Stock	0.1725	0.1778	0.1645	0.168	196830640.0
2008-10-10 11:00:00	NVDA	Stock	0.1682	0.177	0.162	0.1625	128888640.0
2008-10-10 12:00:00	NVDA	Stock	0.1625	0.1682	0.1622	0.1648	125278880.0
2008-10-10 13:00:00	NVDA	Stock	0.1648	0.165	0.159	0.1622	109120560.0
2008-10-10 14:00:00	NVDA	Stock	0.1622	0.1675	0.1585	0.1592	131053960.0
2008-10-10 15:00:00	NVDA	Stock	0.159	0.1833	0.1588	0.1705	310066680.0
2008-10-10 16:00:00	NVDA	Stock	0.1703	0.1782	0.1589	0.1703	15707520.0
2008-10-10 17:00:00	NVDA	Stock	0.1658	0.1703	0.1658	0.1703	239640.0
2008-10-10 18:00:00	NVDA	Stock	0.1703	0.1725	0.1703	0.1725	90000.0
2008-10-10 19:00:00	NVDA	Stock	0.1725	0.1745	0.1725	0.174	224000.0
2008-10-10 05:00:00	AMZN	Stock	2.7	2.7	2.6805	2.6805	4940.0
2008-10-10 06:00:00	AMZN	Stock	2.6755	2.6755	2.6755	2.6755	2000.0
2008-10-10 07:00:00	AMZN	Stock	2.71	2.775	2.71	2.71	54920.0
2008-10-10 08:00:00	AMZN	Stock	2.753	2.8	2.6625	2.8	1279740.0
2008-10-10 09:00:00	AMZN	Stock	2.6755	2.797	2.5525	2.736	66885060.0
2008-10-10 10:00:00	AMZN	Stock	2.7375	2.9	2.6995	2.722	57405020.0

> showing 50 of 45,053 rows — these rows as CSV

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