PREVIEW / stock_1hour / 2008-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-24.parquet
  size:    792 KB
  rows:    40,649
  symbols: 3,322

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
2008-10-24 04:00:00	AAPL	Stock	3.3964	3.3964	3.2679	3.2679	38640.0
2008-10-24 05:00:00	AAPL	Stock	3.2521	3.2521	3.2321	3.2321	9240.0
2008-10-24 06:00:00	AAPL	Stock	3.2146	3.2146	3.2146	3.2146	3164.0
2008-10-24 07:00:00	AAPL	Stock	3.2143	3.2857	3.2111	3.25	696388.0
2008-10-24 08:00:00	AAPL	Stock	3.2507	3.3214	3.1789	3.23	8102500.0
2008-10-24 09:00:00	AAPL	Stock	3.2304	3.4286	3.2007	3.3943	236476548.0
2008-10-24 10:00:00	AAPL	Stock	3.3943	3.4275	3.3393	3.3818	250044704.0
2008-10-24 11:00:00	AAPL	Stock	3.3814	3.4768	3.3625	3.4343	189834652.0
2008-10-24 12:00:00	AAPL	Stock	3.4343	3.4629	3.3661	3.3764	141676892.0
2008-10-24 13:00:00	AAPL	Stock	3.3761	3.4071	3.3125	3.3143	142495556.0
2008-10-24 14:00:00	AAPL	Stock	3.3132	3.4475	3.3036	3.435	215922308.0
2008-10-24 15:00:00	AAPL	Stock	3.435	3.4964	3.3757	3.4418	329600852.0
2008-10-24 16:00:00	AAPL	Stock	3.4414	3.4586	3.386	3.42	54043780.0
2008-10-24 17:00:00	AAPL	Stock	3.42	3.4229	3.2929	3.4214	381668.0
2008-10-24 18:00:00	AAPL	Stock	3.425	3.425	3.4182	3.4214	98588.0
2008-10-24 19:00:00	AAPL	Stock	3.4239	3.4339	3.4232	3.4286	410648.0
2008-10-24 04:00:00	MSFT	Stock	22.01	22.01	21.31	21.31	2600.0
2008-10-24 06:00:00	MSFT	Stock	21.0	21.0	20.75	20.75	7680.0
2008-10-24 07:00:00	MSFT	Stock	21.0	21.17	20.75	20.9	153300.0
2008-10-24 08:00:00	MSFT	Stock	20.9	21.39	20.7	20.71	883115.0
2008-10-24 09:00:00	MSFT	Stock	20.71	21.76	20.7	21.542	20663167.0
2008-10-24 10:00:00	MSFT	Stock	21.55	22.26	21.33	22.22	26483604.0
2008-10-24 11:00:00	MSFT	Stock	22.23	22.86	22.03	22.51	24647183.0
2008-10-24 12:00:00	MSFT	Stock	22.5	22.64	22.02	22.088	12928215.0
2008-10-24 13:00:00	MSFT	Stock	22.09	22.44	21.73	21.74	13214083.0
2008-10-24 14:00:00	MSFT	Stock	21.74	22.36	21.67	22.29	17059612.0
2008-10-24 15:00:00	MSFT	Stock	22.28	22.71	21.89	21.92	29414584.0
2008-10-24 16:00:00	MSFT	Stock	21.88	22.365	21.6	21.89	6848273.0
2008-10-24 17:00:00	MSFT	Stock	21.89	21.9	21.0	21.9	41275.0
2008-10-24 18:00:00	MSFT	Stock	21.9	21.9	21.84	21.89	8204.0
2008-10-24 19:00:00	MSFT	Stock	21.9	22.0	21.83	21.97	7255.0
2008-10-24 04:00:00	NVDA	Stock	0.1652	0.1652	0.1652	0.1652	32000.0
2008-10-24 07:00:00	NVDA	Stock	0.1538	0.1582	0.139	0.1582	281400.0
2008-10-24 08:00:00	NVDA	Stock	0.1525	0.156	0.1433	0.1433	2162160.0
2008-10-24 09:00:00	NVDA	Stock	0.143	0.1662	0.14	0.1633	115262160.0
2008-10-24 10:00:00	NVDA	Stock	0.1635	0.1672	0.1592	0.164	103992720.0
2008-10-24 11:00:00	NVDA	Stock	0.164	0.1713	0.163	0.1688	87068640.0
2008-10-24 12:00:00	NVDA	Stock	0.1685	0.171	0.1646	0.1655	67377680.0
2008-10-24 13:00:00	NVDA	Stock	0.1652	0.1678	0.162	0.163	93499520.0
2008-10-24 14:00:00	NVDA	Stock	0.1628	0.171	0.162	0.1705	102303960.0
2008-10-24 15:00:00	NVDA	Stock	0.1703	0.1738	0.1648	0.1652	186974720.0
2008-10-24 16:00:00	NVDA	Stock	0.1652	0.169	0.1615	0.168	32187600.0
2008-10-24 17:00:00	NVDA	Stock	0.168	0.168	0.1662	0.1665	46000.0
2008-10-24 18:00:00	NVDA	Stock	0.1682	0.1682	0.1665	0.1665	16000.0
2008-10-24 19:00:00	NVDA	Stock	0.1685	0.1685	0.1685	0.1685	4000.0
2008-10-24 06:00:00	AMZN	Stock	2.313	2.313	2.313	2.313	4000.0
2008-10-24 07:00:00	AMZN	Stock	2.3525	2.363	2.255	2.318	160000.0
2008-10-24 08:00:00	AMZN	Stock	2.318	2.35	2.275	2.295	1291660.0
2008-10-24 09:00:00	AMZN	Stock	2.2805	2.468	2.225	2.461	56666340.0
2008-10-24 10:00:00	AMZN	Stock	2.4605	2.4845	2.344	2.4155	52327120.0

> showing 50 of 40,649 rows — these rows as CSV

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