PREVIEW / stock_1hour / 2007-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-10.parquet
  size:    754 KB
  rows:    37,493
  symbols: 3,124

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-09-10 09:00:00	AAPL	Stock	4.8927	4.8932	4.8111	4.8118	224180880.0
2007-09-10 10:00:00	AAPL	Stock	4.8118	4.8339	4.7839	4.82	246235808.0
2007-09-10 11:00:00	AAPL	Stock	4.8207	4.8314	4.7911	4.8261	159641160.0
2007-09-10 12:00:00	AAPL	Stock	4.8257	4.8536	4.7957	4.8175	120457316.0
2007-09-10 13:00:00	AAPL	Stock	4.8168	4.8457	4.806	4.8289	103114228.0
2007-09-10 14:00:00	AAPL	Stock	4.8286	4.8996	4.8254	4.8986	175275884.0
2007-09-10 15:00:00	AAPL	Stock	4.8989	4.93	4.8793	4.8832	253315020.0
2007-09-10 16:00:00	AAPL	Stock	4.8832	4.8832	4.8825	4.8825	7933380.0
2007-09-10 09:00:00	MSFT	Stock	28.66	28.745	28.58	28.669	2401661.0
2007-09-10 10:00:00	MSFT	Stock	28.66	28.68	28.5	28.6	5591696.0
2007-09-10 11:00:00	MSFT	Stock	28.6	28.64	28.41	28.49	3713522.0
2007-09-10 12:00:00	MSFT	Stock	28.492	28.56	28.44	28.47	2453889.0
2007-09-10 13:00:00	MSFT	Stock	28.48	28.64	28.46	28.54	2079563.0
2007-09-10 14:00:00	MSFT	Stock	28.54	28.66	28.5	28.63	4147003.0
2007-09-10 15:00:00	MSFT	Stock	28.63	28.75	28.47	28.49	7381007.0
2007-09-10 16:00:00	MSFT	Stock	28.48	28.48	28.48	28.48	2333185.0
2007-09-10 08:00:00	NVDA	Stock	0.8613	0.8613	0.8613	0.8613	24000.0
2007-09-10 09:00:00	NVDA	Stock	0.8548	0.8775	0.8548	0.8587	90603360.0
2007-09-10 10:00:00	NVDA	Stock	0.8587	0.8612	0.8395	0.8445	100338780.0
2007-09-10 11:00:00	NVDA	Stock	0.8445	0.851	0.8413	0.8465	68405040.0
2007-09-10 12:00:00	NVDA	Stock	0.8463	0.8485	0.8413	0.8447	40314840.0
2007-09-10 13:00:00	NVDA	Stock	0.8447	0.8533	0.8425	0.845	65458140.0
2007-09-10 14:00:00	NVDA	Stock	0.8447	0.8485	0.8425	0.8455	63641640.0
2007-09-10 15:00:00	NVDA	Stock	0.8452	0.8528	0.8432	0.8465	97811220.0
2007-09-10 16:00:00	NVDA	Stock	0.846	0.8492	0.8435	0.8483	459600.0
2007-09-10 17:00:00	NVDA	Stock	0.8482	0.8483	0.8482	0.8483	60000.0
2007-09-10 18:00:00	NVDA	Stock	0.8483	0.8493	0.8483	0.8493	15000.0
2007-09-10 08:00:00	AMZN	Stock	4.2225	4.2485	4.215	4.2425	228800.0
2007-09-10 09:00:00	AMZN	Stock	4.245	4.2625	4.2005	4.2035	12352360.0
2007-09-10 10:00:00	AMZN	Stock	4.2038	4.2038	4.1255	4.15	24363480.0
2007-09-10 11:00:00	AMZN	Stock	4.1505	4.173	4.1295	4.1675	12160720.0
2007-09-10 12:00:00	AMZN	Stock	4.167	4.1695	4.145	4.159	8503620.0
2007-09-10 13:00:00	AMZN	Stock	4.1585	4.1865	4.151	4.1544	11013820.0
2007-09-10 14:00:00	AMZN	Stock	4.1545	4.1889	4.1505	4.175	11546660.0
2007-09-10 15:00:00	AMZN	Stock	4.175	4.1995	4.1635	4.168	20380780.0
2007-09-10 16:00:00	AMZN	Stock	4.168	4.1925	4.167	4.1705	2781220.0
2007-09-10 17:00:00	AMZN	Stock	4.1705	4.1845	4.1705	4.171	16000.0
2007-09-10 18:00:00	AMZN	Stock	4.1715	4.176	4.171	4.176	13600.0
2007-09-10 09:00:00	TLT	Stock	90.5	90.64	90.5	90.63	158400.0
2007-09-10 10:00:00	TLT	Stock	90.63	91.16	90.63	91.15	506400.0
2007-09-10 11:00:00	TLT	Stock	91.13	91.27	91.03	91.09	200850.0
2007-09-10 12:00:00	TLT	Stock	91.07	91.17	91.05	91.12	102600.0
2007-09-10 13:00:00	TLT	Stock	91.1	91.2	90.98	91.16	396500.0
2007-09-10 14:00:00	TLT	Stock	91.16	91.18	90.9	90.96	307500.0
2007-09-10 15:00:00	TLT	Stock	90.97	91.03	90.83	90.97	728100.0
2007-09-10 16:00:00	TLT	Stock	90.97	91.0	90.97	91.0	5600.0
2007-09-10 09:00:00	CL	Stock	32.655	33.0	32.65	32.97	476000.0
2007-09-10 10:00:00	CL	Stock	32.97	33.275	32.97	33.04	863800.0
2007-09-10 11:00:00	CL	Stock	33.05	33.34	32.93	32.965	1018200.0
2007-09-10 12:00:00	CL	Stock	32.96	33.135	32.925	33.115	767400.0

> showing 50 of 37,493 rows — these rows as CSV

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