PREVIEW / stock_1hour / 2007-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-29.parquet
  size:    800 KB
  rows:    39,578
  symbols: 3,200

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-11-29 04:00:00	AAPL	Stock	6.4625	6.4643	6.4461	6.4461	11200.0
2007-11-29 05:00:00	AAPL	Stock	6.4339	6.4339	6.4304	6.4304	14000.0
2007-11-29 06:00:00	AAPL	Stock	6.4304	6.4304	6.4218	6.4218	11200.0
2007-11-29 07:00:00	AAPL	Stock	6.4271	6.4539	6.4025	6.4539	410536.0
2007-11-29 08:00:00	AAPL	Stock	6.45	6.45	6.3868	6.4125	10181584.0
2007-11-29 09:00:00	AAPL	Stock	6.4125	6.4625	6.3982	6.4189	140252756.0
2007-11-29 10:00:00	AAPL	Stock	6.4182	6.5029	6.4071	6.4964	171436972.0
2007-11-29 11:00:00	AAPL	Stock	6.4964	6.5996	6.495	6.5721	223965868.0
2007-11-29 12:00:00	AAPL	Stock	6.5721	6.5757	6.5268	6.5425	103122852.0
2007-11-29 13:00:00	AAPL	Stock	6.5429	6.5536	6.5036	6.5423	98414736.0
2007-11-29 14:00:00	AAPL	Stock	6.5418	6.5886	6.5364	6.5886	97518540.0
2007-11-29 15:00:00	AAPL	Stock	6.5882	6.6132	6.5393	6.5832	186179476.0
2007-11-29 16:00:00	AAPL	Stock	6.5804	6.5964	6.4165	6.5657	14535948.0
2007-11-29 17:00:00	AAPL	Stock	6.5614	6.5661	6.51	6.5532	1463364.0
2007-11-29 18:00:00	AAPL	Stock	6.5536	6.5686	6.5464	6.5564	976752.0
2007-11-29 19:00:00	AAPL	Stock	6.5536	6.6293	6.5536	6.6293	2651712.0
2007-11-29 07:00:00	MSFT	Stock	33.61	33.61	33.61	33.61	100.0
2007-11-29 08:00:00	MSFT	Stock	33.58	33.61	33.34	33.5	421801.0
2007-11-29 09:00:00	MSFT	Stock	33.47	33.93	33.46	33.71	6379782.0
2007-11-29 10:00:00	MSFT	Stock	33.71	33.78	33.44	33.71	8534589.0
2007-11-29 11:00:00	MSFT	Stock	33.7	33.84	33.63	33.67	6159071.0
2007-11-29 12:00:00	MSFT	Stock	33.67	33.72	33.62	33.63	4750121.0
2007-11-29 13:00:00	MSFT	Stock	33.64	33.69	33.31	33.51	7214446.0
2007-11-29 14:00:00	MSFT	Stock	33.51	33.64	33.46	33.56	6146015.0
2007-11-29 15:00:00	MSFT	Stock	33.57	33.65	33.42	33.59	11174887.0
2007-11-29 16:00:00	MSFT	Stock	33.57	33.7	33.3	33.59	2724517.0
2007-11-29 17:00:00	MSFT	Stock	33.59	33.668	33.41	33.42	103506.0
2007-11-29 18:00:00	MSFT	Stock	33.42	33.47	33.35	33.44	4760.0
2007-11-29 19:00:00	MSFT	Stock	33.47	33.65	33.41	33.65	21207.0
2007-11-29 08:00:00	NVDA	Stock	0.8225	0.8225	0.8102	0.8125	153600.0
2007-11-29 09:00:00	NVDA	Stock	0.815	0.8422	0.815	0.8325	62585400.0
2007-11-29 10:00:00	NVDA	Stock	0.8328	0.8405	0.823	0.8283	68516720.0
2007-11-29 11:00:00	NVDA	Stock	0.8283	0.8508	0.8265	0.8468	89361120.0
2007-11-29 12:00:00	NVDA	Stock	0.8468	0.8525	0.8295	0.83	66206200.0
2007-11-29 13:00:00	NVDA	Stock	0.83	0.8322	0.8218	0.8278	58278440.0
2007-11-29 14:00:00	NVDA	Stock	0.8278	0.8325	0.825	0.83	47906280.0
2007-11-29 15:00:00	NVDA	Stock	0.8302	0.8358	0.8222	0.8288	79183840.0
2007-11-29 16:00:00	NVDA	Stock	0.8288	0.8395	0.8212	0.8262	16270400.0
2007-11-29 17:00:00	NVDA	Stock	0.8262	0.8328	0.82	0.8208	737520.0
2007-11-29 19:00:00	NVDA	Stock	0.825	0.827	0.825	0.827	88000.0
2007-11-29 06:00:00	AMZN	Stock	4.4835	4.4835	4.4835	4.4835	2000.0
2007-11-29 08:00:00	AMZN	Stock	4.5	4.5165	4.477	4.4965	132760.0
2007-11-29 09:00:00	AMZN	Stock	4.492	4.5735	4.485	4.536	22959960.0
2007-11-29 10:00:00	AMZN	Stock	4.537	4.5645	4.5025	4.5125	23473640.0
2007-11-29 11:00:00	AMZN	Stock	4.512	4.5565	4.5	4.5035	19028280.0
2007-11-29 12:00:00	AMZN	Stock	4.5035	4.5048	4.444	4.4475	17003380.0
2007-11-29 13:00:00	AMZN	Stock	4.4475	4.4608	4.4375	4.4485	13318360.0
2007-11-29 14:00:00	AMZN	Stock	4.449	4.4545	4.434	4.451	15231900.0
2007-11-29 15:00:00	AMZN	Stock	4.451	4.4845	4.444	4.4575	23876980.0
2007-11-29 16:00:00	AMZN	Stock	4.4575	4.515	4.446	4.451	4449160.0

> showing 50 of 39,578 rows — these rows as CSV

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