PREVIEW / stock_1hour / 2005-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-29.parquet
  size:    588 KB
  rows:    27,682
  symbols: 1,970

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-04-29 07:00:00	AAPL	Stock	1.2843	1.2857	1.2843	1.2843	82600.0
2005-04-29 08:00:00	AAPL	Stock	1.2843	1.2929	1.2825	1.2861	2899820.0
2005-04-29 09:00:00	AAPL	Stock	1.2868	1.2939	1.2693	1.2882	78816416.0
2005-04-29 10:00:00	AAPL	Stock	1.2882	1.2936	1.2579	1.2689	156020900.0
2005-04-29 11:00:00	AAPL	Stock	1.2686	1.2805	1.2643	1.2721	75154380.0
2005-04-29 12:00:00	AAPL	Stock	1.2718	1.2789	1.2689	1.2757	41088320.0
2005-04-29 13:00:00	AAPL	Stock	1.2757	1.2896	1.2757	1.2811	93779588.0
2005-04-29 14:00:00	AAPL	Stock	1.2807	1.2914	1.2782	1.2882	77049896.0
2005-04-29 15:00:00	AAPL	Stock	1.2882	1.29	1.2825	1.2871	105718088.0
2005-04-29 16:00:00	AAPL	Stock	1.2861	1.295	1.2857	1.295	5303312.0
2005-04-29 17:00:00	AAPL	Stock	1.295	1.295	1.2845	1.2936	524020.0
2005-04-29 18:00:00	AAPL	Stock	1.2918	1.2939	1.2875	1.2918	203140.0
2005-04-29 07:00:00	MSFT	Stock	24.99	25.08	24.98	25.05	5100.0
2005-04-29 08:00:00	MSFT	Stock	24.78	24.94	24.77	24.81	729016.0
2005-04-29 09:00:00	MSFT	Stock	24.81	24.99	24.46	24.88	14508744.0
2005-04-29 10:00:00	MSFT	Stock	24.88	24.98	24.79	24.85	19474545.0
2005-04-29 11:00:00	MSFT	Stock	24.85	24.92	24.8	24.9	9576093.0
2005-04-29 12:00:00	MSFT	Stock	24.89	24.97	24.879	24.93	6136087.0
2005-04-29 13:00:00	MSFT	Stock	24.93	25.0	24.9	24.97	6454430.0
2005-04-29 14:00:00	MSFT	Stock	24.97	25.18	24.95	25.14	15176109.0
2005-04-29 15:00:00	MSFT	Stock	25.14	25.29	25.08	25.28	20729116.0
2005-04-29 16:00:00	MSFT	Stock	25.28	25.33	25.19	25.3	2153198.0
2005-04-29 17:00:00	MSFT	Stock	25.29	25.3	25.102	25.28	49691.0
2005-04-29 18:00:00	MSFT	Stock	25.28	25.3	25.27	25.27	106745.0
2005-04-29 08:00:00	NVDA	Stock	0.1842	0.1842	0.1817	0.1833	168000.0
2005-04-29 09:00:00	NVDA	Stock	0.1823	0.184	0.1806	0.1812	32964000.0
2005-04-29 10:00:00	NVDA	Stock	0.1813	0.1822	0.1743	0.1757	105944040.0
2005-04-29 11:00:00	NVDA	Stock	0.1757	0.1781	0.1752	0.1768	56263800.0
2005-04-29 12:00:00	NVDA	Stock	0.1769	0.1787	0.1762	0.1783	36048840.0
2005-04-29 13:00:00	NVDA	Stock	0.1782	0.1802	0.1781	0.1792	31420920.0
2005-04-29 14:00:00	NVDA	Stock	0.1792	0.1826	0.1788	0.1822	59169960.0
2005-04-29 15:00:00	NVDA	Stock	0.1822	0.1836	0.1817	0.1827	130001160.0
2005-04-29 16:00:00	NVDA	Stock	0.1833	0.1836	0.1828	0.1828	15339240.0
2005-04-29 17:00:00	NVDA	Stock	0.1827	0.1827	0.1825	0.1825	120000.0
2005-04-29 18:00:00	NVDA	Stock	0.1827	0.1828	0.1827	0.1828	151920.0
2005-04-29 08:00:00	AMZN	Stock	1.635	1.6425	1.635	1.6425	23800.0
2005-04-29 09:00:00	AMZN	Stock	1.6425	1.645	1.6105	1.617	28133400.0
2005-04-29 10:00:00	AMZN	Stock	1.617	1.6195	1.591	1.592	39286220.0
2005-04-29 11:00:00	AMZN	Stock	1.592	1.595	1.576	1.5775	25884220.0
2005-04-29 12:00:00	AMZN	Stock	1.5775	1.611	1.5765	1.6095	27377660.0
2005-04-29 13:00:00	AMZN	Stock	1.6095	1.615	1.6045	1.611	19114840.0
2005-04-29 14:00:00	AMZN	Stock	1.6115	1.628	1.6025	1.6165	22499020.0
2005-04-29 15:00:00	AMZN	Stock	1.6165	1.6214	1.6125	1.618	43700500.0
2005-04-29 16:00:00	AMZN	Stock	1.618	1.6305	1.615	1.6175	1878020.0
2005-04-29 17:00:00	AMZN	Stock	1.615	1.618	1.615	1.618	206340.0
2005-04-29 18:00:00	AMZN	Stock	1.6155	1.6155	1.6155	1.6155	13980.0
2005-04-29 09:00:00	CL	Stock	25.285	25.3565	25.07	25.14	366400.0
2005-04-29 10:00:00	CL	Stock	25.135	25.23	24.855	24.915	785600.0
2005-04-29 11:00:00	CL	Stock	24.93	24.98	24.885	24.925	548800.0
2005-04-29 12:00:00	CL	Stock	24.925	24.965	24.765	24.935	552200.0

> showing 50 of 27,682 rows — these rows as CSV

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