PREVIEW / stock_1hour / 2006-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-19.parquet
  size:    613 KB
  rows:    28,816
  symbols: 2,241

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
2006-04-19 04:00:00	AAPL	Stock	2.3857	2.3911	2.3857	2.3911	14000.0
2006-04-19 05:00:00	AAPL	Stock	2.3893	2.3939	2.3893	2.3939	11200.0
2006-04-19 07:00:00	AAPL	Stock	2.3982	2.4018	2.3932	2.3932	57960.0
2006-04-19 08:00:00	AAPL	Stock	2.4057	2.4057	2.3875	2.3925	4352488.0
2006-04-19 09:00:00	AAPL	Stock	2.39	2.3929	2.3686	2.3711	100252936.0
2006-04-19 10:00:00	AAPL	Stock	2.3714	2.3721	2.3432	2.3561	166247620.0
2006-04-19 11:00:00	AAPL	Stock	2.3557	2.3693	2.3525	2.3664	80762640.0
2006-04-19 12:00:00	AAPL	Stock	2.3664	2.3796	2.3536	2.3557	86871848.0
2006-04-19 13:00:00	AAPL	Stock	2.3557	2.3596	2.3446	2.3539	74026680.0
2006-04-19 14:00:00	AAPL	Stock	2.3539	2.355	2.3436	2.3518	85648836.0
2006-04-19 15:00:00	AAPL	Stock	2.3518	2.3539	2.3382	2.3436	151357640.0
2006-04-19 16:00:00	AAPL	Stock	2.3443	2.4746	2.2321	2.4571	200401180.0
2006-04-19 17:00:00	AAPL	Stock	2.4571	2.4625	2.3446	2.45	65830772.0
2006-04-19 18:00:00	AAPL	Stock	2.45	2.4536	2.4446	2.4486	8709960.0
2006-04-19 07:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	2000.0
2006-04-19 08:00:00	MSFT	Stock	27.27	27.32	27.25	27.27	35421.0
2006-04-19 09:00:00	MSFT	Stock	27.23	27.26	27.08	27.16	3723395.0
2006-04-19 10:00:00	MSFT	Stock	27.16	27.18	26.96	27.0	7758355.0
2006-04-19 11:00:00	MSFT	Stock	27.0	27.16	26.99	27.08	5724737.0
2006-04-19 12:00:00	MSFT	Stock	27.09	27.13	27.07	27.1	3759648.0
2006-04-19 13:00:00	MSFT	Stock	27.09	27.13	26.98	27.01	6172953.0
2006-04-19 14:00:00	MSFT	Stock	27.0	27.12	26.97	27.109	5302623.0
2006-04-19 15:00:00	MSFT	Stock	27.101	27.14	27.02	27.03	10191723.0
2006-04-19 16:00:00	MSFT	Stock	27.05	27.12	27.02	27.1	337971.0
2006-04-19 17:00:00	MSFT	Stock	27.03	27.11	27.03	27.08	4800.0
2006-04-19 08:00:00	NVDA	Stock	0.4833	0.4883	0.4833	0.4867	177000.0
2006-04-19 09:00:00	NVDA	Stock	0.4875	0.4878	0.4755	0.4797	57011940.0
2006-04-19 10:00:00	NVDA	Stock	0.4797	0.481	0.4733	0.4793	65198760.0
2006-04-19 11:00:00	NVDA	Stock	0.4793	0.4873	0.4792	0.4848	82987140.0
2006-04-19 12:00:00	NVDA	Stock	0.4848	0.4913	0.4848	0.4885	54632640.0
2006-04-19 13:00:00	NVDA	Stock	0.4883	0.4907	0.4878	0.4905	49725360.0
2006-04-19 14:00:00	NVDA	Stock	0.4902	0.4912	0.4878	0.4888	50340000.0
2006-04-19 15:00:00	NVDA	Stock	0.489	0.4897	0.4833	0.486	113060160.0
2006-04-19 16:00:00	NVDA	Stock	0.4858	0.4862	0.4787	0.4862	6868980.0
2006-04-19 17:00:00	NVDA	Stock	0.4835	0.4835	0.4765	0.4817	204000.0
2006-04-19 18:00:00	NVDA	Stock	0.4833	0.4833	0.4833	0.4833	30000.0
2006-04-19 09:00:00	AMZN	Stock	1.8225	1.848	1.7785	1.8275	12648220.0
2006-04-19 10:00:00	AMZN	Stock	1.8275	1.8395	1.8155	1.8324	13259120.0
2006-04-19 11:00:00	AMZN	Stock	1.831	1.8375	1.8275	1.836	10977840.0
2006-04-19 12:00:00	AMZN	Stock	1.8365	1.8475	1.835	1.8435	12254840.0
2006-04-19 13:00:00	AMZN	Stock	1.8435	1.8455	1.8375	1.844	9611560.0
2006-04-19 14:00:00	AMZN	Stock	1.844	1.8455	1.83	1.84	7661080.0
2006-04-19 15:00:00	AMZN	Stock	1.84	1.8455	1.8365	1.8425	14193460.0
2006-04-19 16:00:00	AMZN	Stock	1.8445	1.8445	1.8145	1.827	709040.0
2006-04-19 18:00:00	AMZN	Stock	1.8345	1.8445	1.8345	1.8445	28100.0
2006-04-19 09:00:00	CL	Stock	28.335	28.5	28.315	28.455	212200.0
2006-04-19 10:00:00	CL	Stock	28.455	28.475	28.22	28.245	261600.0
2006-04-19 11:00:00	CL	Stock	28.245	28.32	28.23	28.25	267800.0
2006-04-19 12:00:00	CL	Stock	28.25	28.4	28.25	28.37	182800.0
2006-04-19 13:00:00	CL	Stock	28.365	28.39	28.29	28.325	231800.0

> showing 50 of 28,816 rows — these rows as CSV

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