PREVIEW / stock_1hour / 2007-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-05.parquet
  size:    763 KB
  rows:    37,306
  symbols: 3,001

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-06-05 09:00:00	AAPL	Stock	4.3361	4.3679	4.3036	4.3475	172325748.0
2007-06-05 10:00:00	AAPL	Stock	4.3471	4.3732	4.3339	4.3636	175499100.0
2007-06-05 11:00:00	AAPL	Stock	4.3639	4.3814	4.3514	4.3618	136106544.0
2007-06-05 12:00:00	AAPL	Stock	4.3614	4.375	4.3482	4.3714	119003444.0
2007-06-05 13:00:00	AAPL	Stock	4.3718	4.38	4.3636	4.3693	76464248.0
2007-06-05 14:00:00	AAPL	Stock	4.3693	4.3789	4.3607	4.3624	72897580.0
2007-06-05 15:00:00	AAPL	Stock	4.3622	4.4411	4.35	4.3814	129859240.0
2007-06-05 16:00:00	AAPL	Stock	4.3814	4.3818	4.3804	4.3811	5985896.0
2007-06-05 09:00:00	MSFT	Stock	30.62	30.63	30.4	30.44	5443682.0
2007-06-05 10:00:00	MSFT	Stock	30.44	30.55	30.33	30.51	6624091.0
2007-06-05 11:00:00	MSFT	Stock	30.51	30.52	30.38	30.42	5766084.0
2007-06-05 12:00:00	MSFT	Stock	30.41	30.51	30.33	30.47	4546231.0
2007-06-05 13:00:00	MSFT	Stock	30.47	30.54	30.43	30.45	3132498.0
2007-06-05 14:00:00	MSFT	Stock	30.45	30.5	30.39	30.47	3442477.0
2007-06-05 15:00:00	MSFT	Stock	30.48	30.61	30.47	30.58	6550387.0
2007-06-05 16:00:00	MSFT	Stock	30.59	30.59	30.58	30.58	1162812.0
2007-06-05 08:00:00	NVDA	Stock	0.5845	0.5845	0.5845	0.5845	6000.0
2007-06-05 09:00:00	NVDA	Stock	0.5875	0.5952	0.5852	0.5925	67565760.0
2007-06-05 10:00:00	NVDA	Stock	0.5927	0.5987	0.5893	0.597	119535960.0
2007-06-05 11:00:00	NVDA	Stock	0.597	0.5972	0.5897	0.5902	65608800.0
2007-06-05 12:00:00	NVDA	Stock	0.5902	0.5932	0.5892	0.5925	79092480.0
2007-06-05 13:00:00	NVDA	Stock	0.5923	0.5965	0.5922	0.5957	63762120.0
2007-06-05 14:00:00	NVDA	Stock	0.5957	0.599	0.5947	0.5977	90198480.0
2007-06-05 15:00:00	NVDA	Stock	0.5977	0.6028	0.5973	0.6027	155328420.0
2007-06-05 16:00:00	NVDA	Stock	0.6018	0.6042	0.5954	0.6033	11110800.0
2007-06-05 17:00:00	NVDA	Stock	0.6033	0.6033	0.6018	0.6018	5246760.0
2007-06-05 19:00:00	NVDA	Stock	0.6033	0.6033	0.6018	0.602	102000.0
2007-06-05 07:00:00	AMZN	Stock	3.525	3.554	3.525	3.5445	64000.0
2007-06-05 08:00:00	AMZN	Stock	3.5395	3.555	3.521	3.5365	1136320.0
2007-06-05 09:00:00	AMZN	Stock	3.5375	3.633	3.5375	3.626	82688800.0
2007-06-05 10:00:00	AMZN	Stock	3.6275	3.6965	3.606	3.6414	155329060.0
2007-06-05 11:00:00	AMZN	Stock	3.642	3.6885	3.619	3.6585	77462440.0
2007-06-05 12:00:00	AMZN	Stock	3.6585	3.682	3.6375	3.6755	63106040.0
2007-06-05 13:00:00	AMZN	Stock	3.6755	3.712	3.6715	3.694	67628400.0
2007-06-05 14:00:00	AMZN	Stock	3.6945	3.6975	3.667	3.6805	57007260.0
2007-06-05 15:00:00	AMZN	Stock	3.68	3.7	3.6715	3.684	96744720.0
2007-06-05 16:00:00	AMZN	Stock	3.685	3.687	3.6574	3.6855	5238740.0
2007-06-05 17:00:00	AMZN	Stock	3.6855	3.688	3.6825	3.688	1686500.0
2007-06-05 18:00:00	AMZN	Stock	3.686	3.6865	3.6755	3.6825	170600.0
2007-06-05 19:00:00	AMZN	Stock	3.6825	3.685	3.6825	3.6825	106260.0
2007-06-05 09:00:00	TLT	Stock	85.89	85.94	85.8	85.8	54400.0
2007-06-05 10:00:00	TLT	Stock	85.8	85.82	85.53	85.6	431300.0
2007-06-05 11:00:00	TLT	Stock	85.59	85.63	85.46	85.55	83100.0
2007-06-05 12:00:00	TLT	Stock	85.54	85.62	85.54	85.54	82700.0
2007-06-05 13:00:00	TLT	Stock	85.54	85.62	85.54	85.6	63000.0
2007-06-05 14:00:00	TLT	Stock	85.61	85.62	85.53	85.58	122400.0
2007-06-05 15:00:00	TLT	Stock	85.55	85.56	85.38	85.42	253500.0
2007-06-05 16:00:00	TLT	Stock	85.42	85.44	85.42	85.44	4100.0
2007-06-05 08:00:00	CL	Stock	33.65	33.65	33.635	33.635	800.0
2007-06-05 09:00:00	CL	Stock	33.75	33.75	33.55	33.71	390200.0

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

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