PREVIEW / stock_1hour / 2008-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-03.parquet
  size:    583 KB
  rows:    25,766
  symbols: 3,245

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
2008-07-03 07:00:00	AAPL	Stock	5.975	5.9768	5.9679	5.9768	128800.0
2008-07-03 08:00:00	AAPL	Stock	5.975	6.0625	5.9475	6.0536	6220900.0
2008-07-03 09:00:00	AAPL	Stock	6.0536	6.0964	5.9329	6.0104	124463500.0
2008-07-03 10:00:00	AAPL	Stock	6.0104	6.1379	5.9196	6.0996	184428776.0
2008-07-03 11:00:00	AAPL	Stock	6.099	6.1489	6.0732	6.0832	88799676.0
2008-07-03 12:00:00	AAPL	Stock	6.0829	6.115	6.0575	6.0766	108143308.0
2008-07-03 13:00:00	AAPL	Stock	6.0746	6.0944	6.054	6.0839	4351312.0
2008-07-03 14:00:00	AAPL	Stock	6.0839	6.0839	6.0603	6.0786	116536.0
2008-07-03 15:00:00	AAPL	Stock	6.0768	6.0836	6.0714	6.0714	157360.0
2008-07-03 16:00:00	AAPL	Stock	6.0714	6.0714	6.0714	6.0714	89152.0
2008-07-03 07:00:00	MSFT	Stock	25.74	25.79	25.7	25.76	3700.0
2008-07-03 08:00:00	MSFT	Stock	25.76	25.97	25.69	25.94	63706.0
2008-07-03 09:00:00	MSFT	Stock	25.9	26.1	25.82	25.96	7009854.0
2008-07-03 10:00:00	MSFT	Stock	25.95	26.05	25.6	25.842	9831193.0
2008-07-03 11:00:00	MSFT	Stock	25.842	25.94	25.79	25.91	7531461.0
2008-07-03 12:00:00	MSFT	Stock	25.91	26.07	25.8	25.97	10631989.0
2008-07-03 13:00:00	MSFT	Stock	25.98	26.06	25.891	25.98	1667862.0
2008-07-03 14:00:00	MSFT	Stock	26.0	26.11	25.911	26.11	20988.0
2008-07-03 15:00:00	MSFT	Stock	26.0	26.0	25.9	25.9	3650.0
2008-07-03 16:00:00	MSFT	Stock	25.9	25.9	25.85	25.85	5900.0
2008-07-03 07:00:00	NVDA	Stock	0.355	0.3625	0.3368	0.3388	7435360.0
2008-07-03 08:00:00	NVDA	Stock	0.3378	0.3595	0.3248	0.3265	122801080.0
2008-07-03 09:00:00	NVDA	Stock	0.3275	0.3325	0.31	0.3265	1031805160.0
2008-07-03 10:00:00	NVDA	Stock	0.3263	0.3265	0.3125	0.3165	688724360.0
2008-07-03 11:00:00	NVDA	Stock	0.3165	0.3195	0.313	0.315	452200080.0
2008-07-03 12:00:00	NVDA	Stock	0.315	0.318	0.31	0.3113	590973120.0
2008-07-03 13:00:00	NVDA	Stock	0.3118	0.325	0.3095	0.3115	49379960.0
2008-07-03 14:00:00	NVDA	Stock	0.3115	0.3184	0.3113	0.3118	3129240.0
2008-07-03 15:00:00	NVDA	Stock	0.3115	0.3123	0.3115	0.3118	940760.0
2008-07-03 16:00:00	NVDA	Stock	0.3118	0.312	0.311	0.311	1129320.0
2008-07-03 08:00:00	AMZN	Stock	3.5995	3.6165	3.5995	3.61	14000.0
2008-07-03 09:00:00	AMZN	Stock	3.605	3.6375	3.542	3.603	14971780.0
2008-07-03 10:00:00	AMZN	Stock	3.6015	3.692	3.526	3.67	32948960.0
2008-07-03 11:00:00	AMZN	Stock	3.671	3.678	3.6175	3.64	17117080.0
2008-07-03 12:00:00	AMZN	Stock	3.6395	3.6415	3.583	3.5995	18364660.0
2008-07-03 13:00:00	AMZN	Stock	3.5995	3.623	3.586	3.605	850240.0
2008-07-03 14:00:00	AMZN	Stock	3.623	3.623	3.605	3.605	64640.0
2008-07-03 15:00:00	AMZN	Stock	3.6	3.6	3.6	3.6	2000.0
2008-07-03 08:00:00	TLT	Stock	92.27	92.27	91.65	91.7	19863.0
2008-07-03 09:00:00	TLT	Stock	91.69	92.21	91.54	92.21	313930.0
2008-07-03 10:00:00	TLT	Stock	92.21	92.3	91.73	92.0	580626.0
2008-07-03 11:00:00	TLT	Stock	92.0	92.07	91.88	92.01	194123.0
2008-07-03 12:00:00	TLT	Stock	92.01	92.22	92.01	92.07	290843.0
2008-07-03 13:00:00	TLT	Stock	92.02	92.02	92.02	92.02	600.0
2008-07-03 09:00:00	CL	Stock	34.735	34.995	34.625	34.96	478906.0
2008-07-03 10:00:00	CL	Stock	34.95	35.13	34.825	35.035	878668.0
2008-07-03 11:00:00	CL	Stock	35.03	35.28	35.0	35.28	729052.0
2008-07-03 12:00:00	CL	Stock	35.275	35.285	35.065	35.145	984676.0
2008-07-03 13:00:00	CL	Stock	35.175	35.175	35.16	35.175	745210.0

> showing 49 of 25,766 rows — these rows as CSV

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