PREVIEW / stock_1hour / 2005-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-27.parquet
  size:    546 KB
  rows:    25,711
  symbols: 1,966

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-27 07:00:00	AAPL	Stock	1.2857	1.2857	1.2857	1.2857	25200.0
2005-04-27 08:00:00	AAPL	Stock	1.2875	1.2929	1.2696	1.2714	3033940.0
2005-04-27 09:00:00	AAPL	Stock	1.2711	1.2929	1.2711	1.28	104014988.0
2005-04-27 10:00:00	AAPL	Stock	1.28	1.2927	1.2682	1.2843	140874328.0
2005-04-27 11:00:00	AAPL	Stock	1.2846	1.2957	1.2757	1.2886	79681672.0
2005-04-27 12:00:00	AAPL	Stock	1.2886	1.2954	1.2861	1.2904	50793568.0
2005-04-27 13:00:00	AAPL	Stock	1.2904	1.2986	1.2839	1.2879	70128912.0
2005-04-27 14:00:00	AAPL	Stock	1.2882	1.2946	1.2846	1.2943	58369472.0
2005-04-27 15:00:00	AAPL	Stock	1.2943	1.2982	1.2796	1.2829	84544796.0
2005-04-27 16:00:00	AAPL	Stock	1.2829	1.2871	1.2821	1.2871	2564884.0
2005-04-27 17:00:00	AAPL	Stock	1.2871	1.2871	1.2829	1.2861	239120.0
2005-04-27 18:00:00	AAPL	Stock	1.2854	1.2854	1.2854	1.2854	60200.0
2005-04-27 08:00:00	MSFT	Stock	24.75	24.76	24.66	24.67	28514.0
2005-04-27 09:00:00	MSFT	Stock	24.66	24.85	24.63	24.83	6720144.0
2005-04-27 10:00:00	MSFT	Stock	24.82	24.91	24.77	24.87	7644797.0
2005-04-27 11:00:00	MSFT	Stock	24.87	25.0	24.81	24.99	7335047.0
2005-04-27 12:00:00	MSFT	Stock	24.98	25.15	24.98	25.03	6320576.0
2005-04-27 13:00:00	MSFT	Stock	25.03	25.12	24.96	24.99	5519837.0
2005-04-27 14:00:00	MSFT	Stock	24.99	25.1	24.95	25.079	4851908.0
2005-04-27 15:00:00	MSFT	Stock	25.08	25.1	24.94	24.97	7968234.0
2005-04-27 16:00:00	MSFT	Stock	24.98	25.0	24.89	24.99	295806.0
2005-04-27 17:00:00	MSFT	Stock	24.99	25.05	24.95	25.05	27342.0
2005-04-27 08:00:00	NVDA	Stock	0.1837	0.1846	0.1833	0.1833	564000.0
2005-04-27 09:00:00	NVDA	Stock	0.1829	0.1874	0.1768	0.177	125638560.0
2005-04-27 10:00:00	NVDA	Stock	0.177	0.18	0.1767	0.179	132806520.0
2005-04-27 11:00:00	NVDA	Stock	0.1791	0.1791	0.1765	0.1787	87991080.0
2005-04-27 12:00:00	NVDA	Stock	0.1787	0.1801	0.1784	0.1794	60387600.0
2005-04-27 13:00:00	NVDA	Stock	0.1794	0.1814	0.1794	0.1808	51595800.0
2005-04-27 14:00:00	NVDA	Stock	0.1808	0.1812	0.1796	0.1808	45276720.0
2005-04-27 15:00:00	NVDA	Stock	0.1809	0.1812	0.1789	0.1802	74984400.0
2005-04-27 16:00:00	NVDA	Stock	0.1801	0.1803	0.1794	0.1794	1724760.0
2005-04-27 17:00:00	NVDA	Stock	0.1794	0.1807	0.1794	0.1807	139080.0
2005-04-27 07:00:00	AMZN	Stock	1.55	1.565	1.55	1.5525	103700.0
2005-04-27 08:00:00	AMZN	Stock	1.5525	1.5595	1.52	1.5415	11440520.0
2005-04-27 09:00:00	AMZN	Stock	1.5405	1.5605	1.53	1.551	154858660.0
2005-04-27 10:00:00	AMZN	Stock	1.551	1.564	1.532	1.554	99536740.0
2005-04-27 11:00:00	AMZN	Stock	1.554	1.555	1.536	1.55	63965260.0
2005-04-27 12:00:00	AMZN	Stock	1.55	1.561	1.5475	1.559	57390900.0
2005-04-27 13:00:00	AMZN	Stock	1.559	1.564	1.554	1.5565	45627340.0
2005-04-27 14:00:00	AMZN	Stock	1.5565	1.5655	1.5525	1.5635	56699260.0
2005-04-27 15:00:00	AMZN	Stock	1.564	1.587	1.561	1.581	90387600.0
2005-04-27 16:00:00	AMZN	Stock	1.5805	1.5861	1.5545	1.5845	1152000.0
2005-04-27 17:00:00	AMZN	Stock	1.585	1.586	1.5785	1.58	428840.0
2005-04-27 18:00:00	AMZN	Stock	1.5805	1.5805	1.5775	1.578	126000.0
2005-04-27 08:00:00	CL	Stock	25.35	25.35	25.35	25.35	1800.0
2005-04-27 09:00:00	CL	Stock	25.325	25.33	24.25	24.835	1589400.0
2005-04-27 10:00:00	CL	Stock	24.835	25.17	24.755	24.865	1675400.0
2005-04-27 11:00:00	CL	Stock	24.86	24.985	24.83	24.875	701200.0
2005-04-27 12:00:00	CL	Stock	24.875	25.115	24.87	25.115	819800.0
2005-04-27 13:00:00	CL	Stock	25.115	25.215	25.095	25.165	663000.0

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

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