PREVIEW / stock_1hour / 2006-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-31.parquet
  size:    620 KB
  rows:    29,319
  symbols: 2,279

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-05-31 05:00:00	AAPL	Stock	2.1804	2.1804	2.1804	2.1804	28000.0
2006-05-31 07:00:00	AAPL	Stock	2.1839	2.1929	2.1839	2.1929	81200.0
2006-05-31 08:00:00	AAPL	Stock	2.1929	2.2061	2.1893	2.205	1933372.0
2006-05-31 09:00:00	AAPL	Stock	2.2043	2.2107	2.1596	2.1821	131664428.0
2006-05-31 10:00:00	AAPL	Stock	2.1819	2.1861	2.1554	2.165	146680688.0
2006-05-31 11:00:00	AAPL	Stock	2.1643	2.1714	2.1582	2.1661	76372324.0
2006-05-31 12:00:00	AAPL	Stock	2.1661	2.1679	2.145	2.1493	116286632.0
2006-05-31 13:00:00	AAPL	Stock	2.1493	2.1496	2.1286	2.1411	177364096.0
2006-05-31 14:00:00	AAPL	Stock	2.1411	2.1414	2.1093	2.1146	286307868.0
2006-05-31 15:00:00	AAPL	Stock	2.115	2.1714	2.0961	2.1271	301173376.0
2006-05-31 16:00:00	AAPL	Stock	2.1268	2.1857	2.1264	2.1357	3820572.0
2006-05-31 17:00:00	AAPL	Stock	2.1346	2.1386	2.1089	2.1386	7344848.0
2006-05-31 18:00:00	AAPL	Stock	2.1368	2.1386	2.1368	2.1368	239680.0
2006-05-31 05:00:00	MSFT	Stock	23.25	23.25	23.24	23.25	3000.0
2006-05-31 07:00:00	MSFT	Stock	23.26	23.26	23.26	23.26	1515.0
2006-05-31 08:00:00	MSFT	Stock	23.27	23.29	23.2	23.25	79632.0
2006-05-31 09:00:00	MSFT	Stock	23.24	23.35	23.21	23.269	10003471.0
2006-05-31 10:00:00	MSFT	Stock	23.27	23.28	23.07	23.13	11559105.0
2006-05-31 11:00:00	MSFT	Stock	23.13	23.2	23.11	23.15	8749764.0
2006-05-31 12:00:00	MSFT	Stock	23.159	23.3	23.11	23.14	4377822.0
2006-05-31 13:00:00	MSFT	Stock	23.14	23.14	23.01	23.04	8216723.0
2006-05-31 14:00:00	MSFT	Stock	23.04	23.13	22.8	22.84	20141965.0
2006-05-31 15:00:00	MSFT	Stock	22.84	22.88	22.69	22.7	31521604.0
2006-05-31 16:00:00	MSFT	Stock	22.7	22.75	22.65	22.75	2769117.0
2006-05-31 17:00:00	MSFT	Stock	22.75	22.75	22.65	22.7	592406.0
2006-05-31 18:00:00	MSFT	Stock	22.7	22.73	22.69	22.73	40720.0
2006-05-31 08:00:00	NVDA	Stock	0.3833	0.388	0.3833	0.3875	153000.0
2006-05-31 09:00:00	NVDA	Stock	0.3878	0.3888	0.3852	0.387	53630100.0
2006-05-31 10:00:00	NVDA	Stock	0.387	0.3882	0.3825	0.3862	90871320.0
2006-05-31 11:00:00	NVDA	Stock	0.3862	0.3917	0.3855	0.3907	49934340.0
2006-05-31 12:00:00	NVDA	Stock	0.3907	0.3907	0.3868	0.3882	43068000.0
2006-05-31 13:00:00	NVDA	Stock	0.3883	0.3883	0.385	0.3853	39629760.0
2006-05-31 14:00:00	NVDA	Stock	0.3852	0.3868	0.3807	0.3833	104716680.0
2006-05-31 15:00:00	NVDA	Stock	0.3833	0.3842	0.3808	0.3833	135735360.0
2006-05-31 16:00:00	NVDA	Stock	0.3833	0.3837	0.383	0.383	9896100.0
2006-05-31 17:00:00	NVDA	Stock	0.3833	0.3833	0.3833	0.3833	60000.0
2006-05-31 08:00:00	AMZN	Stock	1.74	1.74	1.74	1.74	4000.0
2006-05-31 09:00:00	AMZN	Stock	1.74	1.747	1.695	1.7005	15745620.0
2006-05-31 10:00:00	AMZN	Stock	1.7005	1.7235	1.687	1.723	18640500.0
2006-05-31 11:00:00	AMZN	Stock	1.723	1.735	1.7195	1.7205	9393200.0
2006-05-31 12:00:00	AMZN	Stock	1.7205	1.7205	1.709	1.711	5467240.0
2006-05-31 13:00:00	AMZN	Stock	1.711	1.7145	1.7085	1.7085	6935960.0
2006-05-31 14:00:00	AMZN	Stock	1.708	1.7175	1.6865	1.7145	18676420.0
2006-05-31 15:00:00	AMZN	Stock	1.715	1.7315	1.715	1.7265	21151740.0
2006-05-31 16:00:00	AMZN	Stock	1.7275	1.7325	1.7245	1.7325	418200.0
2006-05-31 18:00:00	AMZN	Stock	1.7335	1.7335	1.7335	1.7335	2000.0
2006-05-31 08:00:00	CL	Stock	30.115	30.115	30.115	30.115	2200.0
2006-05-31 09:00:00	CL	Stock	30.115	30.225	30.055	30.095	407400.0
2006-05-31 10:00:00	CL	Stock	30.095	30.145	30.01	30.095	538400.0
2006-05-31 11:00:00	CL	Stock	30.095	30.15	30.05	30.13	449000.0

> showing 50 of 29,319 rows — these rows as CSV

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