PREVIEW / stock_1hour / 2007-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-31.parquet
  size:    782 KB
  rows:    38,420
  symbols: 3,090

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
2007-07-31 09:00:00	AAPL	Stock	5.1061	5.1243	5.0714	5.1011	139795656.0
2007-07-31 10:00:00	AAPL	Stock	5.1011	5.1179	4.8489	4.9111	529600064.0
2007-07-31 11:00:00	AAPL	Stock	4.9132	4.9454	4.8632	4.9054	205692088.0
2007-07-31 12:00:00	AAPL	Stock	4.9043	4.9214	4.8657	4.8932	158062464.0
2007-07-31 13:00:00	AAPL	Stock	4.8936	4.915	4.8536	4.8732	126937636.0
2007-07-31 14:00:00	AAPL	Stock	4.8732	4.8957	4.7921	4.835	215679184.0
2007-07-31 15:00:00	AAPL	Stock	4.8339	4.8839	4.6971	4.7029	305467428.0
2007-07-31 16:00:00	AAPL	Stock	4.7046	4.7057	4.7018	4.7057	16010176.0
2007-07-31 09:00:00	MSFT	Stock	29.71	29.716	29.09	29.54	7469642.0
2007-07-31 10:00:00	MSFT	Stock	29.54	29.68	29.43	29.54	8718212.0
2007-07-31 11:00:00	MSFT	Stock	29.55	29.68	29.5	29.64	4736717.0
2007-07-31 12:00:00	MSFT	Stock	29.64	29.65	29.51	29.53	4034368.0
2007-07-31 13:00:00	MSFT	Stock	29.53	29.7	29.5	29.6	6286434.0
2007-07-31 14:00:00	MSFT	Stock	29.6	29.63	29.21	29.21	8405624.0
2007-07-31 15:00:00	MSFT	Stock	29.22	29.3	28.98	28.98	14826148.0
2007-07-31 16:00:00	MSFT	Stock	28.99	28.99	28.98	28.99	3302890.0
2007-07-31 07:00:00	NVDA	Stock	0.7768	0.7768	0.7758	0.7758	96000.0
2007-07-31 08:00:00	NVDA	Stock	0.7733	0.7833	0.767	0.7792	2451600.0
2007-07-31 09:00:00	NVDA	Stock	0.7783	0.795	0.7762	0.7893	114718200.0
2007-07-31 10:00:00	NVDA	Stock	0.7893	0.7988	0.7695	0.7767	162987180.0
2007-07-31 11:00:00	NVDA	Stock	0.7765	0.7835	0.7738	0.7833	59979240.0
2007-07-31 12:00:00	NVDA	Stock	0.7832	0.7917	0.7757	0.7782	49308780.0
2007-07-31 13:00:00	NVDA	Stock	0.7782	0.7792	0.771	0.778	54708780.0
2007-07-31 14:00:00	NVDA	Stock	0.7778	0.7788	0.7658	0.7668	81896940.0
2007-07-31 15:00:00	NVDA	Stock	0.7667	0.7712	0.7617	0.7625	132334320.0
2007-07-31 16:00:00	NVDA	Stock	0.7617	0.7667	0.7603	0.7617	21687600.0
2007-07-31 17:00:00	NVDA	Stock	0.7617	0.7627	0.761	0.7617	987900.0
2007-07-31 18:00:00	NVDA	Stock	0.7617	0.7617	0.7617	0.7617	6000.0
2007-07-31 19:00:00	NVDA	Stock	0.7632	0.7632	0.7602	0.7617	190200.0
2007-07-31 07:00:00	AMZN	Stock	4.169	4.2	4.169	4.18	30000.0
2007-07-31 08:00:00	AMZN	Stock	4.175	4.194	4.1605	4.185	686080.0
2007-07-31 09:00:00	AMZN	Stock	4.179	4.1865	4.097	4.1045	32938740.0
2007-07-31 10:00:00	AMZN	Stock	4.105	4.117	3.9	3.994	75286340.0
2007-07-31 11:00:00	AMZN	Stock	3.987	4.024	3.9575	4.01	33237920.0
2007-07-31 12:00:00	AMZN	Stock	4.0084	4.0135	3.981	3.9855	14429400.0
2007-07-31 13:00:00	AMZN	Stock	3.986	3.992	3.918	3.9275	28547840.0
2007-07-31 14:00:00	AMZN	Stock	3.9275	3.9665	3.906	3.9275	37130480.0
2007-07-31 15:00:00	AMZN	Stock	3.926	3.9765	3.9165	3.928	46437700.0
2007-07-31 16:00:00	AMZN	Stock	3.927	3.93	3.9195	3.9225	2366940.0
2007-07-31 17:00:00	AMZN	Stock	3.92	3.935	3.92	3.931	47940.0
2007-07-31 18:00:00	AMZN	Stock	3.926	3.926	3.925	3.925	32400.0
2007-07-31 19:00:00	AMZN	Stock	3.925	3.9325	3.925	3.9295	28100.0
2007-07-31 09:00:00	TLT	Stock	87.13	87.21	86.97	87.1	120000.0
2007-07-31 10:00:00	TLT	Stock	87.09	87.36	86.95	87.3	414534.0
2007-07-31 11:00:00	TLT	Stock	87.32	87.34	87.13	87.19	107900.0
2007-07-31 12:00:00	TLT	Stock	87.19	87.41	87.18	87.37	375900.0
2007-07-31 13:00:00	TLT	Stock	87.39	87.42	87.2	87.31	126400.0
2007-07-31 14:00:00	TLT	Stock	87.28	87.55	87.27	87.55	144400.0
2007-07-31 15:00:00	TLT	Stock	87.55	87.75	87.44	87.75	942402.0
2007-07-31 16:00:00	TLT	Stock	87.73	87.74	87.66	87.66	201800.0

> showing 50 of 38,420 rows — these rows as CSV

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