PREVIEW / stock_1hour / 2008-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-03.parquet
  size:    833 KB
  rows:    41,345
  symbols: 3,237

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-01-03 06:00:00	AAPL	Stock	6.9796	6.9807	6.9357	6.9389	25200.0
2008-01-03 07:00:00	AAPL	Stock	6.9389	6.9821	6.9389	6.9429	203980.0
2008-01-03 08:00:00	AAPL	Stock	6.9482	6.9961	6.9068	6.9882	5894756.0
2008-01-03 09:00:00	AAPL	Stock	6.985	7.0075	6.9286	6.9482	122954972.0
2008-01-03 10:00:00	AAPL	Stock	6.9475	7.0393	6.9414	6.9593	198800504.0
2008-01-03 11:00:00	AAPL	Stock	6.96	7.0036	6.955	6.9882	96833184.0
2008-01-03 12:00:00	AAPL	Stock	6.9886	7.0496	6.975	7.0124	111937924.0
2008-01-03 13:00:00	AAPL	Stock	7.0111	7.0261	6.9786	6.9925	59501400.0
2008-01-03 14:00:00	AAPL	Stock	6.9943	6.9964	6.9593	6.9825	69075804.0
2008-01-03 15:00:00	AAPL	Stock	6.9829	6.9843	6.8818	6.9589	161467516.0
2008-01-03 16:00:00	AAPL	Stock	6.9604	7.0146	6.96	6.9696	14304192.0
2008-01-03 17:00:00	AAPL	Stock	6.97	6.9879	6.9618	6.9654	1758288.0
2008-01-03 18:00:00	AAPL	Stock	6.9664	6.9714	6.9657	6.9664	68600.0
2008-01-03 19:00:00	AAPL	Stock	6.9693	6.9732	6.9643	6.9643	533120.0
2008-01-03 08:00:00	MSFT	Stock	35.17	35.29	35.16	35.22	33996.0
2008-01-03 09:00:00	MSFT	Stock	35.2	35.27	34.86	34.95	6253409.0
2008-01-03 10:00:00	MSFT	Stock	34.94	35.42	34.94	35.28	10930032.0
2008-01-03 11:00:00	MSFT	Stock	35.28	35.64	35.27	35.53	6279172.0
2008-01-03 12:00:00	MSFT	Stock	35.532	35.65	35.51	35.58	4717015.0
2008-01-03 13:00:00	MSFT	Stock	35.58	35.59	35.34	35.39	4890435.0
2008-01-03 14:00:00	MSFT	Stock	35.39	35.39	35.2	35.24	5288391.0
2008-01-03 15:00:00	MSFT	Stock	35.235	35.37	35.13	35.37	9067229.0
2008-01-03 16:00:00	MSFT	Stock	35.35	35.49	35.15	35.33	1703054.0
2008-01-03 17:00:00	MSFT	Stock	35.496	35.496	35.33	35.436	436830.0
2008-01-03 18:00:00	MSFT	Stock	35.37	35.4	35.37	35.4	400.0
2008-01-03 19:00:00	MSFT	Stock	35.37	35.41	35.37	35.41	1240.0
2008-01-03 08:00:00	NVDA	Stock	0.825	0.8252	0.825	0.8252	300880.0
2008-01-03 09:00:00	NVDA	Stock	0.8302	0.8385	0.8238	0.831	49584720.0
2008-01-03 10:00:00	NVDA	Stock	0.8308	0.8395	0.8258	0.8368	68598480.0
2008-01-03 11:00:00	NVDA	Stock	0.8368	0.8432	0.8348	0.8402	45721960.0
2008-01-03 12:00:00	NVDA	Stock	0.8405	0.8465	0.839	0.8398	61462360.0
2008-01-03 13:00:00	NVDA	Stock	0.8395	0.8438	0.8355	0.8364	33833200.0
2008-01-03 14:00:00	NVDA	Stock	0.8365	0.8365	0.8283	0.8292	54061320.0
2008-01-03 15:00:00	NVDA	Stock	0.8292	0.8295	0.8158	0.8182	120523560.0
2008-01-03 16:00:00	NVDA	Stock	0.8193	0.839	0.8182	0.8188	39925400.0
2008-01-03 17:00:00	NVDA	Stock	0.8216	0.8216	0.8188	0.821	1234600.0
2008-01-03 18:00:00	NVDA	Stock	0.8208	0.8208	0.8198	0.8198	30600.0
2008-01-03 19:00:00	NVDA	Stock	0.82	0.8203	0.82	0.8203	48000.0
2008-01-03 08:00:00	AMZN	Stock	4.8375	4.846	4.7925	4.7925	1395660.0
2008-01-03 09:00:00	AMZN	Stock	4.8	4.8625	4.755	4.773	24980380.0
2008-01-03 10:00:00	AMZN	Stock	4.774	4.832	4.774	4.797	34325460.0
2008-01-03 11:00:00	AMZN	Stock	4.7965	4.84	4.7965	4.83	14473020.0
2008-01-03 12:00:00	AMZN	Stock	4.8295	4.86	4.821	4.853	16808760.0
2008-01-03 13:00:00	AMZN	Stock	4.853	4.86	4.8365	4.8385	22881560.0
2008-01-03 14:00:00	AMZN	Stock	4.839	4.841	4.795	4.802	17968120.0
2008-01-03 15:00:00	AMZN	Stock	4.802	4.802	4.726	4.759	41495660.0
2008-01-03 16:00:00	AMZN	Stock	4.767	4.8474	4.7556	4.761	3580880.0
2008-01-03 17:00:00	AMZN	Stock	4.7774	4.8125	4.7605	4.7835	1885000.0
2008-01-03 18:00:00	AMZN	Stock	4.766	4.766	4.7605	4.7605	6000.0
2008-01-03 08:00:00	TLT	Stock	93.32	94.39	93.3	94.38	119200.0

> showing 50 of 41,345 rows — these rows as CSV

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