PREVIEW / stock_1hour / 2007-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-02.parquet
  size:    648 KB
  rows:    30,731
  symbols: 2,493

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-02-02 06:00:00	AAPL	Stock	3.0204	3.0204	3.0146	3.0146	56000.0
2007-02-02 07:00:00	AAPL	Stock	3.0257	3.0257	3.0143	3.015	53256.0
2007-02-02 08:00:00	AAPL	Stock	3.0143	3.0179	2.9911	3.0014	7452340.0
2007-02-02 09:00:00	AAPL	Stock	3.0007	3.0225	2.9893	3.0136	144053952.0
2007-02-02 10:00:00	AAPL	Stock	3.0132	3.0446	3.0118	3.0286	171608640.0
2007-02-02 11:00:00	AAPL	Stock	3.0286	3.0357	3.0146	3.0268	75977832.0
2007-02-02 12:00:00	AAPL	Stock	3.0268	3.0307	3.0215	3.0275	37018576.0
2007-02-02 13:00:00	AAPL	Stock	3.0275	3.0325	3.0232	3.0246	34931540.0
2007-02-02 14:00:00	AAPL	Stock	3.0246	3.0304	3.0111	3.0171	60391156.0
2007-02-02 15:00:00	AAPL	Stock	3.0175	3.0282	3.0121	3.0282	74350948.0
2007-02-02 16:00:00	AAPL	Stock	3.0279	3.0282	3.0143	3.0179	3367084.0
2007-02-02 17:00:00	AAPL	Stock	3.0171	3.0189	3.0154	3.0189	229124.0
2007-02-02 18:00:00	AAPL	Stock	3.0171	3.0196	3.0161	3.0196	130256.0
2007-02-02 19:00:00	AAPL	Stock	3.0196	3.0196	3.0154	3.0182	229404.0
2007-02-02 06:00:00	MSFT	Stock	30.85	30.85	30.85	30.85	4900.0
2007-02-02 07:00:00	MSFT	Stock	30.85	30.86	30.8	30.86	4400.0
2007-02-02 08:00:00	MSFT	Stock	30.86	30.88	30.8	30.85	93504.0
2007-02-02 09:00:00	MSFT	Stock	30.85	30.89	30.45	30.48	9021244.0
2007-02-02 10:00:00	MSFT	Stock	30.48	30.601	30.45	30.58	9121757.0
2007-02-02 11:00:00	MSFT	Stock	30.58	30.58	30.448	30.49	5595119.0
2007-02-02 12:00:00	MSFT	Stock	30.48	30.51	30.4	30.41	4124805.0
2007-02-02 13:00:00	MSFT	Stock	30.41	30.47	30.3	30.32	6670003.0
2007-02-02 14:00:00	MSFT	Stock	30.32	30.33	30.13	30.18	11279050.0
2007-02-02 15:00:00	MSFT	Stock	30.18	30.24	30.15	30.17	9682779.0
2007-02-02 16:00:00	MSFT	Stock	30.19	30.19	30.15	30.17	1775214.0
2007-02-02 17:00:00	MSFT	Stock	30.17	30.2	30.16	30.16	7550.0
2007-02-02 18:00:00	MSFT	Stock	30.16	30.19	30.15	30.16	3353.0
2007-02-02 19:00:00	MSFT	Stock	30.17	30.17	29.93	30.13	38996.0
2007-02-02 08:00:00	NVDA	Stock	0.5185	0.5233	0.5173	0.5175	425640.0
2007-02-02 09:00:00	NVDA	Stock	0.5185	0.5238	0.5158	0.5218	76319940.0
2007-02-02 10:00:00	NVDA	Stock	0.5218	0.5295	0.5208	0.5277	90624120.0
2007-02-02 11:00:00	NVDA	Stock	0.5277	0.5287	0.5252	0.5283	62245020.0
2007-02-02 12:00:00	NVDA	Stock	0.5283	0.5295	0.5265	0.5295	54618000.0
2007-02-02 13:00:00	NVDA	Stock	0.5295	0.5333	0.5292	0.5332	80160720.0
2007-02-02 14:00:00	NVDA	Stock	0.533	0.5332	0.5287	0.5315	93022500.0
2007-02-02 15:00:00	NVDA	Stock	0.5315	0.5323	0.5283	0.5312	106435620.0
2007-02-02 16:00:00	NVDA	Stock	0.5303	0.5315	0.5298	0.5305	3489180.0
2007-02-02 17:00:00	NVDA	Stock	0.5307	0.5308	0.53	0.53	78000.0
2007-02-02 04:00:00	AMZN	Stock	1.9	1.9	1.885	1.8875	130000.0
2007-02-02 05:00:00	AMZN	Stock	1.888	1.888	1.8875	1.8875	30000.0
2007-02-02 06:00:00	AMZN	Stock	1.895	1.895	1.874	1.874	344000.0
2007-02-02 07:00:00	AMZN	Stock	1.863	1.895	1.86	1.868	5315400.0
2007-02-02 08:00:00	AMZN	Stock	1.872	1.8875	1.861	1.8675	16489580.0
2007-02-02 09:00:00	AMZN	Stock	1.8685	1.887	1.85	1.8569	135282140.0
2007-02-02 10:00:00	AMZN	Stock	1.856	1.88	1.834	1.865	125572220.0
2007-02-02 11:00:00	AMZN	Stock	1.8655	1.882	1.86	1.8745	57889540.0
2007-02-02 12:00:00	AMZN	Stock	1.8746	1.8755	1.855	1.868	27494460.0
2007-02-02 13:00:00	AMZN	Stock	1.868	1.8765	1.858	1.8605	21271460.0
2007-02-02 14:00:00	AMZN	Stock	1.8605	1.866	1.8425	1.8655	52319400.0
2007-02-02 15:00:00	AMZN	Stock	1.866	1.8705	1.8545	1.8705	61874680.0

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

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