PREVIEW / stock_1hour / 2007-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-15.parquet
  size:    782 KB
  rows:    37,880
  symbols: 3,022

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-15 09:00:00	AAPL	Stock	4.3079	4.3096	4.2807	4.2921	133684936.0
2007-06-15 10:00:00	AAPL	Stock	4.2921	4.3014	4.285	4.2897	119064260.0
2007-06-15 11:00:00	AAPL	Stock	4.29	4.3011	4.2879	4.2971	64395828.0
2007-06-15 12:00:00	AAPL	Stock	4.2975	4.3011	4.2907	4.2968	62898192.0
2007-06-15 13:00:00	AAPL	Stock	4.2971	4.2975	4.29	4.2971	48956096.0
2007-06-15 14:00:00	AAPL	Stock	4.2971	4.2979	4.035	4.2896	68423012.0
2007-06-15 15:00:00	AAPL	Stock	4.29	4.3032	4.2868	4.3032	100098152.0
2007-06-15 16:00:00	AAPL	Stock	4.3036	4.3036	4.3014	4.3036	19537756.0
2007-06-15 09:00:00	MSFT	Stock	30.86	30.88	30.58	30.695	26393003.0
2007-06-15 10:00:00	MSFT	Stock	30.7	30.75	30.56	30.63	6910908.0
2007-06-15 11:00:00	MSFT	Stock	30.63	30.65	30.51	30.54	4554623.0
2007-06-15 12:00:00	MSFT	Stock	30.542	30.6	30.43	30.59	5210793.0
2007-06-15 13:00:00	MSFT	Stock	30.59	30.69	30.58	30.68	5407906.0
2007-06-15 14:00:00	MSFT	Stock	30.69	30.7	30.55	30.6	6543962.0
2007-06-15 15:00:00	MSFT	Stock	30.6	30.68	30.45	30.49	16034671.0
2007-06-15 16:00:00	MSFT	Stock	30.49	30.49	30.49	30.49	10574624.0
2007-06-15 08:00:00	NVDA	Stock	0.6333	0.6398	0.6333	0.6382	389580.0
2007-06-15 09:00:00	NVDA	Stock	0.6365	0.6502	0.6363	0.647	229872840.0
2007-06-15 10:00:00	NVDA	Stock	0.6472	0.6642	0.6463	0.6618	242489460.0
2007-06-15 11:00:00	NVDA	Stock	0.6619	0.6635	0.6548	0.6585	126932940.0
2007-06-15 12:00:00	NVDA	Stock	0.6585	0.6593	0.6538	0.6538	66948300.0
2007-06-15 13:00:00	NVDA	Stock	0.6538	0.6583	0.6525	0.6582	76725780.0
2007-06-15 14:00:00	NVDA	Stock	0.6582	0.6623	0.657	0.6623	89224800.0
2007-06-15 15:00:00	NVDA	Stock	0.6623	0.6623	0.656	0.6592	145660320.0
2007-06-15 16:00:00	NVDA	Stock	0.6585	0.6597	0.6533	0.6593	19045440.0
2007-06-15 18:00:00	NVDA	Stock	0.6593	0.6682	0.6535	0.6633	4478640.0
2007-06-15 19:00:00	NVDA	Stock	0.6633	0.6667	0.6633	0.6637	577800.0
2007-06-15 07:00:00	AMZN	Stock	3.58	3.58	3.58	3.58	20000.0
2007-06-15 08:00:00	AMZN	Stock	3.5825	3.6255	3.5805	3.6235	542600.0
2007-06-15 09:00:00	AMZN	Stock	3.6225	3.6435	3.5595	3.5912	67732280.0
2007-06-15 10:00:00	AMZN	Stock	3.591	3.6165	3.5815	3.61	32510940.0
2007-06-15 11:00:00	AMZN	Stock	3.61	3.6155	3.5975	3.6085	16213800.0
2007-06-15 12:00:00	AMZN	Stock	3.6085	3.613	3.603	3.612	11360420.0
2007-06-15 13:00:00	AMZN	Stock	3.6125	3.6285	3.6115	3.619	19391940.0
2007-06-15 14:00:00	AMZN	Stock	3.6195	3.6235	3.6135	3.621	10698700.0
2007-06-15 15:00:00	AMZN	Stock	3.621	3.625	3.6155	3.6225	28364780.0
2007-06-15 16:00:00	AMZN	Stock	3.6225	3.625	3.599	3.6245	2706700.0
2007-06-15 17:00:00	AMZN	Stock	3.6245	3.625	3.6225	3.6225	35500.0
2007-06-15 18:00:00	AMZN	Stock	3.625	3.6275	3.6225	3.6275	96000.0
2007-06-15 19:00:00	AMZN	Stock	3.627	3.6275	3.627	3.6275	40000.0
2007-06-15 09:00:00	TLT	Stock	83.42	83.5	83.2	83.22	371400.0
2007-06-15 10:00:00	TLT	Stock	83.22	83.63	83.22	83.5	403900.0
2007-06-15 11:00:00	TLT	Stock	83.48	83.58	83.42	83.5	229800.0
2007-06-15 12:00:00	TLT	Stock	83.5	83.52	83.43	83.51	135400.0
2007-06-15 13:00:00	TLT	Stock	83.51	83.73	83.5	83.69	359800.0
2007-06-15 14:00:00	TLT	Stock	83.69	83.69	83.38	83.53	2037300.0
2007-06-15 15:00:00	TLT	Stock	83.53	83.62	83.49	83.58	997300.0
2007-06-15 16:00:00	TLT	Stock	83.6	83.71	83.6	83.69	37700.0
2007-06-15 09:00:00	CL	Stock	33.485	33.61	33.41	33.415	1453400.0
2007-06-15 10:00:00	CL	Stock	33.41	33.42	33.275	33.28	821000.0

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

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