PREVIEW / stock_1hour / 2007-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-24.parquet
  size:    657 KB
  rows:    31,052
  symbols: 2,506

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-01-24 06:00:00	AAPL	Stock	3.0736	3.0761	3.0721	3.0721	42000.0
2007-01-24 07:00:00	AAPL	Stock	3.0807	3.0961	3.0807	3.0854	686000.0
2007-01-24 08:00:00	AAPL	Stock	3.0821	3.0857	3.0786	3.0821	1997296.0
2007-01-24 09:00:00	AAPL	Stock	3.0821	3.1036	3.0743	3.0932	157952312.0
2007-01-24 10:00:00	AAPL	Stock	3.0936	3.1004	3.0754	3.0954	188185172.0
2007-01-24 11:00:00	AAPL	Stock	3.0954	3.1125	3.0936	3.1052	143661112.0
2007-01-24 12:00:00	AAPL	Stock	3.1054	3.1079	3.0875	3.0957	76749484.0
2007-01-24 13:00:00	AAPL	Stock	3.0957	3.0957	3.0804	3.0907	90281324.0
2007-01-24 14:00:00	AAPL	Stock	3.0909	3.1	3.0839	3.0871	87401608.0
2007-01-24 15:00:00	AAPL	Stock	3.0871	3.1	3.0804	3.0964	145179692.0
2007-01-24 16:00:00	AAPL	Stock	3.0961	3.1054	3.0936	3.0964	16002196.0
2007-01-24 17:00:00	AAPL	Stock	3.1014	3.1036	3.1	3.1018	567420.0
2007-01-24 18:00:00	AAPL	Stock	3.1018	3.1061	3.1004	3.1054	681772.0
2007-01-24 19:00:00	AAPL	Stock	3.1061	3.1071	3.1021	3.1068	172004.0
2007-01-24 08:00:00	MSFT	Stock	30.87	30.9	30.87	30.87	15893.0
2007-01-24 09:00:00	MSFT	Stock	30.86	30.92	30.65	30.7	7321327.0
2007-01-24 10:00:00	MSFT	Stock	30.7	31.24	30.69	31.2	12116685.0
2007-01-24 11:00:00	MSFT	Stock	31.2	31.3	31.11	31.11	10111604.0
2007-01-24 12:00:00	MSFT	Stock	31.11	31.18	31.08	31.11	6121989.0
2007-01-24 13:00:00	MSFT	Stock	31.12	31.2	31.04	31.17	4786515.0
2007-01-24 14:00:00	MSFT	Stock	31.17	31.18	31.1	31.113	5360599.0
2007-01-24 15:00:00	MSFT	Stock	31.11	31.13	30.97	31.09	10482919.0
2007-01-24 16:00:00	MSFT	Stock	31.09	31.25	31.05	31.09	211340.0
2007-01-24 17:00:00	MSFT	Stock	31.2	31.25	31.08	31.14	317670.0
2007-01-24 18:00:00	MSFT	Stock	31.15	31.2	31.15	31.2	9614.0
2007-01-24 19:00:00	MSFT	Stock	31.2	31.27	31.2	31.23	11633.0
2007-01-24 08:00:00	NVDA	Stock	0.53	0.5437	0.53	0.5417	424200.0
2007-01-24 09:00:00	NVDA	Stock	0.539	0.5442	0.5343	0.5368	75030240.0
2007-01-24 10:00:00	NVDA	Stock	0.537	0.5523	0.5363	0.5523	129666420.0
2007-01-24 11:00:00	NVDA	Stock	0.5525	0.555	0.5507	0.5515	89919900.0
2007-01-24 12:00:00	NVDA	Stock	0.5515	0.5552	0.5508	0.5508	64210260.0
2007-01-24 13:00:00	NVDA	Stock	0.5508	0.5533	0.5492	0.5517	55373280.0
2007-01-24 14:00:00	NVDA	Stock	0.5518	0.552	0.5462	0.5485	61017540.0
2007-01-24 15:00:00	NVDA	Stock	0.5485	0.5498	0.547	0.548	84212340.0
2007-01-24 16:00:00	NVDA	Stock	0.5477	0.5567	0.5473	0.553	60655380.0
2007-01-24 17:00:00	NVDA	Stock	0.5508	0.5508	0.548	0.5508	75480.0
2007-01-24 19:00:00	NVDA	Stock	0.551	0.551	0.551	0.551	6000.0
2007-01-24 08:00:00	AMZN	Stock	1.83	1.8365	1.83	1.8365	50000.0
2007-01-24 09:00:00	AMZN	Stock	1.8305	1.8485	1.825	1.8395	9406500.0
2007-01-24 10:00:00	AMZN	Stock	1.8385	1.859	1.837	1.855	15490280.0
2007-01-24 11:00:00	AMZN	Stock	1.854	1.862	1.851	1.8515	11482000.0
2007-01-24 12:00:00	AMZN	Stock	1.852	1.859	1.8485	1.8485	15834780.0
2007-01-24 13:00:00	AMZN	Stock	1.8485	1.8555	1.8435	1.8545	7586660.0
2007-01-24 14:00:00	AMZN	Stock	1.8545	1.868	1.851	1.864	11281340.0
2007-01-24 15:00:00	AMZN	Stock	1.8635	1.8665	1.8575	1.8635	22064880.0
2007-01-24 16:00:00	AMZN	Stock	1.864	1.9145	1.863	1.903	3877740.0
2007-01-24 17:00:00	AMZN	Stock	1.9025	1.92	1.8635	1.899	1671540.0
2007-01-24 18:00:00	AMZN	Stock	1.909	1.9095	1.9	1.905	74000.0
2007-01-24 19:00:00	AMZN	Stock	1.902	1.9075	1.902	1.9075	16000.0
2007-01-24 09:00:00	CL	Stock	33.07	33.115	33.0	33.1	312800.0

> showing 50 of 31,052 rows — these rows as CSV

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