PREVIEW / stock_1hour / 2007-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-14.parquet
  size:    685 KB
  rows:    32,298
  symbols: 2,538

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-14 06:00:00	AAPL	Stock	3.0354	3.04	3.0354	3.0354	32004.0
2007-02-14 07:00:00	AAPL	Stock	3.0271	3.0289	3.0107	3.0107	192220.0
2007-02-14 08:00:00	AAPL	Stock	3.0179	3.0286	3.0118	3.0143	1472324.0
2007-02-14 09:00:00	AAPL	Stock	3.0175	3.0364	3.0164	3.0307	61740924.0
2007-02-14 10:00:00	AAPL	Stock	3.0304	3.0525	3.0289	3.0407	120806644.0
2007-02-14 11:00:00	AAPL	Stock	3.0407	3.0586	3.0339	3.041	91550368.0
2007-02-14 12:00:00	AAPL	Stock	3.0407	3.0464	3.0379	3.0404	39497304.0
2007-02-14 13:00:00	AAPL	Stock	3.04	3.0561	3.04	3.0518	50067080.0
2007-02-14 14:00:00	AAPL	Stock	3.0518	3.0541	3.0425	3.0489	51038708.0
2007-02-14 15:00:00	AAPL	Stock	3.0489	3.0514	3.04	3.0457	74175080.0
2007-02-14 16:00:00	AAPL	Stock	3.0457	3.0475	3.0446	3.0475	841036.0
2007-02-14 17:00:00	AAPL	Stock	3.0475	3.0514	3.0464	3.0464	626220.0
2007-02-14 18:00:00	AAPL	Stock	3.05	3.0514	3.05	3.0514	61600.0
2007-02-14 19:00:00	AAPL	Stock	3.0496	3.0514	3.0468	3.0468	175000.0
2007-02-14 06:00:00	MSFT	Stock	29.08	29.09	29.07	29.07	2600.0
2007-02-14 07:00:00	MSFT	Stock	29.07	29.09	29.0	29.09	4172.0
2007-02-14 08:00:00	MSFT	Stock	29.03	29.09	29.03	29.08	14457.0
2007-02-14 09:00:00	MSFT	Stock	29.08	29.23	29.08	29.21	6213675.0
2007-02-14 10:00:00	MSFT	Stock	29.21	29.49	29.21	29.47	13225495.0
2007-02-14 11:00:00	MSFT	Stock	29.48	29.69	29.46	29.51	10437663.0
2007-02-14 12:00:00	MSFT	Stock	29.51	29.54	29.41	29.54	3573892.0
2007-02-14 13:00:00	MSFT	Stock	29.54	29.56	29.44	29.48	5065458.0
2007-02-14 14:00:00	MSFT	Stock	29.48	29.59	29.45	29.49	4792650.0
2007-02-14 15:00:00	MSFT	Stock	29.49	29.53	29.4	29.44	8019040.0
2007-02-14 16:00:00	MSFT	Stock	29.43	29.46	29.4	29.41	102262.0
2007-02-14 17:00:00	MSFT	Stock	29.44	29.44	29.43	29.438	6467.0
2007-02-14 18:00:00	MSFT	Stock	29.47	29.47	29.45	29.45	965.0
2007-02-14 19:00:00	MSFT	Stock	29.45	29.45	29.45	29.45	1400.0
2007-02-14 07:00:00	NVDA	Stock	0.575	0.575	0.5667	0.5722	669300.0
2007-02-14 08:00:00	NVDA	Stock	0.5722	0.574	0.5685	0.5718	14344620.0
2007-02-14 09:00:00	NVDA	Stock	0.5718	0.5733	0.5583	0.5618	206712660.0
2007-02-14 10:00:00	NVDA	Stock	0.562	0.575	0.5608	0.5705	254617980.0
2007-02-14 11:00:00	NVDA	Stock	0.5703	0.5708	0.5657	0.5675	146896200.0
2007-02-14 12:00:00	NVDA	Stock	0.5673	0.5692	0.5655	0.568	65583000.0
2007-02-14 13:00:00	NVDA	Stock	0.5682	0.5685	0.5665	0.5668	74028960.0
2007-02-14 14:00:00	NVDA	Stock	0.5668	0.5692	0.562	0.563	115141980.0
2007-02-14 15:00:00	NVDA	Stock	0.563	0.5637	0.5578	0.5597	157606020.0
2007-02-14 16:00:00	NVDA	Stock	0.5587	0.5603	0.5572	0.5583	2748180.0
2007-02-14 17:00:00	NVDA	Stock	0.5575	0.5592	0.5565	0.5575	501060.0
2007-02-14 18:00:00	NVDA	Stock	0.5582	0.5582	0.5567	0.5577	325800.0
2007-02-14 19:00:00	NVDA	Stock	0.5575	0.558	0.5575	0.558	30000.0
2007-02-14 09:00:00	AMZN	Stock	1.969	1.975	1.957	1.9745	4863100.0
2007-02-14 10:00:00	AMZN	Stock	1.9745	2.01	1.974	1.9995	33094660.0
2007-02-14 11:00:00	AMZN	Stock	1.9995	2.005	1.9985	2.0015	14991940.0
2007-02-14 12:00:00	AMZN	Stock	2.0015	2.0015	1.9925	1.9975	9130720.0
2007-02-14 13:00:00	AMZN	Stock	1.9975	2.006	1.9965	2.004	11918360.0
2007-02-14 14:00:00	AMZN	Stock	2.004	2.0065	1.9965	2.0035	17390960.0
2007-02-14 15:00:00	AMZN	Stock	2.0035	2.014	2.0025	2.008	37656440.0
2007-02-14 16:00:00	AMZN	Stock	2.008	2.0085	2.003	2.0085	219500.0
2007-02-14 17:00:00	AMZN	Stock	2.008	2.008	2.008	2.008	4000.0

> showing 50 of 32,298 rows — these rows as CSV

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