PREVIEW / stock_1hour / 2005-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-02.parquet
  size:    562 KB
  rows:    26,589
  symbols: 1,968

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-05-02 07:00:00	AAPL	Stock	1.2957	1.2957	1.2957	1.2957	5600.0
2005-05-02 08:00:00	AAPL	Stock	1.3	1.3032	1.2879	1.295	1198960.0
2005-05-02 09:00:00	AAPL	Stock	1.295	1.3054	1.2896	1.3032	75121256.0
2005-05-02 10:00:00	AAPL	Stock	1.3032	1.3089	1.2979	1.3057	89315408.0
2005-05-02 11:00:00	AAPL	Stock	1.3057	1.3071	1.2979	1.3007	51033976.0
2005-05-02 12:00:00	AAPL	Stock	1.3007	1.3036	1.2993	1.3007	33566260.0
2005-05-02 13:00:00	AAPL	Stock	1.3007	1.3018	1.2918	1.2979	54921468.0
2005-05-02 14:00:00	AAPL	Stock	1.2983	1.2983	1.2864	1.2896	59464076.0
2005-05-02 15:00:00	AAPL	Stock	1.2896	1.3032	1.2879	1.3007	90567400.0
2005-05-02 16:00:00	AAPL	Stock	1.2996	1.3018	1.2989	1.2993	2799524.0
2005-05-02 17:00:00	AAPL	Stock	1.3	1.3011	1.3	1.3	42000.0
2005-05-02 18:00:00	AAPL	Stock	1.3	1.3	1.2971	1.2971	223356.0
2005-05-02 07:00:00	MSFT	Stock	25.3	25.35	25.3	25.35	52850.0
2005-05-02 08:00:00	MSFT	Stock	25.35	25.38	25.3	25.3	90193.0
2005-05-02 09:00:00	MSFT	Stock	25.3	25.36	25.2	25.22	8216179.0
2005-05-02 10:00:00	MSFT	Stock	25.22	25.311	25.09	25.09	11874910.0
2005-05-02 11:00:00	MSFT	Stock	25.09	25.205	25.05	25.1	5760690.0
2005-05-02 12:00:00	MSFT	Stock	25.11	25.21	25.09	25.16	4972706.0
2005-05-02 13:00:00	MSFT	Stock	25.16	25.17	25.08	25.14	4996275.0
2005-05-02 14:00:00	MSFT	Stock	25.14	25.16	25.01	25.14	7503147.0
2005-05-02 15:00:00	MSFT	Stock	25.14	25.25	24.95	25.24	9184288.0
2005-05-02 16:00:00	MSFT	Stock	25.24	25.27	25.21	25.21	539592.0
2005-05-02 17:00:00	MSFT	Stock	25.21	25.22	25.21	25.22	1893.0
2005-05-02 18:00:00	MSFT	Stock	25.23	25.23	25.23	25.23	39647.0
2005-05-02 08:00:00	NVDA	Stock	0.1874	0.1874	0.1842	0.1842	594000.0
2005-05-02 09:00:00	NVDA	Stock	0.1842	0.187	0.1834	0.1848	69526680.0
2005-05-02 10:00:00	NVDA	Stock	0.185	0.1867	0.1825	0.1826	50621400.0
2005-05-02 11:00:00	NVDA	Stock	0.1826	0.1829	0.1809	0.1815	38819040.0
2005-05-02 12:00:00	NVDA	Stock	0.1814	0.1819	0.1808	0.1816	32095920.0
2005-05-02 13:00:00	NVDA	Stock	0.1817	0.1821	0.181	0.1817	17601240.0
2005-05-02 14:00:00	NVDA	Stock	0.1817	0.1817	0.1793	0.1797	47165040.0
2005-05-02 15:00:00	NVDA	Stock	0.1797	0.1822	0.1794	0.1818	55819080.0
2005-05-02 16:00:00	NVDA	Stock	0.1821	0.1822	0.1817	0.1821	1260480.0
2005-05-02 17:00:00	NVDA	Stock	0.1824	0.1824	0.1824	0.1824	7368120.0
2005-05-02 18:00:00	NVDA	Stock	0.182	0.1821	0.1817	0.1817	61560.0
2005-05-02 07:00:00	AMZN	Stock	1.592	1.592	1.592	1.592	2000.0
2005-05-02 08:00:00	AMZN	Stock	1.6155	1.617	1.6125	1.6125	98000.0
2005-05-02 09:00:00	AMZN	Stock	1.613	1.644	1.605	1.6435	13369120.0
2005-05-02 10:00:00	AMZN	Stock	1.643	1.6625	1.636	1.65	48784240.0
2005-05-02 11:00:00	AMZN	Stock	1.6505	1.66	1.647	1.6495	23766400.0
2005-05-02 12:00:00	AMZN	Stock	1.6495	1.65	1.644	1.6475	12746980.0
2005-05-02 13:00:00	AMZN	Stock	1.6475	1.6495	1.6415	1.6415	9372680.0
2005-05-02 14:00:00	AMZN	Stock	1.6415	1.65	1.632	1.648	24942560.0
2005-05-02 15:00:00	AMZN	Stock	1.6475	1.664	1.64	1.6555	46708920.0
2005-05-02 16:00:00	AMZN	Stock	1.655	1.659	1.651	1.655	732740.0
2005-05-02 17:00:00	AMZN	Stock	1.655	1.655	1.655	1.655	20000.0
2005-05-02 09:00:00	CL	Stock	24.965	25.045	24.875	25.01	504600.0
2005-05-02 10:00:00	CL	Stock	25.005	25.03	24.895	24.91	885200.0
2005-05-02 11:00:00	CL	Stock	24.91	24.99	24.9	24.98	278400.0
2005-05-02 12:00:00	CL	Stock	24.975	25.02	24.95	24.995	475400.0

> showing 50 of 26,589 rows — these rows as CSV

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