PREVIEW / stock_1hour / 2006-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-05.parquet
  size:    592 KB
  rows:    28,127
  symbols: 2,219

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-04-05 05:00:00	AAPL	Stock	2.1736	2.1736	2.1732	2.1732	5600.0
2006-04-05 06:00:00	AAPL	Stock	2.1786	2.1786	2.1732	2.1786	168000.0
2006-04-05 07:00:00	AAPL	Stock	2.1789	2.1789	2.175	2.1786	14000.0
2006-04-05 08:00:00	AAPL	Stock	2.175	2.2839	2.1679	2.2707	49506744.0
2006-04-05 09:00:00	AAPL	Stock	2.2714	2.3429	2.2696	2.3104	538818784.0
2006-04-05 10:00:00	AAPL	Stock	2.3104	2.3521	2.2939	2.3511	411179832.0
2006-04-05 11:00:00	AAPL	Stock	2.3511	2.3518	2.3318	2.3407	237617072.0
2006-04-05 12:00:00	AAPL	Stock	2.3407	2.3739	2.3407	2.3689	200612468.0
2006-04-05 13:00:00	AAPL	Stock	2.3689	2.38	2.3571	2.3671	215791660.0
2006-04-05 14:00:00	AAPL	Stock	2.3671	2.3964	2.3668	2.3879	209059592.0
2006-04-05 15:00:00	AAPL	Stock	2.3868	2.4004	2.3754	2.3996	329243264.0
2006-04-05 16:00:00	AAPL	Stock	2.3986	2.4004	2.3646	2.3982	11253760.0
2006-04-05 17:00:00	AAPL	Stock	2.3986	2.41	2.3982	2.4086	14450716.0
2006-04-05 18:00:00	AAPL	Stock	2.4075	2.4096	2.4036	2.4064	913696.0
2006-04-05 07:00:00	MSFT	Stock	27.64	27.64	27.64	27.64	1000.0
2006-04-05 08:00:00	MSFT	Stock	27.7	27.78	27.66	27.74	22510.0
2006-04-05 09:00:00	MSFT	Stock	27.74	27.96	27.74	27.86	8376915.0
2006-04-05 10:00:00	MSFT	Stock	27.85	27.9	27.74	27.75	6743968.0
2006-04-05 11:00:00	MSFT	Stock	27.758	27.77	27.64	27.668	4646081.0
2006-04-05 12:00:00	MSFT	Stock	27.662	27.85	27.66	27.83	5127379.0
2006-04-05 13:00:00	MSFT	Stock	27.82	27.87	27.72	27.77	4591104.0
2006-04-05 14:00:00	MSFT	Stock	27.77	27.82	27.74	27.8	3438555.0
2006-04-05 15:00:00	MSFT	Stock	27.8	27.84	27.69	27.77	7060369.0
2006-04-05 16:00:00	MSFT	Stock	27.78	27.83	27.72	27.75	71387.0
2006-04-05 17:00:00	MSFT	Stock	27.75	27.86	27.75	27.85	12087.0
2006-04-05 18:00:00	MSFT	Stock	27.83	27.83	27.74	27.74	1081.0
2006-04-05 08:00:00	NVDA	Stock	0.5037	0.5046	0.4984	0.5021	395400.0
2006-04-05 09:00:00	NVDA	Stock	0.5033	0.5117	0.5016	0.5099	144066120.0
2006-04-05 10:00:00	NVDA	Stock	0.5098	0.5111	0.4958	0.4992	345147960.0
2006-04-05 11:00:00	NVDA	Stock	0.4992	0.5012	0.4934	0.4997	206587680.0
2006-04-05 12:00:00	NVDA	Stock	0.4999	0.5034	0.4976	0.5026	75146040.0
2006-04-05 13:00:00	NVDA	Stock	0.5026	0.505	0.5016	0.5047	92018160.0
2006-04-05 14:00:00	NVDA	Stock	0.5047	0.5092	0.5031	0.5081	82201680.0
2006-04-05 15:00:00	NVDA	Stock	0.5081	0.5104	0.505	0.5092	138841080.0
2006-04-05 16:00:00	NVDA	Stock	0.5087	0.51	0.5083	0.51	4645560.0
2006-04-05 17:00:00	NVDA	Stock	0.5095	0.5106	0.5095	0.5102	234000.0
2006-04-05 18:00:00	NVDA	Stock	0.5096	0.5096	0.5096	0.5096	12000.0
2006-04-05 08:00:00	AMZN	Stock	1.8385	1.8385	1.8385	1.8385	2000.0
2006-04-05 09:00:00	AMZN	Stock	1.8375	1.8575	1.826	1.85	10067120.0
2006-04-05 10:00:00	AMZN	Stock	1.85	1.852	1.829	1.8315	9804040.0
2006-04-05 11:00:00	AMZN	Stock	1.832	1.8365	1.8135	1.8275	13207780.0
2006-04-05 12:00:00	AMZN	Stock	1.827	1.857	1.825	1.8525	13543140.0
2006-04-05 13:00:00	AMZN	Stock	1.8525	1.865	1.8485	1.861	18180980.0
2006-04-05 14:00:00	AMZN	Stock	1.8615	1.8645	1.8465	1.8555	25536060.0
2006-04-05 15:00:00	AMZN	Stock	1.8555	1.867	1.8525	1.8645	18262160.0
2006-04-05 16:00:00	AMZN	Stock	1.866	1.8695	1.8598	1.8665	226000.0
2006-04-05 18:00:00	AMZN	Stock	1.867	1.867	1.867	1.867	2000.0
2006-04-05 08:00:00	CL	Stock	28.935	28.935	28.935	28.935	3600.0
2006-04-05 09:00:00	CL	Stock	29.0	29.075	28.955	29.015	363400.0
2006-04-05 10:00:00	CL	Stock	29.02	29.065	28.975	28.995	513000.0

> showing 50 of 28,127 rows — these rows as CSV

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