PREVIEW / stock_1hour / 2006-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-10.parquet
  size:    623 KB
  rows:    29,812
  symbols: 2,442

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
2006-11-10 07:00:00	AAPL	Stock	2.9857	2.9857	2.9857	2.9857	2800.0
2006-11-10 08:00:00	AAPL	Stock	2.985	2.9907	2.9786	2.9875	1000608.0
2006-11-10 09:00:00	AAPL	Stock	2.9857	2.9879	2.9464	2.9579	89108880.0
2006-11-10 10:00:00	AAPL	Stock	2.9579	2.9757	2.9511	2.9643	78322608.0
2006-11-10 11:00:00	AAPL	Stock	2.9643	2.9661	2.95	2.9539	40555004.0
2006-11-10 12:00:00	AAPL	Stock	2.9539	2.96	2.9511	2.9579	25330172.0
2006-11-10 13:00:00	AAPL	Stock	2.9579	2.9646	2.9518	2.9625	29981476.0
2006-11-10 14:00:00	AAPL	Stock	2.9629	2.9757	2.9596	2.9704	37316272.0
2006-11-10 15:00:00	AAPL	Stock	2.9704	2.9732	2.9607	2.9686	58388568.0
2006-11-10 16:00:00	AAPL	Stock	2.9696	2.9721	2.9679	2.9707	1419236.0
2006-11-10 17:00:00	AAPL	Stock	2.9707	2.9711	2.9686	2.9707	4733988.0
2006-11-10 18:00:00	AAPL	Stock	2.9707	2.9711	2.9696	2.97	134064.0
2006-11-10 19:00:00	AAPL	Stock	2.97	2.9707	2.9682	2.9707	296968.0
2006-11-10 08:00:00	MSFT	Stock	29.22	29.3	29.22	29.24	6133.0
2006-11-10 09:00:00	MSFT	Stock	29.22	29.29	29.15	29.24	4589001.0
2006-11-10 10:00:00	MSFT	Stock	29.25	29.28	29.2	29.23	5289067.0
2006-11-10 11:00:00	MSFT	Stock	29.23	29.29	29.22	29.23	4168807.0
2006-11-10 12:00:00	MSFT	Stock	29.24	29.28	29.21	29.23	3423886.0
2006-11-10 13:00:00	MSFT	Stock	29.24	29.24	29.19	29.21	3193534.0
2006-11-10 14:00:00	MSFT	Stock	29.21	29.28	29.2	29.25	3844165.0
2006-11-10 15:00:00	MSFT	Stock	29.25	29.28	29.2	29.27	5330270.0
2006-11-10 16:00:00	MSFT	Stock	29.24	29.27	29.23	29.23	56874.0
2006-11-10 17:00:00	MSFT	Stock	29.24	29.26	29.24	29.26	871320.0
2006-11-10 18:00:00	MSFT	Stock	29.24	29.24	29.23	29.23	1150.0
2006-11-10 19:00:00	MSFT	Stock	29.25	29.26	29.25	29.26	4944.0
2006-11-10 06:00:00	NVDA	Stock	0.5935	0.5935	0.5935	0.5935	90000.0
2006-11-10 07:00:00	NVDA	Stock	0.596	0.6035	0.581	0.5875	9115440.0
2006-11-10 08:00:00	NVDA	Stock	0.588	0.5983	0.5833	0.5933	30681180.0
2006-11-10 09:00:00	NVDA	Stock	0.5933	0.596	0.5687	0.5808	340795380.0
2006-11-10 10:00:00	NVDA	Stock	0.5805	0.5835	0.568	0.5688	256615440.0
2006-11-10 11:00:00	NVDA	Stock	0.5688	0.5688	0.5595	0.5662	190770960.0
2006-11-10 12:00:00	NVDA	Stock	0.566	0.5725	0.5658	0.5707	114717660.0
2006-11-10 13:00:00	NVDA	Stock	0.5707	0.5717	0.5675	0.5693	78574260.0
2006-11-10 14:00:00	NVDA	Stock	0.5692	0.5715	0.5677	0.5702	92125020.0
2006-11-10 15:00:00	NVDA	Stock	0.5702	0.5747	0.565	0.5743	186930060.0
2006-11-10 16:00:00	NVDA	Stock	0.574	0.5748	0.5727	0.5748	3029340.0
2006-11-10 17:00:00	NVDA	Stock	0.5748	0.575	0.5748	0.575	339900.0
2006-11-10 18:00:00	NVDA	Stock	0.575	0.5757	0.575	0.575	309000.0
2006-11-10 19:00:00	NVDA	Stock	0.5733	0.5733	0.5733	0.5733	18000.0
2006-11-10 08:00:00	AMZN	Stock	1.94	1.9625	1.94	1.9405	32960.0
2006-11-10 09:00:00	AMZN	Stock	1.941	1.947	1.938	1.9445	7322620.0
2006-11-10 10:00:00	AMZN	Stock	1.9445	1.9585	1.9445	1.957	13997540.0
2006-11-10 11:00:00	AMZN	Stock	1.9575	1.958	1.9485	1.953	12168720.0
2006-11-10 12:00:00	AMZN	Stock	1.953	1.967	1.953	1.9645	9289540.0
2006-11-10 13:00:00	AMZN	Stock	1.965	1.9681	1.957	1.96	9000640.0
2006-11-10 14:00:00	AMZN	Stock	1.96	1.9655	1.959	1.962	11343200.0
2006-11-10 15:00:00	AMZN	Stock	1.962	1.964	1.9565	1.963	19617660.0
2006-11-10 16:00:00	AMZN	Stock	1.963	1.9715	1.963	1.965	323260.0
2006-11-10 17:00:00	AMZN	Stock	1.964	1.964	1.964	1.964	100000.0
2006-11-10 18:00:00	AMZN	Stock	1.964	1.9645	1.964	1.9645	10000.0

> showing 50 of 29,812 rows — these rows as CSV

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