PREVIEW / stock_1hour / 2006-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-31.parquet
  size:    604 KB
  rows:    28,297
  symbols: 2,193

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-01-31 06:00:00	AAPL	Stock	2.6875	2.6893	2.6875	2.6893	25200.0
2006-01-31 07:00:00	AAPL	Stock	2.6961	2.7011	2.6789	2.6871	148400.0
2006-01-31 08:00:00	AAPL	Stock	2.6925	2.7139	2.6825	2.6946	3545080.0
2006-01-31 09:00:00	AAPL	Stock	2.6929	2.7	2.6475	2.6625	147319228.0
2006-01-31 10:00:00	AAPL	Stock	2.6625	2.7018	2.6339	2.6979	209823012.0
2006-01-31 11:00:00	AAPL	Stock	2.6986	2.6996	2.6786	2.6979	104958336.0
2006-01-31 12:00:00	AAPL	Stock	2.6964	2.7111	2.6825	2.6943	87205356.0
2006-01-31 13:00:00	AAPL	Stock	2.6943	2.7089	2.6896	2.7036	48884276.0
2006-01-31 14:00:00	AAPL	Stock	2.7029	2.7168	2.6807	2.7107	151300632.0
2006-01-31 15:00:00	AAPL	Stock	2.7107	2.7264	2.6846	2.6964	136847620.0
2006-01-31 16:00:00	AAPL	Stock	2.6907	2.6968	2.6539	2.6607	6507424.0
2006-01-31 17:00:00	AAPL	Stock	2.6604	2.6693	2.6554	2.6679	1566796.0
2006-01-31 18:00:00	AAPL	Stock	2.6732	2.6968	2.6611	2.6696	438116.0
2006-01-31 06:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	960.0
2006-01-31 07:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	2000.0
2006-01-31 08:00:00	MSFT	Stock	27.99	27.99	27.92	27.92	4114.0
2006-01-31 09:00:00	MSFT	Stock	27.96	28.01	27.88	27.95	8867847.0
2006-01-31 10:00:00	MSFT	Stock	27.96	28.0	27.87	27.98	11299306.0
2006-01-31 11:00:00	MSFT	Stock	27.98	28.06	27.96	28.02	9836504.0
2006-01-31 12:00:00	MSFT	Stock	28.02	28.03	27.96	28.0	5653466.0
2006-01-31 13:00:00	MSFT	Stock	28.0	28.09	27.95	28.058	12533430.0
2006-01-31 14:00:00	MSFT	Stock	28.052	28.2	27.98	28.19	15932131.0
2006-01-31 15:00:00	MSFT	Stock	28.2	28.38	28.08	28.15	25144380.0
2006-01-31 16:00:00	MSFT	Stock	28.13	28.18	27.88	27.92	1423813.0
2006-01-31 17:00:00	MSFT	Stock	27.92	27.99	27.89	27.96	36570.0
2006-01-31 18:00:00	MSFT	Stock	27.97	28.15	27.96	27.96	2795.0
2006-01-31 09:00:00	NVDA	Stock	0.3792	0.3812	0.3757	0.3764	43111920.0
2006-01-31 10:00:00	NVDA	Stock	0.3762	0.3792	0.3751	0.3777	43993560.0
2006-01-31 11:00:00	NVDA	Stock	0.3775	0.3776	0.3736	0.3738	44599680.0
2006-01-31 12:00:00	NVDA	Stock	0.374	0.3746	0.3733	0.3742	28059000.0
2006-01-31 13:00:00	NVDA	Stock	0.374	0.3755	0.374	0.3749	33984240.0
2006-01-31 14:00:00	NVDA	Stock	0.3749	0.376	0.3717	0.375	74162520.0
2006-01-31 15:00:00	NVDA	Stock	0.375	0.3774	0.3742	0.3743	83509320.0
2006-01-31 16:00:00	NVDA	Stock	0.3742	0.3749	0.3721	0.3721	1306320.0
2006-01-31 17:00:00	NVDA	Stock	0.3721	0.3732	0.3721	0.3721	264000.0
2006-01-31 18:00:00	NVDA	Stock	0.3721	0.3721	0.3721	0.3721	162000.0
2006-01-31 06:00:00	AMZN	Stock	2.245	2.245	2.245	2.245	4000.0
2006-01-31 09:00:00	AMZN	Stock	2.2425	2.2605	2.214	2.217	9970060.0
2006-01-31 10:00:00	AMZN	Stock	2.217	2.2375	2.2125	2.2285	11885140.0
2006-01-31 11:00:00	AMZN	Stock	2.227	2.243	2.225	2.2345	4865760.0
2006-01-31 12:00:00	AMZN	Stock	2.2355	2.242	2.234	2.2355	5790300.0
2006-01-31 13:00:00	AMZN	Stock	2.235	2.2495	2.232	2.2455	8420120.0
2006-01-31 14:00:00	AMZN	Stock	2.2455	2.2595	2.233	2.245	14185640.0
2006-01-31 15:00:00	AMZN	Stock	2.2451	2.2565	2.229	2.239	19416480.0
2006-01-31 16:00:00	AMZN	Stock	2.2335	2.2415	2.165	2.18	3172880.0
2006-01-31 17:00:00	AMZN	Stock	2.1865	2.193	2.1865	2.189	101000.0
2006-01-31 18:00:00	AMZN	Stock	2.19	2.196	2.19	2.19	41000.0
2006-01-31 09:00:00	CL	Stock	27.5	27.59	27.48	27.52	475400.0
2006-01-31 10:00:00	CL	Stock	27.52	27.53	27.3	27.375	1238600.0
2006-01-31 11:00:00	CL	Stock	27.375	27.425	27.25	27.265	595400.0

> showing 50 of 28,297 rows — these rows as CSV

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