PREVIEW / stock_1hour / 2006-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-16.parquet
  size:    589 KB
  rows:    27,709
  symbols: 2,196

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-02-16 05:00:00	AAPL	Stock	2.4839	2.4839	2.4821	2.4821	8400.0
2006-02-16 07:00:00	AAPL	Stock	2.4786	2.4786	2.4732	2.475	81200.0
2006-02-16 08:00:00	AAPL	Stock	2.4804	2.495	2.475	2.4946	3231676.0
2006-02-16 09:00:00	AAPL	Stock	2.4946	2.5164	2.4854	2.4907	187110532.0
2006-02-16 10:00:00	AAPL	Stock	2.4911	2.5121	2.4814	2.5079	147416360.0
2006-02-16 11:00:00	AAPL	Stock	2.5079	2.5282	2.5046	2.5243	120629936.0
2006-02-16 12:00:00	AAPL	Stock	2.5246	2.5361	2.5186	2.5214	76281100.0
2006-02-16 13:00:00	AAPL	Stock	2.5211	2.53	2.5018	2.5043	118705132.0
2006-02-16 14:00:00	AAPL	Stock	2.5046	2.5107	2.4861	2.5104	134804292.0
2006-02-16 15:00:00	AAPL	Stock	2.5107	2.5243	2.5075	2.5193	144038020.0
2006-02-16 16:00:00	AAPL	Stock	2.5189	2.5257	2.5095	2.5232	3705464.0
2006-02-16 17:00:00	AAPL	Stock	2.5232	2.5232	2.5196	2.5214	451584.0
2006-02-16 18:00:00	AAPL	Stock	2.5221	2.5232	2.5204	2.5229	5764836.0
2006-02-16 08:00:00	MSFT	Stock	26.83	26.9	26.8	26.9	28940.0
2006-02-16 09:00:00	MSFT	Stock	26.9	26.9	26.75	26.77	6319229.0
2006-02-16 10:00:00	MSFT	Stock	26.76	26.8	26.71	26.76	7741833.0
2006-02-16 11:00:00	MSFT	Stock	26.75	26.82	26.71	26.72	5378790.0
2006-02-16 12:00:00	MSFT	Stock	26.72	26.74	26.67	26.68	5601344.0
2006-02-16 13:00:00	MSFT	Stock	26.68	26.71	26.59	26.63	4136053.0
2006-02-16 14:00:00	MSFT	Stock	26.63	26.67	26.57	26.65	5153911.0
2006-02-16 15:00:00	MSFT	Stock	26.64	26.81	26.62	26.8	11251892.0
2006-02-16 16:00:00	MSFT	Stock	26.82	26.84	26.726	26.79	344069.0
2006-02-16 17:00:00	MSFT	Stock	26.79	26.82	26.76	26.79	15340.0
2006-02-16 18:00:00	MSFT	Stock	26.8	26.82	26.78	26.78	644439.0
2006-02-16 08:00:00	NVDA	Stock	0.3773	0.3773	0.3752	0.3752	135000.0
2006-02-16 09:00:00	NVDA	Stock	0.3762	0.3856	0.3762	0.3824	103537440.0
2006-02-16 10:00:00	NVDA	Stock	0.3825	0.3881	0.3822	0.388	149718840.0
2006-02-16 11:00:00	NVDA	Stock	0.388	0.3922	0.388	0.3917	151752600.0
2006-02-16 12:00:00	NVDA	Stock	0.3917	0.3929	0.3883	0.3897	92792760.0
2006-02-16 13:00:00	NVDA	Stock	0.3897	0.3897	0.3857	0.3869	94041840.0
2006-02-16 14:00:00	NVDA	Stock	0.3869	0.394	0.3863	0.392	182606880.0
2006-02-16 15:00:00	NVDA	Stock	0.3921	0.3942	0.3908	0.3932	241183320.0
2006-02-16 16:00:00	NVDA	Stock	0.3933	0.4029	0.3804	0.3896	87975000.0
2006-02-16 17:00:00	NVDA	Stock	0.3896	0.4335	0.3887	0.4335	189212520.0
2006-02-16 18:00:00	NVDA	Stock	0.434	0.4392	0.3933	0.4374	32984880.0
2006-02-16 07:00:00	AMZN	Stock	1.9645	1.9645	1.9645	1.9645	7820.0
2006-02-16 08:00:00	AMZN	Stock	1.9725	1.989	1.965	1.9755	288940.0
2006-02-16 09:00:00	AMZN	Stock	1.975	2.0	1.962	1.966	26386780.0
2006-02-16 10:00:00	AMZN	Stock	1.9665	1.969	1.9415	1.9495	16847500.0
2006-02-16 11:00:00	AMZN	Stock	1.949	1.9855	1.947	1.98	14960260.0
2006-02-16 12:00:00	AMZN	Stock	1.98	1.984	1.967	1.9675	10866240.0
2006-02-16 13:00:00	AMZN	Stock	1.9675	1.9675	1.947	1.951	9437380.0
2006-02-16 14:00:00	AMZN	Stock	1.9505	1.9555	1.945	1.9525	14629040.0
2006-02-16 15:00:00	AMZN	Stock	1.9535	1.9595	1.951	1.9575	16068140.0
2006-02-16 16:00:00	AMZN	Stock	1.9565	1.9695	1.9515	1.9582	673240.0
2006-02-16 18:00:00	AMZN	Stock	1.9575	1.9575	1.9575	1.9575	948620.0
2006-02-16 08:00:00	CL	Stock	27.255	27.255	27.255	27.255	9400.0
2006-02-16 09:00:00	CL	Stock	27.25	27.335	27.23	27.23	366400.0
2006-02-16 10:00:00	CL	Stock	27.2195	27.34	27.175	27.27	319400.0
2006-02-16 11:00:00	CL	Stock	27.275	27.275	27.21	27.26	220600.0

> showing 50 of 27,709 rows — these rows as CSV

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