PREVIEW / stock_1hour / 2005-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-13.parquet
  size:    528 KB
  rows:    24,731
  symbols: 1,906

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-01-13 08:00:00	AAPL	Stock	1.3182	1.3304	1.3036	1.33	124354720.0
2005-01-13 09:00:00	AAPL	Stock	1.33	1.332	1.2879	1.2884	824224968.0
2005-01-13 10:00:00	AAPL	Stock	1.2886	1.3127	1.2679	1.2827	706319880.0
2005-01-13 11:00:00	AAPL	Stock	1.2827	1.2868	1.2614	1.2677	357613368.0
2005-01-13 12:00:00	AAPL	Stock	1.2677	1.2871	1.2657	1.2818	211607872.0
2005-01-13 13:00:00	AAPL	Stock	1.2816	1.2884	1.27	1.2775	190890000.0
2005-01-13 14:00:00	AAPL	Stock	1.2776	1.2777	1.2629	1.265	188144432.0
2005-01-13 15:00:00	AAPL	Stock	1.2648	1.2732	1.2452	1.247	536057816.0
2005-01-13 16:00:00	AAPL	Stock	1.247	1.248	1.2411	1.2425	14116760.0
2005-01-13 17:00:00	AAPL	Stock	1.2434	1.2456	1.2321	1.2416	6232800.0
2005-01-13 18:00:00	AAPL	Stock	1.2416	1.2429	1.2416	1.2427	465136.0
2005-01-13 08:00:00	MSFT	Stock	26.8	26.8	26.68	26.73	88798.0
2005-01-13 09:00:00	MSFT	Stock	26.72	26.75	26.65	26.68	6086040.0
2005-01-13 10:00:00	MSFT	Stock	26.68	26.8	26.57	26.6	12604663.0
2005-01-13 11:00:00	MSFT	Stock	26.6	26.64	26.55	26.601	9674524.0
2005-01-13 12:00:00	MSFT	Stock	26.61	26.66	26.59	26.61	5652249.0
2005-01-13 13:00:00	MSFT	Stock	26.61	26.66	26.549	26.55	8662049.0
2005-01-13 14:00:00	MSFT	Stock	26.55	26.569	26.46	26.48	12961508.0
2005-01-13 15:00:00	MSFT	Stock	26.47	26.49	26.16	26.27	28878232.0
2005-01-13 16:00:00	MSFT	Stock	26.27	26.32	26.26	26.31	2899867.0
2005-01-13 17:00:00	MSFT	Stock	26.29	26.31	26.27	26.3	84140.0
2005-01-13 18:00:00	MSFT	Stock	26.3	26.31	26.3	26.31	1816.0
2005-01-13 08:00:00	NVDA	Stock	0.1762	0.1775	0.1762	0.1775	948000.0
2005-01-13 09:00:00	NVDA	Stock	0.1772	0.1775	0.1733	0.1752	103386840.0
2005-01-13 10:00:00	NVDA	Stock	0.1751	0.1792	0.1749	0.1783	126993240.0
2005-01-13 11:00:00	NVDA	Stock	0.1784	0.1798	0.177	0.1787	106382760.0
2005-01-13 12:00:00	NVDA	Stock	0.1787	0.18	0.1782	0.1798	44988720.0
2005-01-13 13:00:00	NVDA	Stock	0.1799	0.1822	0.1798	0.182	105506760.0
2005-01-13 14:00:00	NVDA	Stock	0.182	0.1833	0.1812	0.1812	133731960.0
2005-01-13 15:00:00	NVDA	Stock	0.1812	0.1826	0.1773	0.1787	237783480.0
2005-01-13 16:00:00	NVDA	Stock	0.1788	0.1788	0.1785	0.1786	432000.0
2005-01-13 17:00:00	NVDA	Stock	0.1782	0.1782	0.1782	0.1782	12000.0
2005-01-13 18:00:00	NVDA	Stock	0.1786	0.1786	0.1786	0.1786	12000.0
2005-01-13 08:00:00	AMZN	Stock	2.12	2.135	2.115	2.1225	100320.0
2005-01-13 09:00:00	AMZN	Stock	2.1225	2.1595	2.117	2.159	31228260.0
2005-01-13 10:00:00	AMZN	Stock	2.1585	2.229	2.1575	2.181	164179140.0
2005-01-13 11:00:00	AMZN	Stock	2.181	2.1865	2.1635	2.18	35854180.0
2005-01-13 12:00:00	AMZN	Stock	2.179	2.1875	2.175	2.179	17586100.0
2005-01-13 13:00:00	AMZN	Stock	2.1775	2.18	2.15	2.172	24747840.0
2005-01-13 14:00:00	AMZN	Stock	2.1725	2.1845	2.159	2.1595	21164100.0
2005-01-13 15:00:00	AMZN	Stock	2.1595	2.1615	2.1275	2.1305	42907100.0
2005-01-13 16:00:00	AMZN	Stock	2.1295	2.136	2.125	2.125	1096400.0
2005-01-13 17:00:00	AMZN	Stock	2.13	2.1305	2.125	2.125	605220.0
2005-01-13 18:00:00	AMZN	Stock	2.125	2.125	2.1185	2.1185	12000.0
2005-01-13 09:00:00	CL	Stock	25.25	25.435	25.25	25.405	496600.0
2005-01-13 10:00:00	CL	Stock	25.4	25.4	25.005	25.005	825600.0
2005-01-13 11:00:00	CL	Stock	25.0	25.1	24.985	25.005	837000.0
2005-01-13 12:00:00	CL	Stock	25.005	25.14	25.0	25.04	418400.0
2005-01-13 13:00:00	CL	Stock	25.04	25.08	25.015	25.065	310200.0
2005-01-13 14:00:00	CL	Stock	25.07	25.09	25.005	25.025	307600.0

> showing 50 of 24,731 rows — these rows as CSV

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