PREVIEW / stock_1hour / 2006-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-28.parquet
  size:    595 KB
  rows:    28,002
  symbols: 2,222

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-03-28 06:00:00	AAPL	Stock	2.125	2.1357	2.1021	2.1357	104720.0
2006-03-28 07:00:00	AAPL	Stock	2.1411	2.1411	2.1268	2.1332	86800.0
2006-03-28 08:00:00	AAPL	Stock	2.1332	2.1386	2.1304	2.1354	2217488.0
2006-03-28 09:00:00	AAPL	Stock	2.1357	2.1479	2.1221	2.1325	160634964.0
2006-03-28 10:00:00	AAPL	Stock	2.1321	2.1375	2.1114	2.1282	291918060.0
2006-03-28 11:00:00	AAPL	Stock	2.1279	2.1314	2.115	2.1275	148809612.0
2006-03-28 12:00:00	AAPL	Stock	2.1279	2.1386	2.1164	2.1211	125670832.0
2006-03-28 13:00:00	AAPL	Stock	2.1211	2.1271	2.1089	2.1143	112744688.0
2006-03-28 14:00:00	AAPL	Stock	2.1143	2.1211	2.0914	2.0971	238510888.0
2006-03-28 15:00:00	AAPL	Stock	2.0971	2.1161	2.0804	2.095	273304892.0
2006-03-28 16:00:00	AAPL	Stock	2.0964	2.1	2.0954	2.0968	3903480.0
2006-03-28 17:00:00	AAPL	Stock	2.0968	2.1	2.0968	2.0989	461104.0
2006-03-28 18:00:00	AAPL	Stock	2.0986	2.0986	2.0971	2.0982	136444.0
2006-03-28 07:00:00	MSFT	Stock	27.01	27.01	27.01	27.01	1000.0
2006-03-28 08:00:00	MSFT	Stock	27.02	27.02	27.0	27.01	36470.0
2006-03-28 09:00:00	MSFT	Stock	27.02	27.12	26.96	27.02	4807270.0
2006-03-28 10:00:00	MSFT	Stock	27.02	27.06	26.96	27.03	5387844.0
2006-03-28 11:00:00	MSFT	Stock	27.03	27.06	26.95	27.06	5794755.0
2006-03-28 12:00:00	MSFT	Stock	27.06	27.21	27.03	27.16	6746611.0
2006-03-28 13:00:00	MSFT	Stock	27.16	27.19	27.14	27.17	3225486.0
2006-03-28 14:00:00	MSFT	Stock	27.16	27.2	26.93	26.961	9859515.0
2006-03-28 15:00:00	MSFT	Stock	26.961	26.97	26.81	26.93	21131055.0
2006-03-28 16:00:00	MSFT	Stock	26.92	26.94	26.87	26.91	66987.0
2006-03-28 17:00:00	MSFT	Stock	26.91	26.92	26.88	26.92	2478.0
2006-03-28 08:00:00	NVDA	Stock	0.4418	0.4434	0.4354	0.4434	432000.0
2006-03-28 09:00:00	NVDA	Stock	0.4433	0.4454	0.4417	0.4449	72728040.0
2006-03-28 10:00:00	NVDA	Stock	0.445	0.4527	0.4444	0.4519	162439920.0
2006-03-28 11:00:00	NVDA	Stock	0.4519	0.4527	0.4503	0.4513	63443880.0
2006-03-28 12:00:00	NVDA	Stock	0.4515	0.4562	0.4508	0.4558	94146720.0
2006-03-28 13:00:00	NVDA	Stock	0.4559	0.4573	0.455	0.4566	78559320.0
2006-03-28 14:00:00	NVDA	Stock	0.4566	0.4572	0.4505	0.4531	148828200.0
2006-03-28 15:00:00	NVDA	Stock	0.4532	0.4537	0.4487	0.4514	145553880.0
2006-03-28 16:00:00	NVDA	Stock	0.4512	0.4522	0.4509	0.4522	1281600.0
2006-03-28 17:00:00	NVDA	Stock	0.4518	0.4523	0.4511	0.4514	960000.0
2006-03-28 18:00:00	NVDA	Stock	0.4514	0.4542	0.4514	0.4542	578400.0
2006-03-28 09:00:00	AMZN	Stock	1.773	1.7775	1.76	1.7765	6541240.0
2006-03-28 10:00:00	AMZN	Stock	1.7765	1.7875	1.7675	1.7875	17379220.0
2006-03-28 11:00:00	AMZN	Stock	1.7875	1.7925	1.7845	1.79	9907920.0
2006-03-28 12:00:00	AMZN	Stock	1.7905	1.801	1.787	1.7875	19670420.0
2006-03-28 13:00:00	AMZN	Stock	1.7875	1.8	1.7865	1.794	9442980.0
2006-03-28 14:00:00	AMZN	Stock	1.794	1.7975	1.763	1.777	25357260.0
2006-03-28 15:00:00	AMZN	Stock	1.7765	1.787	1.7625	1.785	22678200.0
2006-03-28 16:00:00	AMZN	Stock	1.785	1.786	1.785	1.786	134420.0
2006-03-28 17:00:00	AMZN	Stock	1.786	1.786	1.786	1.786	20000.0
2006-03-28 09:00:00	CL	Stock	29.0	29.0	28.75	28.755	302600.0
2006-03-28 10:00:00	CL	Stock	28.755	28.8	28.655	28.73	538600.0
2006-03-28 11:00:00	CL	Stock	28.735	28.775	28.68	28.7	275800.0
2006-03-28 12:00:00	CL	Stock	28.7	28.775	28.68	28.755	292800.0
2006-03-28 13:00:00	CL	Stock	28.76	28.825	28.705	28.775	214400.0
2006-03-28 14:00:00	CL	Stock	28.775	28.835	28.615	28.695	679600.0

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

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