PREVIEW / stock_1hour / 2006-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-01.parquet
  size:    633 KB
  rows:    30,272
  symbols: 2,266

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
2006-06-01 07:00:00	AAPL	Stock	2.1286	2.1286	2.1286	2.1286	5600.0
2006-06-01 08:00:00	AAPL	Stock	2.1286	2.1479	2.1254	2.1468	2332344.0
2006-06-01 09:00:00	AAPL	Stock	2.1464	2.1521	2.1257	2.1429	127826832.0
2006-06-01 10:00:00	AAPL	Stock	2.1436	2.1993	2.1357	2.1968	273311892.0
2006-06-01 11:00:00	AAPL	Stock	2.1971	2.2136	2.1911	2.2046	143744692.0
2006-06-01 12:00:00	AAPL	Stock	2.2046	2.2171	2.2	2.2007	77675024.0
2006-06-01 13:00:00	AAPL	Stock	2.2004	2.2139	2.2	2.2107	38470712.0
2006-06-01 14:00:00	AAPL	Stock	2.2107	2.2207	2.1993	2.2164	99992788.0
2006-06-01 15:00:00	AAPL	Stock	2.2168	2.2243	2.2082	2.2175	155648164.0
2006-06-01 16:00:00	AAPL	Stock	2.2193	2.2214	2.2143	2.2204	2402148.0
2006-06-01 17:00:00	AAPL	Stock	2.2204	2.2204	2.2179	2.2186	612472.0
2006-06-01 18:00:00	AAPL	Stock	2.2186	2.2204	2.2179	2.2204	209216.0
2006-06-01 05:00:00	MSFT	Stock	22.68	22.68	22.68	22.68	200.0
2006-06-01 06:00:00	MSFT	Stock	22.65	22.65	22.65	22.65	400.0
2006-06-01 07:00:00	MSFT	Stock	22.64	22.67	22.64	22.67	7100.0
2006-06-01 08:00:00	MSFT	Stock	22.7	22.74	22.65	22.74	176358.0
2006-06-01 09:00:00	MSFT	Stock	22.65	22.79	22.65	22.69	11261643.0
2006-06-01 10:00:00	MSFT	Stock	22.69	22.79	22.66	22.7	10903942.0
2006-06-01 11:00:00	MSFT	Stock	22.69	22.75	22.65	22.66	10713535.0
2006-06-01 12:00:00	MSFT	Stock	22.66	22.71	22.62	22.67	8533072.0
2006-06-01 13:00:00	MSFT	Stock	22.67	22.67	22.649	22.66	2936586.0
2006-06-01 14:00:00	MSFT	Stock	22.66	22.75	22.65	22.74	9273499.0
2006-06-01 15:00:00	MSFT	Stock	22.75	22.84	22.65	22.84	18406909.0
2006-06-01 16:00:00	MSFT	Stock	22.81	22.85	22.78	22.8	165415.0
2006-06-01 17:00:00	MSFT	Stock	22.8	22.81	22.8	22.8	17725.0
2006-06-01 18:00:00	MSFT	Stock	22.82	22.829	22.8	22.82	8090.0
2006-06-01 08:00:00	NVDA	Stock	0.3808	0.3837	0.3808	0.3837	148200.0
2006-06-01 09:00:00	NVDA	Stock	0.3827	0.392	0.3813	0.387	55312860.0
2006-06-01 10:00:00	NVDA	Stock	0.3867	0.3958	0.3843	0.3953	88240260.0
2006-06-01 11:00:00	NVDA	Stock	0.3953	0.3958	0.3935	0.3947	54491280.0
2006-06-01 12:00:00	NVDA	Stock	0.3947	0.3965	0.3928	0.3955	54681660.0
2006-06-01 13:00:00	NVDA	Stock	0.3957	0.3983	0.3938	0.3983	48429600.0
2006-06-01 14:00:00	NVDA	Stock	0.3982	0.4022	0.3958	0.3997	71603700.0
2006-06-01 15:00:00	NVDA	Stock	0.3997	0.403	0.3995	0.403	142271880.0
2006-06-01 16:00:00	NVDA	Stock	0.4028	0.4033	0.4017	0.4017	712020.0
2006-06-01 17:00:00	NVDA	Stock	0.4017	0.4042	0.4017	0.4038	359760.0
2006-06-01 18:00:00	NVDA	Stock	0.4048	0.4048	0.403	0.403	99720.0
2006-06-01 08:00:00	AMZN	Stock	1.7305	1.7305	1.7305	1.7305	1543000.0
2006-06-01 09:00:00	AMZN	Stock	1.7305	1.7345	1.715	1.729	8674220.0
2006-06-01 10:00:00	AMZN	Stock	1.7285	1.7395	1.7175	1.7335	12766140.0
2006-06-01 11:00:00	AMZN	Stock	1.733	1.742	1.7285	1.7365	7789680.0
2006-06-01 12:00:00	AMZN	Stock	1.7365	1.745	1.7355	1.74	5083020.0
2006-06-01 13:00:00	AMZN	Stock	1.7405	1.7415	1.7375	1.7405	3117900.0
2006-06-01 14:00:00	AMZN	Stock	1.7405	1.768	1.739	1.765	16842920.0
2006-06-01 15:00:00	AMZN	Stock	1.7655	1.7725	1.7465	1.7505	35221460.0
2006-06-01 16:00:00	AMZN	Stock	1.75	1.762	1.748	1.7535	348440.0
2006-06-01 18:00:00	AMZN	Stock	1.7534	1.7534	1.7534	1.7534	2680.0
2006-06-01 08:00:00	CL	Stock	30.17	30.17	30.17	30.17	13000.0
2006-06-01 09:00:00	CL	Stock	30.11	30.325	30.05	30.11	293000.0
2006-06-01 10:00:00	CL	Stock	30.1	30.2	30.025	30.125	461000.0

> showing 50 of 30,272 rows — these rows as CSV

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