PREVIEW / stock_1hour / 2005-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-13.parquet
  size:    552 KB
  rows:    25,936
  symbols: 1,959

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-13 07:00:00	AAPL	Stock	1.5357	1.5393	1.5357	1.5393	204400.0
2005-04-13 08:00:00	AAPL	Stock	1.5357	1.5389	1.5271	1.5293	3048892.0
2005-04-13 09:00:00	AAPL	Stock	1.5289	1.5354	1.5029	1.5075	147123732.0
2005-04-13 10:00:00	AAPL	Stock	1.5071	1.5107	1.4939	1.4979	171995376.0
2005-04-13 11:00:00	AAPL	Stock	1.4982	1.5025	1.4686	1.475	211839656.0
2005-04-13 12:00:00	AAPL	Stock	1.475	1.4907	1.4618	1.4896	152595660.0
2005-04-13 13:00:00	AAPL	Stock	1.4893	1.4946	1.4732	1.4808	91113708.0
2005-04-13 14:00:00	AAPL	Stock	1.4807	1.4818	1.465	1.4664	92976156.0
2005-04-13 15:00:00	AAPL	Stock	1.4664	1.4964	1.4625	1.4643	295079176.0
2005-04-13 16:00:00	AAPL	Stock	1.4643	1.4921	1.3829	1.4554	194464396.0
2005-04-13 17:00:00	AAPL	Stock	1.4586	1.4657	1.4429	1.4539	45119760.0
2005-04-13 18:00:00	AAPL	Stock	1.4554	1.4586	1.4429	1.4482	10568572.0
2005-04-13 08:00:00	MSFT	Stock	25.34	25.34	25.27	25.27	14135.0
2005-04-13 09:00:00	MSFT	Stock	25.26	25.36	25.17	25.34	7458109.0
2005-04-13 10:00:00	MSFT	Stock	25.34	25.45	25.29	25.31	8581928.0
2005-04-13 11:00:00	MSFT	Stock	25.32	25.4	25.26	25.37	7688999.0
2005-04-13 12:00:00	MSFT	Stock	25.361	25.37	25.25	25.27	5134425.0
2005-04-13 13:00:00	MSFT	Stock	25.27	25.28	25.13	25.14	7873253.0
2005-04-13 14:00:00	MSFT	Stock	25.13	25.17	25.03	25.05	7563269.0
2005-04-13 15:00:00	MSFT	Stock	25.05	25.1	24.99	25.03	11338378.0
2005-04-13 16:00:00	MSFT	Stock	25.03	25.05	24.92	24.98	673779.0
2005-04-13 17:00:00	MSFT	Stock	25.04	25.04	24.96	24.99	29186.0
2005-04-13 18:00:00	MSFT	Stock	24.99	24.99	24.98	24.99	2600.0
2005-04-13 08:00:00	NVDA	Stock	0.1943	0.1943	0.1943	0.1943	54120.0
2005-04-13 09:00:00	NVDA	Stock	0.1941	0.1949	0.1902	0.1904	64634880.0
2005-04-13 10:00:00	NVDA	Stock	0.1907	0.1923	0.1896	0.1904	47497440.0
2005-04-13 11:00:00	NVDA	Stock	0.1906	0.1906	0.1894	0.1903	26211240.0
2005-04-13 12:00:00	NVDA	Stock	0.1903	0.1903	0.1869	0.1881	96254040.0
2005-04-13 13:00:00	NVDA	Stock	0.1881	0.1882	0.1847	0.1852	81003120.0
2005-04-13 14:00:00	NVDA	Stock	0.1853	0.1868	0.1852	0.1862	88021200.0
2005-04-13 15:00:00	NVDA	Stock	0.1862	0.1862	0.1846	0.1857	71829240.0
2005-04-13 16:00:00	NVDA	Stock	0.186	0.186	0.1844	0.1844	2280960.0
2005-04-13 17:00:00	NVDA	Stock	0.1852	0.1858	0.1852	0.1858	228000.0
2005-04-13 09:00:00	AMZN	Stock	1.7295	1.7355	1.717	1.732	11905840.0
2005-04-13 10:00:00	AMZN	Stock	1.7315	1.735	1.723	1.725	16745980.0
2005-04-13 11:00:00	AMZN	Stock	1.7265	1.734	1.725	1.7295	9661340.0
2005-04-13 12:00:00	AMZN	Stock	1.7295	1.7305	1.7255	1.728	2867060.0
2005-04-13 13:00:00	AMZN	Stock	1.728	1.729	1.7165	1.717	12040300.0
2005-04-13 14:00:00	AMZN	Stock	1.717	1.717	1.7105	1.711	7507160.0
2005-04-13 15:00:00	AMZN	Stock	1.711	1.7175	1.7075	1.7125	20119960.0
2005-04-13 16:00:00	AMZN	Stock	1.7125	1.7225	1.709	1.709	551060.0
2005-04-13 17:00:00	AMZN	Stock	1.7155	1.7155	1.715	1.715	2509900.0
2005-04-13 18:00:00	AMZN	Stock	1.715	1.715	1.715	1.715	20000.0
2005-04-13 09:00:00	CL	Stock	27.035	27.175	27.025	27.065	339600.0
2005-04-13 10:00:00	CL	Stock	27.035	27.14	27.01	27.1	539800.0
2005-04-13 11:00:00	CL	Stock	27.085	27.145	27.025	27.07	401600.0
2005-04-13 12:00:00	CL	Stock	27.065	27.075	27.0	27.07	634200.0
2005-04-13 13:00:00	CL	Stock	27.05	27.065	26.765	26.765	919800.0
2005-04-13 14:00:00	CL	Stock	26.765	26.945	26.765	26.895	316400.0
2005-04-13 15:00:00	CL	Stock	26.9	26.975	26.855	26.93	435800.0

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

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