PREVIEW / stock_1hour / 2007-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-27.parquet
  size:    806 KB
  rows:    39,497
  symbols: 3,081

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
2007-07-27 09:00:00	AAPL	Stock	5.2211	5.2857	5.2096	5.2793	189465584.0
2007-07-27 10:00:00	AAPL	Stock	5.279	5.3186	5.2389	5.2632	250054896.0
2007-07-27 11:00:00	AAPL	Stock	5.2625	5.2875	5.2143	5.2364	132613068.0
2007-07-27 12:00:00	AAPL	Stock	5.2336	5.2461	5.1371	5.1825	173684084.0
2007-07-27 13:00:00	AAPL	Stock	5.1822	5.2093	5.1714	5.1921	87035816.0
2007-07-27 14:00:00	AAPL	Stock	5.1925	5.2254	5.1757	5.2221	105419048.0
2007-07-27 15:00:00	AAPL	Stock	5.2225	5.2314	5.135	5.1361	175993748.0
2007-07-27 16:00:00	AAPL	Stock	5.1361	5.1457	5.1357	5.1375	5747896.0
2007-07-27 09:00:00	MSFT	Stock	29.93	30.0	29.58	29.7	6241716.0
2007-07-27 10:00:00	MSFT	Stock	29.7	29.88	29.56	29.69	11023323.0
2007-07-27 11:00:00	MSFT	Stock	29.69	29.81	29.56	29.65	7068025.0
2007-07-27 12:00:00	MSFT	Stock	29.65	29.81	29.49	29.53	8615263.0
2007-07-27 13:00:00	MSFT	Stock	29.54	29.77	29.52	29.67	6618017.0
2007-07-27 14:00:00	MSFT	Stock	29.67	29.8	29.55	29.68	6765418.0
2007-07-27 15:00:00	MSFT	Stock	29.68	29.74	29.36	29.37	14540453.0
2007-07-27 16:00:00	MSFT	Stock	29.37	29.46	29.37	29.39	1242940.0
2007-07-27 08:00:00	NVDA	Stock	0.735	0.7382	0.7283	0.736	348600.0
2007-07-27 09:00:00	NVDA	Stock	0.7357	0.7603	0.7357	0.7582	75483420.0
2007-07-27 10:00:00	NVDA	Stock	0.7587	0.7715	0.7553	0.7583	120754560.0
2007-07-27 11:00:00	NVDA	Stock	0.7583	0.7645	0.754	0.755	85160040.0
2007-07-27 12:00:00	NVDA	Stock	0.755	0.756	0.7465	0.7468	75777480.0
2007-07-27 13:00:00	NVDA	Stock	0.7468	0.7633	0.7463	0.757	65703360.0
2007-07-27 14:00:00	NVDA	Stock	0.7572	0.76	0.7495	0.7555	62203260.0
2007-07-27 15:00:00	NVDA	Stock	0.7557	0.756	0.7372	0.7372	114167520.0
2007-07-27 16:00:00	NVDA	Stock	0.7372	0.7383	0.73	0.7348	2086440.0
2007-07-27 17:00:00	NVDA	Stock	0.7358	0.7358	0.7358	0.7358	12000.0
2007-07-27 18:00:00	NVDA	Stock	0.7358	0.7358	0.7358	0.7358	6000.0
2007-07-27 19:00:00	NVDA	Stock	0.7577	0.7587	0.7325	0.7325	336780.0
2007-07-27 07:00:00	AMZN	Stock	4.17	4.17	4.15	4.15	8000.0
2007-07-27 08:00:00	AMZN	Stock	4.1375	4.1995	4.125	4.1875	411440.0
2007-07-27 09:00:00	AMZN	Stock	4.1995	4.2465	4.1395	4.175	44598100.0
2007-07-27 10:00:00	AMZN	Stock	4.176	4.2665	4.1555	4.1745	66031260.0
2007-07-27 11:00:00	AMZN	Stock	4.174	4.212	4.135	4.1355	36879200.0
2007-07-27 12:00:00	AMZN	Stock	4.1352	4.176	4.124	4.1598	28960700.0
2007-07-27 13:00:00	AMZN	Stock	4.1605	4.205	4.1585	4.202	20841460.0
2007-07-27 14:00:00	AMZN	Stock	4.203	4.242	4.183	4.225	29005640.0
2007-07-27 15:00:00	AMZN	Stock	4.2245	4.2295	4.1947	4.204	40904660.0
2007-07-27 16:00:00	AMZN	Stock	4.2015	4.202	4.195	4.202	488040.0
2007-07-27 17:00:00	AMZN	Stock	4.2	4.202	4.2	4.202	2610020.0
2007-07-27 18:00:00	AMZN	Stock	4.203	4.203	4.203	4.203	2740.0
2007-07-27 19:00:00	AMZN	Stock	4.205	4.232	4.1857	4.22	58000.0
2007-07-27 09:00:00	TLT	Stock	87.05	87.34	86.96	87.12	1776200.0
2007-07-27 10:00:00	TLT	Stock	87.12	87.32	86.85	87.31	716800.0
2007-07-27 11:00:00	TLT	Stock	87.3	87.46	87.17	87.41	381000.0
2007-07-27 12:00:00	TLT	Stock	87.42	87.56	87.32	87.41	817200.0
2007-07-27 13:00:00	TLT	Stock	87.41	87.55	87.2	87.25	655200.0
2007-07-27 14:00:00	TLT	Stock	87.24	87.38	87.16	87.21	298040.0
2007-07-27 15:00:00	TLT	Stock	87.24	87.34	87.13	87.3	462995.0
2007-07-27 16:00:00	TLT	Stock	87.3	87.37	87.28	87.28	17700.0
2007-07-27 09:00:00	CL	Stock	34.395	34.465	34.11	34.26	954910.0

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

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