PREVIEW / stock_1hour / 2007-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-22.parquet
  size:    798 KB
  rows:    39,407
  symbols: 3,157

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-10-22 04:00:00	AAPL	Stock	6.0729	6.0729	6.0379	6.0446	86800.0
2007-10-22 05:00:00	AAPL	Stock	6.0714	6.0714	6.0589	6.0589	84000.0
2007-10-22 06:00:00	AAPL	Stock	6.0586	6.0589	6.05	6.05	74956.0
2007-10-22 07:00:00	AAPL	Stock	6.0446	6.0446	6.0214	6.0357	411348.0
2007-10-22 08:00:00	AAPL	Stock	6.0411	6.1411	6.0357	6.1082	12988948.0
2007-10-22 09:00:00	AAPL	Stock	6.1096	6.1996	6.0704	6.1854	186884376.0
2007-10-22 10:00:00	AAPL	Stock	6.185	6.2464	6.1621	6.1771	232498168.0
2007-10-22 11:00:00	AAPL	Stock	6.1786	6.2143	6.1482	6.1875	155370824.0
2007-10-22 12:00:00	AAPL	Stock	6.1874	6.2143	6.1725	6.2007	102956224.0
2007-10-22 13:00:00	AAPL	Stock	6.2007	6.2129	6.1757	6.1821	119299992.0
2007-10-22 14:00:00	AAPL	Stock	6.1821	6.2125	6.1818	6.195	124872244.0
2007-10-22 15:00:00	AAPL	Stock	6.1946	6.2411	6.1714	6.2289	277045356.0
2007-10-22 16:00:00	AAPL	Stock	6.2271	6.6064	6.1648	6.5821	278230092.0
2007-10-22 17:00:00	AAPL	Stock	6.5825	6.7143	6.1954	6.6804	130289404.0
2007-10-22 18:00:00	AAPL	Stock	6.6818	6.6968	6.1839	6.6632	24041052.0
2007-10-22 19:00:00	AAPL	Stock	6.6643	6.6643	6.6364	6.6554	6683768.0
2007-10-22 04:00:00	MSFT	Stock	30.1	30.1	30.1	30.1	800.0
2007-10-22 07:00:00	MSFT	Stock	30.06	30.06	29.96	30.0	1900.0
2007-10-22 08:00:00	MSFT	Stock	29.91	30.23	29.91	30.23	68507.0
2007-10-22 09:00:00	MSFT	Stock	30.23	30.65	30.05	30.57	8157423.0
2007-10-22 10:00:00	MSFT	Stock	30.56	30.64	30.42	30.57	8696263.0
2007-10-22 11:00:00	MSFT	Stock	30.57	30.6	30.4	30.59	6213595.0
2007-10-22 12:00:00	MSFT	Stock	30.595	30.67	30.51	30.668	5707120.0
2007-10-22 13:00:00	MSFT	Stock	30.66	30.7	30.532	30.56	5353075.0
2007-10-22 14:00:00	MSFT	Stock	30.56	30.6	30.41	30.42	6382398.0
2007-10-22 15:00:00	MSFT	Stock	30.41	30.54	30.35	30.49	12465534.0
2007-10-22 16:00:00	MSFT	Stock	30.5	30.68	30.17	30.67	5620226.0
2007-10-22 17:00:00	MSFT	Stock	30.67	30.7	30.64	30.66	171941.0
2007-10-22 18:00:00	MSFT	Stock	30.68	30.71	30.298	30.7	131163.0
2007-10-22 19:00:00	MSFT	Stock	30.71	30.71	30.69	30.7	7900.0
2007-10-22 08:00:00	NVDA	Stock	0.9195	0.9258	0.9195	0.9203	89120.0
2007-10-22 09:00:00	NVDA	Stock	0.9203	0.955	0.9203	0.95	68380640.0
2007-10-22 10:00:00	NVDA	Stock	0.95	0.9685	0.944	0.949	100085840.0
2007-10-22 11:00:00	NVDA	Stock	0.9489	0.9745	0.9445	0.9742	61211800.0
2007-10-22 12:00:00	NVDA	Stock	0.9745	0.9792	0.9665	0.9742	47858560.0
2007-10-22 13:00:00	NVDA	Stock	0.9748	0.9773	0.969	0.9695	105997480.0
2007-10-22 14:00:00	NVDA	Stock	0.9695	0.9762	0.9695	0.974	35507040.0
2007-10-22 15:00:00	NVDA	Stock	0.9735	0.981	0.9665	0.9782	86285680.0
2007-10-22 16:00:00	NVDA	Stock	0.9782	0.9842	0.9562	0.982	31527000.0
2007-10-22 17:00:00	NVDA	Stock	0.9815	0.99	0.9455	0.9875	888840.0
2007-10-22 18:00:00	NVDA	Stock	0.9872	0.9872	0.9722	0.9862	455960.0
2007-10-22 19:00:00	NVDA	Stock	0.9862	0.9862	0.979	0.9838	56000.0
2007-10-22 06:00:00	AMZN	Stock	4.45	4.45	4.45	4.45	2000.0
2007-10-22 07:00:00	AMZN	Stock	4.4825	4.4825	4.425	4.425	42000.0
2007-10-22 08:00:00	AMZN	Stock	4.469	4.4875	4.4505	4.4675	819920.0
2007-10-22 09:00:00	AMZN	Stock	4.466	4.5395	4.4515	4.515	30731820.0
2007-10-22 10:00:00	AMZN	Stock	4.516	4.5845	4.515	4.535	35950520.0
2007-10-22 11:00:00	AMZN	Stock	4.5345	4.5655	4.5215	4.5441	25586900.0
2007-10-22 12:00:00	AMZN	Stock	4.5435	4.5626	4.5315	4.553	17420800.0
2007-10-22 13:00:00	AMZN	Stock	4.5525	4.56	4.5475	4.5505	14851260.0

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

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