PREVIEW / stock_1hour / 2008-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-14.parquet
  size:    801 KB
  rows:    40,143
  symbols: 3,266

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-14 04:00:00	AAPL	Stock	6.2143	6.2143	6.2086	6.2096	19600.0
2008-01-14 05:00:00	AAPL	Stock	6.2096	6.2321	6.1971	6.2282	144592.0
2008-01-14 06:00:00	AAPL	Stock	6.2271	6.2411	6.2143	6.2232	96040.0
2008-01-14 07:00:00	AAPL	Stock	6.2232	6.3	6.2143	6.2804	1696436.0
2008-01-14 08:00:00	AAPL	Stock	6.2857	6.345	6.2646	6.3225	19647824.0
2008-01-14 09:00:00	AAPL	Stock	6.3225	6.3554	6.2561	6.3046	192425072.0
2008-01-14 10:00:00	AAPL	Stock	6.3054	6.3575	6.2786	6.3429	190863316.0
2008-01-14 11:00:00	AAPL	Stock	6.3429	6.3657	6.3221	6.3311	127361836.0
2008-01-14 12:00:00	AAPL	Stock	6.3311	6.3311	6.2946	6.3175	99684452.0
2008-01-14 13:00:00	AAPL	Stock	6.3175	6.3411	6.3071	6.3282	78570604.0
2008-01-14 14:00:00	AAPL	Stock	6.3278	6.3743	6.3125	6.3639	122318896.0
2008-01-14 15:00:00	AAPL	Stock	6.3636	6.4079	6.355	6.3835	223745872.0
2008-01-14 16:00:00	AAPL	Stock	6.3807	6.3875	6.321	6.3857	40342148.0
2008-01-14 17:00:00	AAPL	Stock	6.3871	6.3996	6.3832	6.3968	1907444.0
2008-01-14 18:00:00	AAPL	Stock	6.3982	6.4046	6.3929	6.3929	780360.0
2008-01-14 19:00:00	AAPL	Stock	6.3996	6.4	6.3857	6.3875	857976.0
2008-01-14 07:00:00	MSFT	Stock	34.0	34.4	34.0	34.27	37960.0
2008-01-14 08:00:00	MSFT	Stock	34.28	34.75	34.27	34.69	258988.0
2008-01-14 09:00:00	MSFT	Stock	34.69	34.75	34.16	34.3	5059510.0
2008-01-14 10:00:00	MSFT	Stock	34.3	34.5	34.26	34.4	7907423.0
2008-01-14 11:00:00	MSFT	Stock	34.41	34.53	34.29	34.31	6638822.0
2008-01-14 12:00:00	MSFT	Stock	34.31	34.321	34.08	34.24	6162158.0
2008-01-14 13:00:00	MSFT	Stock	34.24	34.37	34.17	34.27	6258289.0
2008-01-14 14:00:00	MSFT	Stock	34.27	34.37	34.2	34.352	6747959.0
2008-01-14 15:00:00	MSFT	Stock	34.36	34.52	34.26	34.39	11427869.0
2008-01-14 16:00:00	MSFT	Stock	34.39	34.425	33.856	34.39	3360226.0
2008-01-14 17:00:00	MSFT	Stock	34.39	34.39	34.35	34.35	39721.0
2008-01-14 18:00:00	MSFT	Stock	34.38	34.45	34.35	34.35	2224.0
2008-01-14 19:00:00	MSFT	Stock	34.38	34.38	34.35	34.35	200.0
2008-01-14 08:00:00	NVDA	Stock	0.6875	0.6888	0.6798	0.6888	725200.0
2008-01-14 09:00:00	NVDA	Stock	0.6898	0.7058	0.6753	0.7028	65240920.0
2008-01-14 10:00:00	NVDA	Stock	0.7028	0.7133	0.6998	0.7123	79672160.0
2008-01-14 11:00:00	NVDA	Stock	0.7123	0.72	0.7075	0.708	69341600.0
2008-01-14 12:00:00	NVDA	Stock	0.7083	0.7125	0.7018	0.71	103085160.0
2008-01-14 13:00:00	NVDA	Stock	0.7103	0.7195	0.709	0.719	44441960.0
2008-01-14 14:00:00	NVDA	Stock	0.719	0.7195	0.7143	0.719	48308120.0
2008-01-14 15:00:00	NVDA	Stock	0.719	0.7223	0.7145	0.7218	94424480.0
2008-01-14 16:00:00	NVDA	Stock	0.7213	0.7213	0.7083	0.7188	20195920.0
2008-01-14 17:00:00	NVDA	Stock	0.718	0.72	0.7078	0.7178	2868000.0
2008-01-14 18:00:00	NVDA	Stock	0.7208	0.7218	0.7208	0.7213	83280.0
2008-01-14 19:00:00	NVDA	Stock	0.72	0.72	0.72	0.72	15800.0
2008-01-14 07:00:00	AMZN	Stock	4.0985	4.1075	4.0985	4.1075	24220.0
2008-01-14 08:00:00	AMZN	Stock	4.1075	4.13	4.105	4.1215	141600.0
2008-01-14 09:00:00	AMZN	Stock	4.12	4.129	3.9435	3.9815	33603440.0
2008-01-14 10:00:00	AMZN	Stock	3.9815	4.0615	3.95	4.004	30713920.0
2008-01-14 11:00:00	AMZN	Stock	4.008	4.038	4.003	4.0325	15998640.0
2008-01-14 12:00:00	AMZN	Stock	4.0325	4.0785	4.011	4.077	21949720.0
2008-01-14 13:00:00	AMZN	Stock	4.0775	4.161	4.065	4.16	23397580.0
2008-01-14 14:00:00	AMZN	Stock	4.1595	4.166	4.101	4.148	21237600.0
2008-01-14 15:00:00	AMZN	Stock	4.148	4.163	4.1185	4.1435	30698000.0

> showing 50 of 40,143 rows — these rows as CSV

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