PREVIEW / stock_1hour / 2009-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-05.parquet
  size:    795 KB
  rows:    39,039
  symbols: 3,312

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
2009-02-05 07:00:00	AAPL	Stock	3.3125	3.3164	3.3107	3.3164	30800.0
2009-02-05 08:00:00	AAPL	Stock	3.3243	3.3307	3.3071	3.3161	1198428.0
2009-02-05 09:00:00	AAPL	Stock	3.3186	3.3514	3.3075	3.3432	74676364.0
2009-02-05 10:00:00	AAPL	Stock	3.3432	3.4314	3.3343	3.4179	133932204.0
2009-02-05 11:00:00	AAPL	Stock	3.4186	3.4357	3.3996	3.4357	96605208.0
2009-02-05 12:00:00	AAPL	Stock	3.435	3.4529	3.4093	3.4236	89968452.0
2009-02-05 13:00:00	AAPL	Stock	3.4236	3.4518	3.4225	3.4364	80185252.0
2009-02-05 14:00:00	AAPL	Stock	3.4361	3.4732	3.435	3.4486	95837280.0
2009-02-05 15:00:00	AAPL	Stock	3.4486	3.4557	3.425	3.4439	140401324.0
2009-02-05 16:00:00	AAPL	Stock	3.4479	3.4571	3.4177	3.4493	17907708.0
2009-02-05 17:00:00	AAPL	Stock	3.4471	3.4554	3.4471	3.4518	128688.0
2009-02-05 18:00:00	AAPL	Stock	3.4518	3.4554	3.445	3.4518	14544208.0
2009-02-05 19:00:00	AAPL	Stock	3.45	3.4625	3.45	3.4518	168448.0
2009-02-05 07:00:00	MSFT	Stock	18.55	18.55	18.45	18.49	25400.0
2009-02-05 08:00:00	MSFT	Stock	18.63	18.63	18.41	18.5	123834.0
2009-02-05 09:00:00	MSFT	Stock	18.53	18.55	18.26	18.3	6526122.0
2009-02-05 10:00:00	MSFT	Stock	18.3	18.99	18.25	18.88	12788220.0
2009-02-05 11:00:00	MSFT	Stock	18.88	19.0	18.85	18.97	8240872.0
2009-02-05 12:00:00	MSFT	Stock	18.97	19.1	18.88	18.974	9195817.0
2009-02-05 13:00:00	MSFT	Stock	18.97	19.04	18.82	18.94	6047026.0
2009-02-05 14:00:00	MSFT	Stock	18.95	19.14	18.92	18.95	8468147.0
2009-02-05 15:00:00	MSFT	Stock	18.951	19.05	18.82	19.05	15161890.0
2009-02-05 16:00:00	MSFT	Stock	19.04	19.1	18.831	19.06	5968900.0
2009-02-05 17:00:00	MSFT	Stock	19.06	19.06	18.99	18.99	4900.0
2009-02-05 18:00:00	MSFT	Stock	19.02	19.04	18.99	19.0	32558.0
2009-02-05 19:00:00	MSFT	Stock	18.97	18.98	18.97	18.98	2572.0
2009-02-05 08:00:00	NVDA	Stock	0.2105	0.2105	0.2105	0.2105	8000.0
2009-02-05 09:00:00	NVDA	Stock	0.212	0.22	0.2098	0.2172	94715880.0
2009-02-05 10:00:00	NVDA	Stock	0.2174	0.229	0.2172	0.2288	155916960.0
2009-02-05 11:00:00	NVDA	Stock	0.229	0.232	0.226	0.2315	137859560.0
2009-02-05 12:00:00	NVDA	Stock	0.2315	0.2365	0.2315	0.2345	144942520.0
2009-02-05 13:00:00	NVDA	Stock	0.2342	0.2345	0.2299	0.232	71563080.0
2009-02-05 14:00:00	NVDA	Stock	0.232	0.236	0.2303	0.231	113585560.0
2009-02-05 15:00:00	NVDA	Stock	0.2308	0.2348	0.23	0.2342	172979800.0
2009-02-05 16:00:00	NVDA	Stock	0.234	0.2342	0.2262	0.2328	19062920.0
2009-02-05 18:00:00	NVDA	Stock	0.2315	0.2315	0.2315	0.2315	25400.0
2009-02-05 19:00:00	NVDA	Stock	0.2335	0.234	0.2335	0.234	238840.0
2009-02-05 08:00:00	AMZN	Stock	3.0335	3.065	3.0335	3.0375	16000.0
2009-02-05 09:00:00	AMZN	Stock	3.04	3.0837	3.0315	3.058	22718160.0
2009-02-05 10:00:00	AMZN	Stock	3.057	3.1345	3.054	3.116	35126400.0
2009-02-05 11:00:00	AMZN	Stock	3.116	3.1455	3.1045	3.145	19373260.0
2009-02-05 12:00:00	AMZN	Stock	3.1455	3.1635	3.1275	3.153	23788040.0
2009-02-05 13:00:00	AMZN	Stock	3.1525	3.1555	3.1275	3.1385	17619660.0
2009-02-05 14:00:00	AMZN	Stock	3.1385	3.1905	3.137	3.1475	32632520.0
2009-02-05 15:00:00	AMZN	Stock	3.1474	3.1775	3.1355	3.1575	40823680.0
2009-02-05 16:00:00	AMZN	Stock	3.1585	3.1608	3.053	3.1475	1735660.0
2009-02-05 17:00:00	AMZN	Stock	3.148	3.159	3.1475	3.1545	5982300.0
2009-02-05 18:00:00	AMZN	Stock	3.1545	3.1575	3.1445	3.1445	38000.0
2009-02-05 19:00:00	AMZN	Stock	3.1575	3.1625	3.1575	3.1625	16000.0
2009-02-05 08:00:00	TLT	Stock	103.1	103.15	102.96	102.96	3600.0

> showing 50 of 39,039 rows — these rows as CSV

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