PREVIEW / stock_1hour / 2005-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-09.parquet
  size:    542 KB
  rows:    25,635
  symbols: 1,932

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
2005-02-09 08:00:00	AAPL	Stock	1.4464	1.4548	1.4455	1.4536	1511216.0
2005-02-09 09:00:00	AAPL	Stock	1.4548	1.4598	1.4439	1.4571	114431968.0
2005-02-09 10:00:00	AAPL	Stock	1.4573	1.4641	1.4486	1.4534	189534856.0
2005-02-09 11:00:00	AAPL	Stock	1.4532	1.4598	1.4495	1.4516	78920184.0
2005-02-09 12:00:00	AAPL	Stock	1.452	1.4555	1.4502	1.4518	45845352.0
2005-02-09 13:00:00	AAPL	Stock	1.4518	1.4539	1.4491	1.4495	50761984.0
2005-02-09 14:00:00	AAPL	Stock	1.4495	1.4496	1.3946	1.4098	488857544.0
2005-02-09 15:00:00	AAPL	Stock	1.4098	1.4173	1.4021	1.4071	207480336.0
2005-02-09 16:00:00	AAPL	Stock	1.4068	1.408	1.4036	1.4071	3674496.0
2005-02-09 17:00:00	AAPL	Stock	1.4077	1.437	1.4059	1.4093	1961400.0
2005-02-09 18:00:00	AAPL	Stock	1.4093	1.4125	1.4039	1.4107	351680.0
2005-02-09 08:00:00	MSFT	Stock	26.28	26.29	26.24	26.27	62650.0
2005-02-09 09:00:00	MSFT	Stock	26.26	26.3	26.18	26.21	7804953.0
2005-02-09 10:00:00	MSFT	Stock	26.21	26.31	26.13	26.18	21109825.0
2005-02-09 11:00:00	MSFT	Stock	26.18	26.19	26.12	26.14	7339261.0
2005-02-09 12:00:00	MSFT	Stock	26.13	26.19	26.12	26.13	4436858.0
2005-02-09 13:00:00	MSFT	Stock	26.13	26.17	26.12	26.13	4925144.0
2005-02-09 14:00:00	MSFT	Stock	26.13	26.2	26.08	26.09	10990093.0
2005-02-09 15:00:00	MSFT	Stock	26.09	26.24	26.04	26.09	17456687.0
2005-02-09 16:00:00	MSFT	Stock	26.08	26.11	26.05	26.06	434371.0
2005-02-09 17:00:00	MSFT	Stock	26.06	26.142	26.06	26.1	1692731.0
2005-02-09 18:00:00	MSFT	Stock	26.06	26.11	26.06	26.11	725.0
2005-02-09 09:00:00	NVDA	Stock	0.2148	0.2162	0.2127	0.2134	119205120.0
2005-02-09 10:00:00	NVDA	Stock	0.2136	0.2142	0.2092	0.2098	177937080.0
2005-02-09 11:00:00	NVDA	Stock	0.2099	0.2112	0.2094	0.2112	73656480.0
2005-02-09 12:00:00	NVDA	Stock	0.2112	0.2124	0.2111	0.2119	49148760.0
2005-02-09 13:00:00	NVDA	Stock	0.2119	0.2122	0.2114	0.2117	49397760.0
2005-02-09 14:00:00	NVDA	Stock	0.2117	0.2117	0.2068	0.2074	138022560.0
2005-02-09 15:00:00	NVDA	Stock	0.2074	0.2084	0.2058	0.2072	157032120.0
2005-02-09 16:00:00	NVDA	Stock	0.2071	0.2076	0.2066	0.2075	6510240.0
2005-02-09 17:00:00	NVDA	Stock	0.2072	0.2077	0.2072	0.2077	97200.0
2005-02-09 18:00:00	NVDA	Stock	0.2079	0.2154	0.2073	0.2073	132000.0
2005-02-09 08:00:00	AMZN	Stock	1.818	1.8275	1.815	1.826	214140.0
2005-02-09 09:00:00	AMZN	Stock	1.8255	1.84	1.8165	1.8225	24756000.0
2005-02-09 10:00:00	AMZN	Stock	1.8225	1.8265	1.8175	1.823	38221880.0
2005-02-09 11:00:00	AMZN	Stock	1.823	1.824	1.82	1.822	16155520.0
2005-02-09 12:00:00	AMZN	Stock	1.822	1.8265	1.821	1.8215	9868400.0
2005-02-09 13:00:00	AMZN	Stock	1.821	1.824	1.82	1.821	11588800.0
2005-02-09 14:00:00	AMZN	Stock	1.8215	1.822	1.7965	1.804	25248080.0
2005-02-09 15:00:00	AMZN	Stock	1.8035	1.8205	1.7935	1.7935	30811580.0
2005-02-09 16:00:00	AMZN	Stock	1.7945	1.7985	1.792	1.7945	679300.0
2005-02-09 17:00:00	AMZN	Stock	1.797	1.8151	1.7925	1.794	277020.0
2005-02-09 18:00:00	AMZN	Stock	1.796	1.796	1.796	1.796	2940.0
2005-02-09 09:00:00	CL	Stock	27.455	27.495	27.385	27.475	279400.0
2005-02-09 10:00:00	CL	Stock	27.47	27.5	27.265	27.355	826000.0
2005-02-09 11:00:00	CL	Stock	27.36	27.38	27.27	27.335	342600.0
2005-02-09 12:00:00	CL	Stock	27.335	27.34	27.28	27.285	483800.0
2005-02-09 13:00:00	CL	Stock	27.28	27.365	27.26	27.32	261200.0
2005-02-09 14:00:00	CL	Stock	27.32	27.33	27.22	27.29	490400.0
2005-02-09 15:00:00	CL	Stock	27.29	27.335	27.24	27.26	796600.0

> showing 50 of 25,635 rows — these rows as CSV

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