PREVIEW / stock_1hour / 2005-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-24.parquet
  size:    552 KB
  rows:    26,300
  symbols: 1,950

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-03-24 08:00:00	AAPL	Stock	1.5214	1.5339	1.5214	1.5293	2153228.0
2005-03-24 09:00:00	AAPL	Stock	1.5293	1.5357	1.5193	1.5268	57431108.0
2005-03-24 10:00:00	AAPL	Stock	1.5271	1.5357	1.5254	1.5329	78959048.0
2005-03-24 11:00:00	AAPL	Stock	1.5332	1.5332	1.5232	1.5293	45698464.0
2005-03-24 12:00:00	AAPL	Stock	1.5293	1.5336	1.5275	1.5314	32403112.0
2005-03-24 13:00:00	AAPL	Stock	1.5314	1.5321	1.5264	1.5271	28871416.0
2005-03-24 14:00:00	AAPL	Stock	1.5271	1.53	1.525	1.5286	23956324.0
2005-03-24 15:00:00	AAPL	Stock	1.5282	1.5293	1.5179	1.5196	67799760.0
2005-03-24 16:00:00	AAPL	Stock	1.5179	1.5243	1.5179	1.5229	5516392.0
2005-03-24 17:00:00	AAPL	Stock	1.5179	1.5246	1.5179	1.5207	150556.0
2005-03-24 18:00:00	AAPL	Stock	1.5214	1.5214	1.5207	1.5207	84000.0
2005-03-24 08:00:00	MSFT	Stock	24.3	24.3	24.27	24.27	28506.0
2005-03-24 09:00:00	MSFT	Stock	24.27	24.33	24.2	24.26	9032784.0
2005-03-24 10:00:00	MSFT	Stock	24.26	24.34	24.22	24.288	10891555.0
2005-03-24 11:00:00	MSFT	Stock	24.28	24.36	24.26	24.35	8248591.0
2005-03-24 12:00:00	MSFT	Stock	24.35	24.47	24.34	24.4	8572254.0
2005-03-24 13:00:00	MSFT	Stock	24.4	24.43	24.35	24.35	6237793.0
2005-03-24 14:00:00	MSFT	Stock	24.35	24.43	24.35	24.38	8532065.0
2005-03-24 15:00:00	MSFT	Stock	24.37	24.391	24.23	24.26	18407689.0
2005-03-24 16:00:00	MSFT	Stock	24.28	24.32	24.26	24.28	1737480.0
2005-03-24 17:00:00	MSFT	Stock	24.28	25.55	24.26	24.31	32573.0
2005-03-24 18:00:00	MSFT	Stock	24.31	24.31	24.3	24.3	600.0
2005-03-24 08:00:00	NVDA	Stock	0.2071	0.2087	0.2058	0.2086	3024000.0
2005-03-24 09:00:00	NVDA	Stock	0.2087	0.2124	0.2085	0.2124	113259960.0
2005-03-24 10:00:00	NVDA	Stock	0.2124	0.2152	0.2122	0.2147	143769960.0
2005-03-24 11:00:00	NVDA	Stock	0.2147	0.2151	0.2118	0.2119	144538800.0
2005-03-24 12:00:00	NVDA	Stock	0.2118	0.2131	0.2114	0.2122	91992240.0
2005-03-24 13:00:00	NVDA	Stock	0.2123	0.2125	0.2117	0.2117	42951600.0
2005-03-24 14:00:00	NVDA	Stock	0.2117	0.2131	0.2106	0.211	87347520.0
2005-03-24 15:00:00	NVDA	Stock	0.2109	0.2112	0.2092	0.2101	141135480.0
2005-03-24 16:00:00	NVDA	Stock	0.2096	0.21	0.2092	0.2092	1540200.0
2005-03-24 17:00:00	NVDA	Stock	0.2092	0.2092	0.209	0.2091	475680.0
2005-03-24 09:00:00	AMZN	Stock	1.673	1.694	1.6685	1.688	17362000.0
2005-03-24 10:00:00	AMZN	Stock	1.6885	1.69	1.6555	1.662	21445900.0
2005-03-24 11:00:00	AMZN	Stock	1.6625	1.664	1.651	1.6595	18131460.0
2005-03-24 12:00:00	AMZN	Stock	1.66	1.6675	1.657	1.6635	10366520.0
2005-03-24 13:00:00	AMZN	Stock	1.6635	1.665	1.66	1.6615	5158880.0
2005-03-24 14:00:00	AMZN	Stock	1.6615	1.6625	1.655	1.6605	6568540.0
2005-03-24 15:00:00	AMZN	Stock	1.6595	1.6615	1.6435	1.6435	23547280.0
2005-03-24 16:00:00	AMZN	Stock	1.645	1.646	1.639	1.644	1523480.0
2005-03-24 17:00:00	AMZN	Stock	1.644	1.644	1.6385	1.644	131640.0
2005-03-24 09:00:00	CL	Stock	26.0	26.075	25.97	26.065	309400.0
2005-03-24 10:00:00	CL	Stock	26.065	26.105	25.965	25.99	484600.0
2005-03-24 11:00:00	CL	Stock	25.975	25.98	25.865	25.935	445200.0
2005-03-24 12:00:00	CL	Stock	25.935	25.95	25.865	25.9065	292000.0
2005-03-24 13:00:00	CL	Stock	25.91	25.925	25.88	25.905	272400.0
2005-03-24 14:00:00	CL	Stock	25.905	25.945	25.885	25.945	389600.0
2005-03-24 15:00:00	CL	Stock	25.94	25.955	25.89	25.905	552200.0
2005-03-24 16:00:00	CL	Stock	25.905	25.905	25.885	25.885	21600.0
2005-03-24 17:00:00	CL	Stock	25.885	25.903	25.885	25.903	800.0

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

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