PREVIEW / stock_1hour / 2006-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-31.parquet
  size:    640 KB
  rows:    30,471
  symbols: 2,436

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-10-31 07:00:00	AAPL	Stock	2.8918	2.8932	2.8918	2.8918	134400.0
2006-10-31 08:00:00	AAPL	Stock	2.8946	2.9143	2.8911	2.9104	3543428.0
2006-10-31 09:00:00	AAPL	Stock	2.9104	2.9179	2.8864	2.8982	95347980.0
2006-10-31 10:00:00	AAPL	Stock	2.8986	2.9168	2.8914	2.9139	79678480.0
2006-10-31 11:00:00	AAPL	Stock	2.9139	2.9171	2.8943	2.8968	55651876.0
2006-10-31 12:00:00	AAPL	Stock	2.8971	2.8982	2.8654	2.8754	78653176.0
2006-10-31 13:00:00	AAPL	Stock	2.8754	2.8893	2.8686	2.8836	51239748.0
2006-10-31 14:00:00	AAPL	Stock	2.8836	2.8889	2.8725	2.8832	38887268.0
2006-10-31 15:00:00	AAPL	Stock	2.8832	2.8964	2.8786	2.8957	76719356.0
2006-10-31 16:00:00	AAPL	Stock	2.8943	2.8993	2.8929	2.8982	1788220.0
2006-10-31 17:00:00	AAPL	Stock	2.8982	2.8982	2.8964	2.8964	254072.0
2006-10-31 18:00:00	AAPL	Stock	2.8964	2.8982	2.895	2.8954	59556.0
2006-10-31 19:00:00	AAPL	Stock	2.8954	2.8971	2.8954	2.8954	21028.0
2006-10-31 08:00:00	MSFT	Stock	28.6	28.61	28.55	28.59	10697.0
2006-10-31 09:00:00	MSFT	Stock	28.59	28.73	28.57	28.68	5743190.0
2006-10-31 10:00:00	MSFT	Stock	28.68	28.84	28.56	28.81	10773407.0
2006-10-31 11:00:00	MSFT	Stock	28.81	28.85	28.68	28.71	7068318.0
2006-10-31 12:00:00	MSFT	Stock	28.7	28.71	28.58	28.68	4300380.0
2006-10-31 13:00:00	MSFT	Stock	28.68	28.69	28.61	28.67	3824140.0
2006-10-31 14:00:00	MSFT	Stock	28.66	28.67	28.58	28.65	4215778.0
2006-10-31 15:00:00	MSFT	Stock	28.65	28.75	28.63	28.69	10117306.0
2006-10-31 16:00:00	MSFT	Stock	28.69	28.78	28.68	28.71	2474123.0
2006-10-31 17:00:00	MSFT	Stock	28.71	28.72	28.71	28.71	826448.0
2006-10-31 19:00:00	MSFT	Stock	28.71	28.71	28.71	28.71	1000.0
2006-10-31 06:00:00	NVDA	Stock	0.5438	0.5438	0.5438	0.5438	9300.0
2006-10-31 07:00:00	NVDA	Stock	0.553	0.5558	0.553	0.5558	300000.0
2006-10-31 08:00:00	NVDA	Stock	0.5575	0.559	0.5542	0.5583	1077600.0
2006-10-31 09:00:00	NVDA	Stock	0.558	0.5705	0.5553	0.5675	134101200.0
2006-10-31 10:00:00	NVDA	Stock	0.5677	0.5728	0.5597	0.5715	149144220.0
2006-10-31 11:00:00	NVDA	Stock	0.5715	0.5747	0.5692	0.5705	111305100.0
2006-10-31 12:00:00	NVDA	Stock	0.5703	0.573	0.5673	0.5677	88007520.0
2006-10-31 13:00:00	NVDA	Stock	0.5675	0.5792	0.567	0.5775	132947340.0
2006-10-31 14:00:00	NVDA	Stock	0.5773	0.5795	0.575	0.5753	104586600.0
2006-10-31 15:00:00	NVDA	Stock	0.5752	0.5812	0.5747	0.5812	175477080.0
2006-10-31 16:00:00	NVDA	Stock	0.5812	0.5815	0.5805	0.5813	1954200.0
2006-10-31 17:00:00	NVDA	Stock	0.5802	0.5808	0.576	0.5808	700500.0
2006-10-31 18:00:00	NVDA	Stock	0.5813	0.5828	0.5812	0.5812	66000.0
2006-10-31 19:00:00	NVDA	Stock	0.579	0.579	0.579	0.579	9600.0
2006-10-31 08:00:00	AMZN	Stock	1.9	1.906	1.9	1.9055	66000.0
2006-10-31 09:00:00	AMZN	Stock	1.9055	1.9295	1.899	1.9085	21680480.0
2006-10-31 10:00:00	AMZN	Stock	1.9085	1.918	1.894	1.9065	20532220.0
2006-10-31 11:00:00	AMZN	Stock	1.907	1.907	1.8985	1.899	10673520.0
2006-10-31 12:00:00	AMZN	Stock	1.899	1.904	1.89	1.891	15940140.0
2006-10-31 13:00:00	AMZN	Stock	1.891	1.9015	1.8905	1.898	8931900.0
2006-10-31 14:00:00	AMZN	Stock	1.8984	1.905	1.8945	1.898	11963040.0
2006-10-31 15:00:00	AMZN	Stock	1.898	1.913	1.8965	1.9035	26005300.0
2006-10-31 16:00:00	AMZN	Stock	1.9045	1.905	1.903	1.9035	174760.0
2006-10-31 17:00:00	AMZN	Stock	1.9035	1.91	1.903	1.903	414500.0
2006-10-31 18:00:00	AMZN	Stock	1.9025	1.9025	1.9025	1.9025	40000.0
2006-10-31 19:00:00	AMZN	Stock	1.9045	1.9045	1.9045	1.9045	8000.0

> showing 50 of 30,471 rows — these rows as CSV

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