PREVIEW / stock_1hour / 2007-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-15.parquet
  size:    670 KB
  rows:    32,005
  symbols: 2,518

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-15 07:00:00	AAPL	Stock	3.0368	3.0414	3.0368	3.0414	36400.0
2007-02-15 08:00:00	AAPL	Stock	3.0461	3.0475	3.0368	3.0418	1139040.0
2007-02-15 09:00:00	AAPL	Stock	3.0414	3.0579	3.0279	3.0425	57160796.0
2007-02-15 10:00:00	AAPL	Stock	3.0429	3.0514	3.0318	3.0335	80839724.0
2007-02-15 11:00:00	AAPL	Stock	3.0336	3.0454	3.0311	3.0436	48575716.0
2007-02-15 12:00:00	AAPL	Stock	3.0439	3.0457	3.0339	3.0393	35526288.0
2007-02-15 13:00:00	AAPL	Stock	3.0393	3.0443	3.0371	3.0414	28889532.0
2007-02-15 14:00:00	AAPL	Stock	3.0418	3.0461	3.0361	3.0446	38882844.0
2007-02-15 15:00:00	AAPL	Stock	3.045	3.0457	3.0396	3.0443	61008444.0
2007-02-15 16:00:00	AAPL	Stock	3.0425	3.0464	3.0407	3.0407	1205064.0
2007-02-15 17:00:00	AAPL	Stock	3.0421	3.0432	3.04	3.0429	137816.0
2007-02-15 18:00:00	AAPL	Stock	3.0432	3.0432	3.0411	3.0411	87948.0
2007-02-15 19:00:00	AAPL	Stock	3.0407	3.0432	3.0379	3.0379	165984.0
2007-02-15 08:00:00	MSFT	Stock	29.41	29.47	29.41	29.45	131755.0
2007-02-15 09:00:00	MSFT	Stock	29.45	29.64	29.4	29.46	5746813.0
2007-02-15 10:00:00	MSFT	Stock	29.44	29.61	29.36	29.38	7959065.0
2007-02-15 11:00:00	MSFT	Stock	29.39	29.64	29.39	29.625	6563364.0
2007-02-15 12:00:00	MSFT	Stock	29.62	29.65	29.22	29.47	12090352.0
2007-02-15 13:00:00	MSFT	Stock	29.47	29.55	29.46	29.492	3877892.0
2007-02-15 14:00:00	MSFT	Stock	29.5	29.5	29.35	29.37	7306417.0
2007-02-15 15:00:00	MSFT	Stock	29.369	29.54	29.36	29.54	6880278.0
2007-02-15 16:00:00	MSFT	Stock	29.53	29.8	29.19	29.23	8982936.0
2007-02-15 17:00:00	MSFT	Stock	29.23	29.25	29.11	29.14	2876551.0
2007-02-15 18:00:00	MSFT	Stock	29.13	29.53	29.08	29.1	34323.0
2007-02-15 19:00:00	MSFT	Stock	29.1	29.1	28.84	28.95	61398.0
2007-02-15 09:00:00	NVDA	Stock	0.5582	0.5633	0.5558	0.5628	70292880.0
2007-02-15 10:00:00	NVDA	Stock	0.5628	0.5647	0.5572	0.5578	70493340.0
2007-02-15 11:00:00	NVDA	Stock	0.5575	0.5587	0.5558	0.5585	49934220.0
2007-02-15 12:00:00	NVDA	Stock	0.5587	0.5593	0.5535	0.5575	58663980.0
2007-02-15 13:00:00	NVDA	Stock	0.558	0.5612	0.5568	0.5603	34665240.0
2007-02-15 14:00:00	NVDA	Stock	0.5605	0.565	0.5595	0.5648	52318680.0
2007-02-15 15:00:00	NVDA	Stock	0.5648	0.5653	0.5605	0.5625	93434160.0
2007-02-15 16:00:00	NVDA	Stock	0.5627	0.5637	0.5583	0.5583	2161500.0
2007-02-15 17:00:00	NVDA	Stock	0.5583	0.5625	0.5553	0.5592	14343420.0
2007-02-15 18:00:00	NVDA	Stock	0.5592	0.5625	0.5592	0.5625	39180.0
2007-02-15 19:00:00	NVDA	Stock	0.557	0.557	0.557	0.557	78000.0
2007-02-15 08:00:00	AMZN	Stock	2.0	2.0	2.0	2.0	4000.0
2007-02-15 09:00:00	AMZN	Stock	2.006	2.0085	1.993	2.0	8492580.0
2007-02-15 10:00:00	AMZN	Stock	2.0	2.0095	1.995	1.995	13661160.0
2007-02-15 11:00:00	AMZN	Stock	1.995	2.0085	1.995	2.006	22206380.0
2007-02-15 12:00:00	AMZN	Stock	2.0055	2.016	2.0005	2.0105	15819000.0
2007-02-15 13:00:00	AMZN	Stock	2.011	2.0125	2.006	2.0095	7241960.0
2007-02-15 14:00:00	AMZN	Stock	2.01	2.01	2.0035	2.007	10069100.0
2007-02-15 15:00:00	AMZN	Stock	2.0069	2.0075	2.0005	2.0045	21156480.0
2007-02-15 16:00:00	AMZN	Stock	2.003	2.003	1.9975	2.003	516000.0
2007-02-15 18:00:00	AMZN	Stock	1.998	2.003	1.997	2.003	41940.0
2007-02-15 09:00:00	CL	Stock	34.045	34.05	33.9	34.045	285200.0
2007-02-15 10:00:00	CL	Stock	34.04	34.065	33.795	33.905	626400.0
2007-02-15 11:00:00	CL	Stock	33.92	34.006	33.92	33.995	303600.0
2007-02-15 12:00:00	CL	Stock	33.98	33.985	33.895	33.935	388400.0

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

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