PREVIEW / stock_1hour / 2008-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-17.parquet
  size:    810 KB
  rows:    39,607
  symbols: 3,287

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
2008-04-17 05:00:00	AAPL	Stock	5.5357	5.5357	5.5357	5.5357	15680.0
2008-04-17 06:00:00	AAPL	Stock	5.4896	5.5011	5.4896	5.5011	8400.0
2008-04-17 07:00:00	AAPL	Stock	5.4896	5.5096	5.4861	5.5089	187600.0
2008-04-17 08:00:00	AAPL	Stock	5.5082	5.5179	5.4732	5.4739	2942464.0
2008-04-17 09:00:00	AAPL	Stock	5.4739	5.5529	5.4729	5.5357	122968104.0
2008-04-17 10:00:00	AAPL	Stock	5.5357	5.5714	5.5107	5.5389	150545612.0
2008-04-17 11:00:00	AAPL	Stock	5.5382	5.5496	5.5079	5.5257	88585476.0
2008-04-17 12:00:00	AAPL	Stock	5.525	5.5339	5.4911	5.5311	58256464.0
2008-04-17 13:00:00	AAPL	Stock	5.5318	5.5393	5.5036	5.5082	64895040.0
2008-04-17 14:00:00	AAPL	Stock	5.5082	5.5343	5.4979	5.5029	73048248.0
2008-04-17 15:00:00	AAPL	Stock	5.5043	5.5625	5.4989	5.5196	115261748.0
2008-04-17 16:00:00	AAPL	Stock	5.5171	5.625	5.5095	5.62	15657684.0
2008-04-17 17:00:00	AAPL	Stock	5.6161	5.6271	5.5187	5.6107	2606660.0
2008-04-17 18:00:00	AAPL	Stock	5.6114	5.6225	5.6082	5.6125	990892.0
2008-04-17 19:00:00	AAPL	Stock	5.6071	5.6214	5.6071	5.6161	523572.0
2008-04-17 07:00:00	MSFT	Stock	29.07	29.1	29.07	29.07	7000.0
2008-04-17 08:00:00	MSFT	Stock	29.1	29.2	28.98	28.99	67327.0
2008-04-17 09:00:00	MSFT	Stock	28.99	29.21	28.9	29.0	5424142.0
2008-04-17 10:00:00	MSFT	Stock	29.0	29.1	28.92	29.02	7085881.0
2008-04-17 11:00:00	MSFT	Stock	29.01	29.069	28.9	29.069	5802873.0
2008-04-17 12:00:00	MSFT	Stock	29.06	29.08	28.98	29.048	3629400.0
2008-04-17 13:00:00	MSFT	Stock	29.04	29.18	29.02	29.135	5157434.0
2008-04-17 14:00:00	MSFT	Stock	29.14	29.25	29.09	29.18	5475352.0
2008-04-17 15:00:00	MSFT	Stock	29.18	29.34	29.17	29.24	12044451.0
2008-04-17 16:00:00	MSFT	Stock	29.23	29.66	29.015	29.55	2389278.0
2008-04-17 17:00:00	MSFT	Stock	29.6	29.6	29.45	29.6	420778.0
2008-04-17 18:00:00	MSFT	Stock	29.6	29.75	29.6	29.6	25049.0
2008-04-17 19:00:00	MSFT	Stock	29.6	29.65	29.55	29.62	15221.0
2008-04-17 08:00:00	NVDA	Stock	0.4805	0.4805	0.4595	0.4595	505800.0
2008-04-17 09:00:00	NVDA	Stock	0.4622	0.465	0.4478	0.4545	101944160.0
2008-04-17 10:00:00	NVDA	Stock	0.4545	0.4558	0.4505	0.4548	113505000.0
2008-04-17 11:00:00	NVDA	Stock	0.4545	0.4568	0.4525	0.4552	65075320.0
2008-04-17 12:00:00	NVDA	Stock	0.4552	0.4598	0.4552	0.4595	50337720.0
2008-04-17 13:00:00	NVDA	Stock	0.4598	0.4638	0.4582	0.46	70548240.0
2008-04-17 14:00:00	NVDA	Stock	0.46	0.4625	0.4585	0.4605	53091560.0
2008-04-17 15:00:00	NVDA	Stock	0.4608	0.4662	0.4605	0.4648	111435640.0
2008-04-17 16:00:00	NVDA	Stock	0.4648	0.47	0.4575	0.47	8436760.0
2008-04-17 17:00:00	NVDA	Stock	0.47	0.47	0.458	0.4698	6835840.0
2008-04-17 18:00:00	NVDA	Stock	0.47	0.4713	0.4645	0.4713	247960.0
2008-04-17 19:00:00	NVDA	Stock	0.4708	0.4718	0.47	0.4715	195960.0
2008-04-17 20:00:00	NVDA	Stock	0.4645	0.4645	0.4645	0.4645	232000.0
2008-04-17 07:00:00	AMZN	Stock	3.716	3.716	3.65	3.6905	86000.0
2008-04-17 08:00:00	AMZN	Stock	3.7075	3.712	3.687	3.698	105200.0
2008-04-17 09:00:00	AMZN	Stock	3.6925	3.751	3.6755	3.7235	17180640.0
2008-04-17 10:00:00	AMZN	Stock	3.7235	3.739	3.703	3.7155	18101500.0
2008-04-17 11:00:00	AMZN	Stock	3.715	3.721	3.691	3.6985	14321880.0
2008-04-17 12:00:00	AMZN	Stock	3.6995	3.7165	3.694	3.701	9960060.0
2008-04-17 13:00:00	AMZN	Stock	3.7	3.7045	3.6825	3.692	11768440.0
2008-04-17 14:00:00	AMZN	Stock	3.691	3.7045	3.6805	3.6865	15368520.0
2008-04-17 15:00:00	AMZN	Stock	3.6855	3.7155	3.6835	3.7	29592900.0

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

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