PREVIEW / stock_1hour / 2008-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-25.parquet
  size:    806 KB
  rows:    39,112
  symbols: 3,301

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-08-25 06:00:00	AAPL	Stock	6.3086	6.3086	6.3086	6.3086	2800.0
2008-08-25 07:00:00	AAPL	Stock	6.3036	6.3046	6.3032	6.3036	65800.0
2008-08-25 08:00:00	AAPL	Stock	6.3107	6.3125	6.2818	6.2857	1081584.0
2008-08-25 09:00:00	AAPL	Stock	6.2857	6.3	6.2429	6.2586	60817568.0
2008-08-25 10:00:00	AAPL	Stock	6.26	6.2786	6.205	6.2071	81514188.0
2008-08-25 11:00:00	AAPL	Stock	6.2061	6.2279	6.1914	6.1929	50621648.0
2008-08-25 12:00:00	AAPL	Stock	6.1918	6.1961	6.1664	6.1757	57439536.0
2008-08-25 13:00:00	AAPL	Stock	6.175	6.2107	6.1732	6.1814	48497624.0
2008-08-25 14:00:00	AAPL	Stock	6.1814	6.1939	6.1561	6.1607	55659044.0
2008-08-25 15:00:00	AAPL	Stock	6.1611	6.1746	6.1307	6.1696	102600148.0
2008-08-25 16:00:00	AAPL	Stock	6.1671	6.2013	6.1364	6.1643	19525408.0
2008-08-25 17:00:00	AAPL	Stock	6.1671	6.1679	6.1643	6.1671	335552.0
2008-08-25 18:00:00	AAPL	Stock	6.1646	6.1696	6.1625	6.1643	117208.0
2008-08-25 19:00:00	AAPL	Stock	6.1643	6.1675	6.1643	6.1661	65940.0
2008-08-25 07:00:00	MSFT	Stock	27.75	27.75	27.75	27.75	100.0
2008-08-25 08:00:00	MSFT	Stock	27.88	27.88	27.68	27.68	1787.0
2008-08-25 09:00:00	MSFT	Stock	27.68	27.75	27.55	27.7	5247629.0
2008-08-25 10:00:00	MSFT	Stock	27.7	27.84	27.66	27.72	6918316.0
2008-08-25 11:00:00	MSFT	Stock	27.71	27.72	27.62	27.65	5033128.0
2008-08-25 12:00:00	MSFT	Stock	27.65	27.66	27.55	27.55	7304537.0
2008-08-25 13:00:00	MSFT	Stock	27.55	27.63	27.51	27.55	5097483.0
2008-08-25 14:00:00	MSFT	Stock	27.55	27.61	27.46	27.51	5876049.0
2008-08-25 15:00:00	MSFT	Stock	27.5	27.69	27.47	27.67	11890962.0
2008-08-25 16:00:00	MSFT	Stock	27.67	27.72	27.474	27.66	3506353.0
2008-08-25 17:00:00	MSFT	Stock	27.62	27.75	27.62	27.75	8688.0
2008-08-25 19:00:00	MSFT	Stock	27.73	27.73	27.73	27.73	500.0
2008-08-25 08:00:00	NVDA	Stock	0.3395	0.34	0.3362	0.34	76600.0
2008-08-25 09:00:00	NVDA	Stock	0.3395	0.345	0.336	0.3438	65487280.0
2008-08-25 10:00:00	NVDA	Stock	0.344	0.3462	0.3413	0.3419	99009160.0
2008-08-25 11:00:00	NVDA	Stock	0.342	0.342	0.3375	0.338	54819160.0
2008-08-25 12:00:00	NVDA	Stock	0.338	0.3402	0.336	0.3373	52842640.0
2008-08-25 13:00:00	NVDA	Stock	0.3373	0.3388	0.3365	0.3368	43060480.0
2008-08-25 14:00:00	NVDA	Stock	0.337	0.3373	0.335	0.3356	42291120.0
2008-08-25 15:00:00	NVDA	Stock	0.3356	0.3362	0.3342	0.3355	76859800.0
2008-08-25 16:00:00	NVDA	Stock	0.3355	0.3419	0.3345	0.3353	36694280.0
2008-08-25 17:00:00	NVDA	Stock	0.3345	0.3345	0.3345	0.3345	84000.0
2008-08-25 18:00:00	NVDA	Stock	0.3345	0.3345	0.3345	0.3345	20800.0
2008-08-25 19:00:00	NVDA	Stock	0.3348	0.336	0.3348	0.336	26000.0
2008-08-25 08:00:00	AMZN	Stock	4.2595	4.2595	4.2255	4.2275	43000.0
2008-08-25 09:00:00	AMZN	Stock	4.2275	4.2345	4.1705	4.1995	10552460.0
2008-08-25 10:00:00	AMZN	Stock	4.1985	4.215	4.161	4.1705	11623000.0
2008-08-25 11:00:00	AMZN	Stock	4.172	4.177	4.148	4.15	10065180.0
2008-08-25 12:00:00	AMZN	Stock	4.15	4.153	4.128	4.143	10799900.0
2008-08-25 13:00:00	AMZN	Stock	4.143	4.185	4.1405	4.169	12054480.0
2008-08-25 14:00:00	AMZN	Stock	4.1685	4.1735	4.1295	4.1335	10405500.0
2008-08-25 15:00:00	AMZN	Stock	4.134	4.154	4.1225	4.1465	15501780.0
2008-08-25 16:00:00	AMZN	Stock	4.148	4.1626	4.1332	4.1425	4920160.0
2008-08-25 17:00:00	AMZN	Stock	4.14	4.14	4.14	4.14	9000.0
2008-08-25 19:00:00	AMZN	Stock	4.1385	4.144	4.138	4.144	14000.0
2008-08-25 08:00:00	TLT	Stock	93.55	94.4	93.55	94.2	21665.0

> showing 50 of 39,112 rows — these rows as CSV

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