PREVIEW / stock_1hour / 2007-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-04.parquet
  size:    813 KB
  rows:    40,625
  symbols: 3,218

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-12-04 05:00:00	AAPL	Stock	6.375	6.375	6.3721	6.3721	16800.0
2007-12-04 06:00:00	AAPL	Stock	6.3571	6.3571	6.3571	6.3571	53200.0
2007-12-04 07:00:00	AAPL	Stock	6.3571	6.375	6.3325	6.345	350504.0
2007-12-04 08:00:00	AAPL	Stock	6.345	6.35	6.2925	6.3157	6382432.0
2007-12-04 09:00:00	AAPL	Stock	6.3157	6.4418	6.3079	6.42	152075476.0
2007-12-04 10:00:00	AAPL	Stock	6.4189	6.4518	6.3936	6.4046	137996488.0
2007-12-04 11:00:00	AAPL	Stock	6.4046	6.4607	6.3968	6.4161	105232512.0
2007-12-04 12:00:00	AAPL	Stock	6.4164	6.4429	6.4068	6.4296	64934940.0
2007-12-04 13:00:00	AAPL	Stock	6.4293	6.4504	6.3996	6.4171	62105932.0
2007-12-04 14:00:00	AAPL	Stock	6.4171	6.4171	6.3304	6.4021	104213424.0
2007-12-04 15:00:00	AAPL	Stock	6.4018	6.4286	6.3864	6.4225	124093984.0
2007-12-04 16:00:00	AAPL	Stock	6.4218	6.4275	6.3611	6.4214	13722408.0
2007-12-04 17:00:00	AAPL	Stock	6.4196	6.4282	6.4196	6.4229	2626848.0
2007-12-04 18:00:00	AAPL	Stock	6.4229	6.4264	6.4229	6.4264	137620.0
2007-12-04 19:00:00	AAPL	Stock	6.4264	6.4286	6.4214	6.4286	204176.0
2007-12-04 07:00:00	MSFT	Stock	32.95	32.95	32.75	32.75	800.0
2007-12-04 08:00:00	MSFT	Stock	32.86	32.86	32.74	32.8	3569.0
2007-12-04 09:00:00	MSFT	Stock	32.8	33.24	32.74	33.22	11888435.0
2007-12-04 10:00:00	MSFT	Stock	33.22	33.24	32.76	33.13	6620787.0
2007-12-04 11:00:00	MSFT	Stock	33.14	33.17	32.95	33.02	5300876.0
2007-12-04 12:00:00	MSFT	Stock	33.02	33.05	32.88	32.975	4789105.0
2007-12-04 13:00:00	MSFT	Stock	32.97	33.05	32.83	32.84	5435928.0
2007-12-04 14:00:00	MSFT	Stock	32.84	32.95	32.63	32.88	8407658.0
2007-12-04 15:00:00	MSFT	Stock	32.88	32.94	32.7	32.79	8790068.0
2007-12-04 16:00:00	MSFT	Stock	32.79	32.942	32.61	32.77	3272892.0
2007-12-04 17:00:00	MSFT	Stock	32.71	33.0	32.7	32.77	405095.0
2007-12-04 19:00:00	MSFT	Stock	32.72	32.72	32.72	32.72	200.0
2007-12-04 08:00:00	NVDA	Stock	0.806	0.8128	0.799	0.8005	690480.0
2007-12-04 09:00:00	NVDA	Stock	0.8	0.8062	0.7838	0.7985	56207720.0
2007-12-04 10:00:00	NVDA	Stock	0.7982	0.805	0.7963	0.8008	48967200.0
2007-12-04 11:00:00	NVDA	Stock	0.8008	0.8048	0.7952	0.7988	42710520.0
2007-12-04 12:00:00	NVDA	Stock	0.799	0.8008	0.7945	0.7985	31209320.0
2007-12-04 13:00:00	NVDA	Stock	0.7985	0.8012	0.7946	0.7968	26890640.0
2007-12-04 14:00:00	NVDA	Stock	0.797	0.797	0.7875	0.7955	50339400.0
2007-12-04 15:00:00	NVDA	Stock	0.7952	0.799	0.787	0.799	85369400.0
2007-12-04 16:00:00	NVDA	Stock	0.799	0.8018	0.7916	0.7992	23041200.0
2007-12-04 17:00:00	NVDA	Stock	0.7975	0.7995	0.7968	0.7995	6568320.0
2007-12-04 18:00:00	NVDA	Stock	0.8	0.8	0.7995	0.7995	8000.0
2007-12-04 19:00:00	NVDA	Stock	0.8	0.8	0.8	0.8	36840.0
2007-12-04 08:00:00	AMZN	Stock	4.5255	4.5255	4.507	4.518	100300.0
2007-12-04 09:00:00	AMZN	Stock	4.522	4.5585	4.502	4.5525	14299800.0
2007-12-04 10:00:00	AMZN	Stock	4.5518	4.575	4.513	4.554	16161000.0
2007-12-04 11:00:00	AMZN	Stock	4.554	4.566	4.5485	4.5575	6930540.0
2007-12-04 12:00:00	AMZN	Stock	4.5555	4.6575	4.552	4.647	25746640.0
2007-12-04 13:00:00	AMZN	Stock	4.6475	4.6695	4.6265	4.642	16102740.0
2007-12-04 14:00:00	AMZN	Stock	4.645	4.699	4.6135	4.6945	19423620.0
2007-12-04 15:00:00	AMZN	Stock	4.694	4.728	4.6845	4.7215	42996600.0
2007-12-04 16:00:00	AMZN	Stock	4.722	4.722	4.6316	4.7035	1298300.0
2007-12-04 17:00:00	AMZN	Stock	4.71	4.7205	4.7065	4.7145	378420.0
2007-12-04 18:00:00	AMZN	Stock	4.7165	4.7165	4.5532	4.5532	140000.0

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

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