PREVIEW / stock_1hour / 2007-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-02.parquet
  size:    715 KB
  rows:    33,843
  symbols: 2,695

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-05-02 09:00:00	AAPL	Stock	3.5589	3.5829	3.5525	3.5739	68581856.0
2007-05-02 10:00:00	AAPL	Stock	3.5739	3.58	3.5614	3.5654	75096504.0
2007-05-02 11:00:00	AAPL	Stock	3.5657	3.5711	3.5571	3.5689	57400532.0
2007-05-02 12:00:00	AAPL	Stock	3.5689	3.58	3.5661	3.5736	46686108.0
2007-05-02 13:00:00	AAPL	Stock	3.5739	3.5807	3.5714	3.5771	41815312.0
2007-05-02 14:00:00	AAPL	Stock	3.5771	3.5907	3.575	3.5843	70647948.0
2007-05-02 15:00:00	AAPL	Stock	3.5843	3.5879	3.5782	3.5857	103508272.0
2007-05-02 16:00:00	AAPL	Stock	3.5854	3.5854	3.5854	3.5854	7257852.0
2007-05-02 09:00:00	MSFT	Stock	30.39	30.56	30.3	30.44	10235459.0
2007-05-02 10:00:00	MSFT	Stock	30.44	30.5	30.36	30.43	11950839.0
2007-05-02 11:00:00	MSFT	Stock	30.43	30.48	30.4	30.44	6794487.0
2007-05-02 12:00:00	MSFT	Stock	30.44	30.48	30.43	30.45	5150549.0
2007-05-02 13:00:00	MSFT	Stock	30.45	30.57	30.44	30.56	7203636.0
2007-05-02 14:00:00	MSFT	Stock	30.57	30.69	30.56	30.61	15198373.0
2007-05-02 15:00:00	MSFT	Stock	30.61	30.65	30.52	30.61	15801514.0
2007-05-02 16:00:00	MSFT	Stock	30.58	30.61	30.58	30.61	1273233.0
2007-05-02 08:00:00	NVDA	Stock	0.5583	0.5583	0.5583	0.5583	30000.0
2007-05-02 09:00:00	NVDA	Stock	0.5567	0.5592	0.5528	0.5543	41722440.0
2007-05-02 10:00:00	NVDA	Stock	0.5545	0.5563	0.5477	0.5505	101486040.0
2007-05-02 11:00:00	NVDA	Stock	0.5505	0.551	0.548	0.5498	81292020.0
2007-05-02 12:00:00	NVDA	Stock	0.5498	0.5508	0.5478	0.5483	68141580.0
2007-05-02 13:00:00	NVDA	Stock	0.5483	0.5507	0.5477	0.5498	58048620.0
2007-05-02 14:00:00	NVDA	Stock	0.55	0.553	0.5492	0.5503	110789940.0
2007-05-02 15:00:00	NVDA	Stock	0.5505	0.551	0.5447	0.5475	145199280.0
2007-05-02 16:00:00	NVDA	Stock	0.5475	0.55	0.547	0.55	8195700.0
2007-05-02 17:00:00	NVDA	Stock	0.547	0.547	0.5462	0.5462	36000.0
2007-05-02 18:00:00	NVDA	Stock	0.546	0.546	0.5458	0.5458	60000.0
2007-05-02 19:00:00	NVDA	Stock	0.5447	0.549	0.5443	0.5467	68460.0
2007-05-02 04:00:00	AMZN	Stock	3.0535	3.0935	3.0535	3.0935	10000.0
2007-05-02 07:00:00	AMZN	Stock	3.0895	3.093	3.0885	3.0925	153000.0
2007-05-02 08:00:00	AMZN	Stock	3.0925	3.0945	3.085	3.091	740500.0
2007-05-02 09:00:00	AMZN	Stock	3.091	3.0975	3.0655	3.0815	36875380.0
2007-05-02 10:00:00	AMZN	Stock	3.0815	3.1125	3.0795	3.0914	51455640.0
2007-05-02 11:00:00	AMZN	Stock	3.091	3.0945	3.0625	3.069	33130460.0
2007-05-02 12:00:00	AMZN	Stock	3.0695	3.0825	3.058	3.0625	28551360.0
2007-05-02 13:00:00	AMZN	Stock	3.0625	3.071	3.045	3.0695	37306120.0
2007-05-02 14:00:00	AMZN	Stock	3.069	3.0825	3.062	3.067	26205260.0
2007-05-02 15:00:00	AMZN	Stock	3.0665	3.069	3.0525	3.0585	55893100.0
2007-05-02 16:00:00	AMZN	Stock	3.0585	3.0605	3.0575	3.059	5351340.0
2007-05-02 17:00:00	AMZN	Stock	3.0625	3.064	3.061	3.0625	188720.0
2007-05-02 18:00:00	AMZN	Stock	3.0635	3.065	3.0605	3.062	157460.0
2007-05-02 19:00:00	AMZN	Stock	3.062	3.0645	3.062	3.0645	5540.0
2007-05-02 09:00:00	CL	Stock	34.125	34.375	33.88	33.99	773700.0
2007-05-02 10:00:00	CL	Stock	33.99	34.085	33.97	34.075	744600.0
2007-05-02 11:00:00	CL	Stock	34.075	34.08	33.97	33.985	583400.0
2007-05-02 12:00:00	CL	Stock	33.985	33.99	33.87	33.885	705400.0
2007-05-02 13:00:00	CL	Stock	33.885	33.935	33.875	33.935	562000.0
2007-05-02 14:00:00	CL	Stock	33.935	34.055	33.935	34.0	528600.0
2007-05-02 15:00:00	CL	Stock	34.005	34.035	33.94	34.0	700000.0
2007-05-02 16:00:00	CL	Stock	34.0	34.0	34.0	34.0	80600.0

> showing 50 of 33,843 rows — these rows as CSV

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