PREVIEW / stock_1hour / 2008-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-24.parquet
  size:    816 KB
  rows:    41,582
  symbols: 3,377

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-24 06:00:00	AAPL	Stock	2.9679	2.9679	2.9679	2.9679	2800.0
2008-11-24 07:00:00	AAPL	Stock	3.0	3.0357	2.9954	3.0071	432824.0
2008-11-24 08:00:00	AAPL	Stock	3.0071	3.0157	2.9911	3.0089	2233588.0
2008-11-24 09:00:00	AAPL	Stock	3.0082	3.0982	3.0071	3.0618	160904380.0
2008-11-24 10:00:00	AAPL	Stock	3.0618	3.2054	3.0589	3.2039	272186768.0
2008-11-24 11:00:00	AAPL	Stock	3.2039	3.2411	3.1743	3.222	183161272.0
2008-11-24 12:00:00	AAPL	Stock	3.2218	3.2457	3.175	3.2071	153732320.0
2008-11-24 13:00:00	AAPL	Stock	3.2079	3.2289	3.1839	3.2271	104103104.0
2008-11-24 14:00:00	AAPL	Stock	3.2268	3.29	3.1964	3.2789	191229108.0
2008-11-24 15:00:00	AAPL	Stock	3.2782	3.3854	3.2464	3.3136	316590512.0
2008-11-24 16:00:00	AAPL	Stock	3.3118	3.3271	3.2102	3.3007	46400592.0
2008-11-24 17:00:00	AAPL	Stock	3.2993	3.3143	3.0393	3.3018	656572.0
2008-11-24 18:00:00	AAPL	Stock	3.3018	3.3107	3.3	3.3075	163324.0
2008-11-24 19:00:00	AAPL	Stock	3.3043	3.3157	3.3036	3.3143	340732.0
2008-11-24 04:00:00	MSFT	Stock	19.75	19.75	19.75	19.75	100.0
2008-11-24 05:00:00	MSFT	Stock	19.89	19.89	19.89	19.89	449.0
2008-11-24 07:00:00	MSFT	Stock	19.89	19.99	19.89	19.96	9550.0
2008-11-24 08:00:00	MSFT	Stock	19.95	19.99	19.7	19.9	44824.0
2008-11-24 09:00:00	MSFT	Stock	19.9	20.47	19.84	20.4	9723548.0
2008-11-24 10:00:00	MSFT	Stock	20.41	20.94	20.39	20.7	20710715.0
2008-11-24 11:00:00	MSFT	Stock	20.7	20.72	20.4	20.53	16609752.0
2008-11-24 12:00:00	MSFT	Stock	20.54	20.58	20.14	20.38	11979413.0
2008-11-24 13:00:00	MSFT	Stock	20.39	20.472	20.22	20.45	9083900.0
2008-11-24 14:00:00	MSFT	Stock	20.455	20.5	20.27	20.43	12122208.0
2008-11-24 15:00:00	MSFT	Stock	20.44	20.912	20.26	20.69	30204385.0
2008-11-24 16:00:00	MSFT	Stock	20.69	20.77	20.43	20.55	12641496.0
2008-11-24 17:00:00	MSFT	Stock	20.55	20.57	19.9	20.55	19700.0
2008-11-24 18:00:00	MSFT	Stock	20.55	20.58	20.54	20.58	3645.0
2008-11-24 19:00:00	MSFT	Stock	20.55	20.6	20.54	20.6	6603.0
2008-11-24 08:00:00	NVDA	Stock	0.166	0.167	0.166	0.1662	268480.0
2008-11-24 09:00:00	NVDA	Stock	0.1658	0.1693	0.16	0.164	56824680.0
2008-11-24 10:00:00	NVDA	Stock	0.164	0.1672	0.1638	0.1672	130751000.0
2008-11-24 11:00:00	NVDA	Stock	0.1672	0.1682	0.1645	0.168	61680200.0
2008-11-24 12:00:00	NVDA	Stock	0.168	0.1685	0.1648	0.165	56414840.0
2008-11-24 13:00:00	NVDA	Stock	0.1648	0.1672	0.1635	0.1672	52305200.0
2008-11-24 14:00:00	NVDA	Stock	0.167	0.168	0.1652	0.1665	65970800.0
2008-11-24 15:00:00	NVDA	Stock	0.1665	0.172	0.1658	0.17	141799040.0
2008-11-24 16:00:00	NVDA	Stock	0.1698	0.1708	0.1654	0.1708	30883080.0
2008-11-24 17:00:00	NVDA	Stock	0.1718	0.1718	0.1718	0.1718	6000.0
2008-11-24 18:00:00	NVDA	Stock	0.1715	0.1718	0.1715	0.1718	120000.0
2008-11-24 19:00:00	NVDA	Stock	0.1715	0.1715	0.1715	0.1715	28000.0
2008-11-24 05:00:00	AMZN	Stock	1.8935	1.8935	1.8935	1.8935	4000.0
2008-11-24 08:00:00	AMZN	Stock	1.925	1.925	1.9	1.925	96300.0
2008-11-24 09:00:00	AMZN	Stock	1.9245	2.012	1.9085	1.983	42849600.0
2008-11-24 10:00:00	AMZN	Stock	1.983	2.0495	1.955	2.0355	40806800.0
2008-11-24 11:00:00	AMZN	Stock	2.035	2.064	2.021	2.0485	27231640.0
2008-11-24 12:00:00	AMZN	Stock	2.049	2.0715	2.0015	2.064	27903300.0
2008-11-24 13:00:00	AMZN	Stock	2.0645	2.097	2.0475	2.096	25624820.0
2008-11-24 14:00:00	AMZN	Stock	2.0955	2.123	2.0635	2.1133	33529520.0
2008-11-24 15:00:00	AMZN	Stock	2.113	2.172	2.084	2.12	72772080.0

> showing 50 of 41,582 rows — these rows as CSV

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