PREVIEW / stock_1hour / 2007-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-21.parquet
  size:    762 KB
  rows:    37,528
  symbols: 3,051

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-21 09:00:00	AAPL	Stock	4.3464	4.3689	4.3114	4.3329	122769808.0
2007-06-21 10:00:00	AAPL	Stock	4.3324	4.4325	4.3324	4.4257	221449648.0
2007-06-21 11:00:00	AAPL	Stock	4.4247	4.4389	4.3886	4.4039	145719420.0
2007-06-21 12:00:00	AAPL	Stock	4.4039	4.4182	4.3961	4.4046	82074524.0
2007-06-21 13:00:00	AAPL	Stock	4.4054	4.4264	4.4036	4.4238	73275916.0
2007-06-21 14:00:00	AAPL	Stock	4.4232	4.4254	4.3968	4.4107	71740172.0
2007-06-21 15:00:00	AAPL	Stock	4.4111	4.4375	4.4107	4.425	125331976.0
2007-06-21 16:00:00	AAPL	Stock	4.425	4.4286	4.425	4.425	3860304.0
2007-06-21 09:00:00	MSFT	Stock	29.975	30.05	29.94	29.97	6541494.0
2007-06-21 10:00:00	MSFT	Stock	29.97	30.14	29.91	30.04	10656684.0
2007-06-21 11:00:00	MSFT	Stock	30.05	30.06	29.91	29.96	4414796.0
2007-06-21 12:00:00	MSFT	Stock	29.95	30.14	29.95	30.07	5659301.0
2007-06-21 13:00:00	MSFT	Stock	30.06	30.24	30.04	30.23	7523640.0
2007-06-21 14:00:00	MSFT	Stock	30.22	30.27	30.11	30.25	6854274.0
2007-06-21 15:00:00	MSFT	Stock	30.24	30.3	30.158	30.22	10457585.0
2007-06-21 16:00:00	MSFT	Stock	30.22	30.22	30.22	30.22	1269066.0
2007-06-21 07:00:00	NVDA	Stock	0.6692	0.6783	0.6692	0.6777	1134000.0
2007-06-21 08:00:00	NVDA	Stock	0.6757	0.6775	0.6727	0.6758	2173140.0
2007-06-21 09:00:00	NVDA	Stock	0.6643	0.6798	0.6643	0.6743	157304880.0
2007-06-21 10:00:00	NVDA	Stock	0.6742	0.6968	0.6737	0.6955	221676480.0
2007-06-21 11:00:00	NVDA	Stock	0.6948	0.7003	0.693	0.6998	114978360.0
2007-06-21 12:00:00	NVDA	Stock	0.6998	0.7083	0.6995	0.7015	181447500.0
2007-06-21 13:00:00	NVDA	Stock	0.7015	0.7095	0.7012	0.7083	106468320.0
2007-06-21 14:00:00	NVDA	Stock	0.7083	0.7108	0.703	0.7102	125819820.0
2007-06-21 15:00:00	NVDA	Stock	0.7103	0.7222	0.7102	0.7157	328963020.0
2007-06-21 16:00:00	NVDA	Stock	0.7163	0.7192	0.7157	0.7167	10885380.0
2007-06-21 17:00:00	NVDA	Stock	0.7168	0.7192	0.7168	0.7192	111600.0
2007-06-21 18:00:00	NVDA	Stock	0.7167	0.7198	0.7163	0.7193	5004600.0
2007-06-21 19:00:00	NVDA	Stock	0.718	0.72	0.7175	0.7198	328020.0
2007-06-21 07:00:00	AMZN	Stock	3.45	3.45	3.45	3.45	18000.0
2007-06-21 08:00:00	AMZN	Stock	3.45	3.4805	3.45	3.4675	64000.0
2007-06-21 09:00:00	AMZN	Stock	3.4675	3.479	3.433	3.444	23198240.0
2007-06-21 10:00:00	AMZN	Stock	3.444	3.4885	3.4435	3.4685	37417880.0
2007-06-21 11:00:00	AMZN	Stock	3.468	3.482	3.456	3.4595	20579120.0
2007-06-21 12:00:00	AMZN	Stock	3.4595	3.477	3.4435	3.451	15668440.0
2007-06-21 13:00:00	AMZN	Stock	3.451	3.4745	3.451	3.4735	15634160.0
2007-06-21 14:00:00	AMZN	Stock	3.4735	3.477	3.453	3.467	13223180.0
2007-06-21 15:00:00	AMZN	Stock	3.467	3.4875	3.4625	3.484	21160960.0
2007-06-21 16:00:00	AMZN	Stock	3.4835	3.485	3.482	3.484	1949420.0
2007-06-21 17:00:00	AMZN	Stock	3.485	3.4855	3.485	3.4855	118000.0
2007-06-21 18:00:00	AMZN	Stock	3.4835	3.4835	3.4835	3.4835	2000.0
2007-06-21 19:00:00	AMZN	Stock	3.485	3.485	3.485	3.485	6000.0
2007-06-21 09:00:00	TLT	Stock	83.54	83.69	83.53	83.66	122800.0
2007-06-21 10:00:00	TLT	Stock	83.65	83.7	83.47	83.63	128100.0
2007-06-21 11:00:00	TLT	Stock	83.63	83.69	83.57	83.63	45500.0
2007-06-21 12:00:00	TLT	Stock	83.61	83.67	83.49	83.58	252700.0
2007-06-21 13:00:00	TLT	Stock	83.58	83.6	83.53	83.54	54200.0
2007-06-21 14:00:00	TLT	Stock	83.54	83.54	83.31	83.39	54000.0
2007-06-21 15:00:00	TLT	Stock	83.39	83.47	83.21	83.25	118400.0
2007-06-21 16:00:00	TLT	Stock	83.28	83.29	83.22	83.22	22600.0

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

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