PREVIEW / stock_1hour / 2006-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-20.parquet
  size:    599 KB
  rows:    28,273
  symbols: 2,173

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-01-20 05:00:00	AAPL	Stock	2.8286	2.8286	2.8286	2.8286	5600.0
2006-01-20 06:00:00	AAPL	Stock	2.8264	2.8264	2.8093	2.8093	32200.0
2006-01-20 07:00:00	AAPL	Stock	2.8089	2.8232	2.8071	2.8214	199836.0
2006-01-20 08:00:00	AAPL	Stock	2.8214	2.8429	2.8175	2.8361	2545984.0
2006-01-20 09:00:00	AAPL	Stock	2.8361	2.8586	2.8261	2.8396	117774496.0
2006-01-20 10:00:00	AAPL	Stock	2.84	2.8557	2.77	2.7882	278921748.0
2006-01-20 11:00:00	AAPL	Stock	2.7882	2.7982	2.7532	2.7614	167912864.0
2006-01-20 12:00:00	AAPL	Stock	2.7614	2.775	2.7336	2.7557	124293512.0
2006-01-20 13:00:00	AAPL	Stock	2.755	2.7643	2.7404	2.7557	107489704.0
2006-01-20 14:00:00	AAPL	Stock	2.7561	2.7607	2.7418	2.745	109131820.0
2006-01-20 15:00:00	AAPL	Stock	2.7454	2.7631	2.7082	2.7175	191790312.0
2006-01-20 16:00:00	AAPL	Stock	2.7161	2.7232	2.7143	2.7179	15603056.0
2006-01-20 17:00:00	AAPL	Stock	2.7211	2.7339	2.716	2.716	1123024.0
2006-01-20 18:00:00	AAPL	Stock	2.725	2.7314	2.7232	2.73	407232.0
2006-01-20 04:00:00	MSFT	Stock	26.63	26.63	26.63	26.63	400.0
2006-01-20 08:00:00	MSFT	Stock	26.99	26.99	26.91	26.93	2255.0
2006-01-20 09:00:00	MSFT	Stock	26.95	27.06	26.92	26.942	8401960.0
2006-01-20 10:00:00	MSFT	Stock	26.95	27.0	26.87	26.93	8058121.0
2006-01-20 11:00:00	MSFT	Stock	26.93	26.95	26.81	26.86	10225109.0
2006-01-20 12:00:00	MSFT	Stock	26.86	26.9	26.63	26.702	9970482.0
2006-01-20 13:00:00	MSFT	Stock	26.7	26.75	26.53	26.57	9741724.0
2006-01-20 14:00:00	MSFT	Stock	26.56	26.62	26.46	26.47	10115841.0
2006-01-20 15:00:00	MSFT	Stock	26.47	26.59	26.26	26.45	21122791.0
2006-01-20 16:00:00	MSFT	Stock	26.44	26.638	26.36	26.46	329715.0
2006-01-20 17:00:00	MSFT	Stock	26.46	26.51	26.45	26.46	21689.0
2006-01-20 18:00:00	MSFT	Stock	26.438	26.52	26.43	26.52	10836.0
2006-01-20 08:00:00	NVDA	Stock	0.3757	0.376	0.3742	0.3742	264000.0
2006-01-20 09:00:00	NVDA	Stock	0.3741	0.3805	0.3717	0.3725	72761160.0
2006-01-20 10:00:00	NVDA	Stock	0.3726	0.3726	0.3679	0.3707	89805600.0
2006-01-20 11:00:00	NVDA	Stock	0.3707	0.3711	0.3683	0.3685	55733160.0
2006-01-20 12:00:00	NVDA	Stock	0.3687	0.3703	0.3674	0.3683	50243640.0
2006-01-20 13:00:00	NVDA	Stock	0.3682	0.3702	0.3671	0.3672	41711280.0
2006-01-20 14:00:00	NVDA	Stock	0.3675	0.3686	0.3659	0.3661	50509080.0
2006-01-20 15:00:00	NVDA	Stock	0.3662	0.3684	0.365	0.365	89073840.0
2006-01-20 16:00:00	NVDA	Stock	0.3651	0.3662	0.3649	0.3662	1361880.0
2006-01-20 17:00:00	NVDA	Stock	0.3658	0.3667	0.3658	0.3667	168120.0
2006-01-20 18:00:00	NVDA	Stock	0.3651	0.3651	0.3651	0.3651	17400.0
2006-01-20 09:00:00	AMZN	Stock	2.219	2.228	2.202	2.206	11129780.0
2006-01-20 10:00:00	AMZN	Stock	2.206	2.209	2.18	2.1935	19086960.0
2006-01-20 11:00:00	AMZN	Stock	2.1935	2.2045	2.1865	2.1905	15284100.0
2006-01-20 12:00:00	AMZN	Stock	2.19	2.2	2.16	2.1835	16176020.0
2006-01-20 13:00:00	AMZN	Stock	2.183	2.202	2.1695	2.1825	19644780.0
2006-01-20 14:00:00	AMZN	Stock	2.1825	2.204	2.1795	2.192	20617700.0
2006-01-20 15:00:00	AMZN	Stock	2.1905	2.207	2.186	2.196	41163840.0
2006-01-20 16:00:00	AMZN	Stock	2.196	2.204	2.1957	2.2025	18176240.0
2006-01-20 17:00:00	AMZN	Stock	2.1995	2.2	2.1955	2.2	33300.0
2006-01-20 18:00:00	AMZN	Stock	2.1958	2.2	2.1958	2.2	10840.0
2006-01-20 09:00:00	CL	Stock	27.425	27.47	27.25	27.28	568000.0
2006-01-20 10:00:00	CL	Stock	27.285	27.34	27.245	27.26	799600.0
2006-01-20 11:00:00	CL	Stock	27.27	27.2725	26.93	26.95	1000600.0

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

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