PREVIEW / stock_1hour / 2008-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-20.parquet
  size:    809 KB
  rows:    40,363
  symbols: 3,279

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-02-20 05:00:00	AAPL	Stock	4.3679	4.3679	4.3668	4.3668	28000.0
2008-02-20 06:00:00	AAPL	Stock	4.3625	4.3625	4.3571	4.3571	11200.0
2008-02-20 07:00:00	AAPL	Stock	4.3611	4.3771	4.3518	4.3629	447020.0
2008-02-20 08:00:00	AAPL	Stock	4.3714	4.3771	4.3343	4.3482	5105016.0
2008-02-20 09:00:00	AAPL	Stock	4.3486	4.4107	4.3429	4.3796	134194956.0
2008-02-20 10:00:00	AAPL	Stock	4.3793	4.4025	4.3539	4.3607	154296492.0
2008-02-20 11:00:00	AAPL	Stock	4.3607	4.3975	4.3571	4.39	98744044.0
2008-02-20 12:00:00	AAPL	Stock	4.3904	4.4286	4.3857	4.4082	142063992.0
2008-02-20 13:00:00	AAPL	Stock	4.4082	4.45	4.3786	4.3996	128967076.0
2008-02-20 14:00:00	AAPL	Stock	4.3993	4.42	4.3664	4.4061	157414768.0
2008-02-20 15:00:00	AAPL	Stock	4.4064	4.4214	4.3768	4.42	132157984.0
2008-02-20 16:00:00	AAPL	Stock	4.4211	4.4225	4.377	4.4164	12501020.0
2008-02-20 17:00:00	AAPL	Stock	4.4193	4.4311	4.4168	4.4282	481348.0
2008-02-20 18:00:00	AAPL	Stock	4.4268	4.4375	4.4254	4.4375	507780.0
2008-02-20 19:00:00	AAPL	Stock	4.4321	4.4446	4.4221	4.4411	623392.0
2008-02-20 07:00:00	MSFT	Stock	28.13	28.13	28.12	28.12	750.0
2008-02-20 08:00:00	MSFT	Stock	28.17	28.24	28.06	28.1	300268.0
2008-02-20 09:00:00	MSFT	Stock	28.1	28.25	27.97	28.07	8824680.0
2008-02-20 10:00:00	MSFT	Stock	28.08	28.2	27.92	28.04	17862666.0
2008-02-20 11:00:00	MSFT	Stock	28.05	28.06	27.99	28.04	9848365.0
2008-02-20 12:00:00	MSFT	Stock	28.04	28.19	28.0	28.1	15263494.0
2008-02-20 13:00:00	MSFT	Stock	28.11	28.21	27.97	28.08	9980581.0
2008-02-20 14:00:00	MSFT	Stock	28.08	28.18	28.01	28.15	13477518.0
2008-02-20 15:00:00	MSFT	Stock	28.15	28.26	28.11	28.23	15153144.0
2008-02-20 16:00:00	MSFT	Stock	28.21	28.27	27.996	28.22	2375085.0
2008-02-20 17:00:00	MSFT	Stock	28.23	28.24	28.185	28.24	33620.0
2008-02-20 18:00:00	MSFT	Stock	28.24	28.25	28.19	28.24	204732.0
2008-02-20 19:00:00	MSFT	Stock	28.24	28.24	28.22	28.22	21316.0
2008-02-20 20:00:00	MSFT	Stock	28.22	28.22	28.22	28.22	100.0
2008-02-20 07:00:00	NVDA	Stock	0.5492	0.5492	0.5492	0.5492	7200.0
2008-02-20 08:00:00	NVDA	Stock	0.5485	0.55	0.5412	0.5462	3866200.0
2008-02-20 09:00:00	NVDA	Stock	0.5448	0.546	0.5262	0.5335	118644840.0
2008-02-20 10:00:00	NVDA	Stock	0.5338	0.5428	0.5325	0.5365	101075440.0
2008-02-20 11:00:00	NVDA	Stock	0.5367	0.5395	0.535	0.5385	49748880.0
2008-02-20 12:00:00	NVDA	Stock	0.5382	0.546	0.537	0.541	102440120.0
2008-02-20 13:00:00	NVDA	Stock	0.541	0.546	0.539	0.5445	78130520.0
2008-02-20 14:00:00	NVDA	Stock	0.5447	0.5525	0.5412	0.551	123982520.0
2008-02-20 15:00:00	NVDA	Stock	0.5509	0.551	0.543	0.545	133194280.0
2008-02-20 16:00:00	NVDA	Stock	0.5442	0.5468	0.5375	0.5405	32188120.0
2008-02-20 17:00:00	NVDA	Stock	0.5425	0.545	0.5425	0.545	210640.0
2008-02-20 18:00:00	NVDA	Stock	0.5428	0.5455	0.5428	0.5455	48000.0
2008-02-20 19:00:00	NVDA	Stock	0.544	0.5458	0.544	0.5458	201920.0
2008-02-20 07:00:00	AMZN	Stock	3.5775	3.5775	3.5775	3.5775	6000.0
2008-02-20 08:00:00	AMZN	Stock	3.575	3.594	3.57	3.5755	94840.0
2008-02-20 09:00:00	AMZN	Stock	3.575	3.6175	3.555	3.6085	17508540.0
2008-02-20 10:00:00	AMZN	Stock	3.6085	3.6805	3.587	3.65	26587760.0
2008-02-20 11:00:00	AMZN	Stock	3.648	3.654	3.598	3.6255	12990500.0
2008-02-20 12:00:00	AMZN	Stock	3.626	3.675	3.6175	3.6335	16557280.0
2008-02-20 13:00:00	AMZN	Stock	3.6345	3.67	3.629	3.6575	13821640.0
2008-02-20 14:00:00	AMZN	Stock	3.6575	3.694	3.6405	3.6855	19405920.0

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

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