PREVIEW / stock_1hour / 2007-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-14.parquet
  size:    768 KB
  rows:    37,811
  symbols: 3,124

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-08-14 09:00:00	AAPL	Stock	4.5818	4.5821	4.5268	4.5354	86847740.0
2007-08-14 10:00:00	AAPL	Stock	4.5357	4.54	4.4604	4.4732	132527500.0
2007-08-14 11:00:00	AAPL	Stock	4.4732	4.5264	4.4454	4.5196	115262196.0
2007-08-14 12:00:00	AAPL	Stock	4.5196	4.52	4.4832	4.505	60904088.0
2007-08-14 13:00:00	AAPL	Stock	4.505	4.5107	4.4643	4.4793	54549964.0
2007-08-14 14:00:00	AAPL	Stock	4.48	4.4982	4.4393	4.4571	105051072.0
2007-08-14 15:00:00	AAPL	Stock	4.4579	4.4818	4.4182	4.4314	142705304.0
2007-08-14 16:00:00	AAPL	Stock	4.4329	4.4329	4.4296	4.4296	14388136.0
2007-08-14 09:00:00	MSFT	Stock	28.77	28.89	28.6	28.87	3329356.0
2007-08-14 10:00:00	MSFT	Stock	28.861	28.88	28.35	28.45	5941805.0
2007-08-14 11:00:00	MSFT	Stock	28.45	28.63	28.3	28.6	4408777.0
2007-08-14 12:00:00	MSFT	Stock	28.6	28.63	28.43	28.49	3214639.0
2007-08-14 13:00:00	MSFT	Stock	28.48	28.52	28.28	28.41	3491128.0
2007-08-14 14:00:00	MSFT	Stock	28.4	28.44	28.2	28.34	6728624.0
2007-08-14 15:00:00	MSFT	Stock	28.34	28.56	28.24	28.3	9449681.0
2007-08-14 16:00:00	MSFT	Stock	28.3	28.31	28.27	28.27	1986126.0
2007-08-14 08:00:00	NVDA	Stock	0.7208	0.7217	0.7183	0.7217	196140.0
2007-08-14 09:00:00	NVDA	Stock	0.7222	0.7417	0.722	0.74	117852480.0
2007-08-14 10:00:00	NVDA	Stock	0.7398	0.7482	0.7388	0.7408	180613620.0
2007-08-14 11:00:00	NVDA	Stock	0.7407	0.7475	0.7338	0.7467	118133520.0
2007-08-14 12:00:00	NVDA	Stock	0.7468	0.7498	0.7457	0.748	92263980.0
2007-08-14 13:00:00	NVDA	Stock	0.748	0.7598	0.7475	0.759	133669860.0
2007-08-14 14:00:00	NVDA	Stock	0.7588	0.76	0.7507	0.7585	189654600.0
2007-08-14 15:00:00	NVDA	Stock	0.7583	0.765	0.7528	0.7535	234935700.0
2007-08-14 16:00:00	NVDA	Stock	0.7533	0.7577	0.7502	0.755	2261880.0
2007-08-14 17:00:00	NVDA	Stock	0.7503	0.753	0.75	0.7508	175320.0
2007-08-14 18:00:00	NVDA	Stock	0.7513	0.7513	0.7485	0.7485	117600.0
2007-08-14 19:00:00	NVDA	Stock	0.7483	0.7493	0.7483	0.7493	32700.0
2007-08-14 07:00:00	AMZN	Stock	3.725	3.725	3.695	3.7	58000.0
2007-08-14 08:00:00	AMZN	Stock	3.71	3.725	3.71	3.725	64260.0
2007-08-14 09:00:00	AMZN	Stock	3.735	3.7425	3.679	3.712	13712280.0
2007-08-14 10:00:00	AMZN	Stock	3.7105	3.7125	3.655	3.6621	15424480.0
2007-08-14 11:00:00	AMZN	Stock	3.662	3.719	3.646	3.7115	22664220.0
2007-08-14 12:00:00	AMZN	Stock	3.71	3.7145	3.683	3.705	10587060.0
2007-08-14 13:00:00	AMZN	Stock	3.7065	3.707	3.6705	3.687	9282600.0
2007-08-14 14:00:00	AMZN	Stock	3.6875	3.699	3.665	3.6775	11411740.0
2007-08-14 15:00:00	AMZN	Stock	3.6775	3.7045	3.6635	3.6745	27888300.0
2007-08-14 16:00:00	AMZN	Stock	3.6745	3.6745	3.665	3.672	3568280.0
2007-08-14 17:00:00	AMZN	Stock	3.6665	3.6775	3.6665	3.6775	35960.0
2007-08-14 18:00:00	AMZN	Stock	3.673	3.673	3.6725	3.6725	12000.0
2007-08-14 19:00:00	AMZN	Stock	3.668	3.668	3.668	3.668	2000.0
2007-08-14 09:00:00	TLT	Stock	86.02	86.17	86.01	86.16	151600.0
2007-08-14 10:00:00	TLT	Stock	86.17	86.78	86.17	86.67	278800.0
2007-08-14 11:00:00	TLT	Stock	86.7	86.78	86.54	86.58	255700.0
2007-08-14 12:00:00	TLT	Stock	86.58	86.74	86.58	86.61	68600.0
2007-08-14 13:00:00	TLT	Stock	86.61	86.73	86.6	86.68	99200.0
2007-08-14 14:00:00	TLT	Stock	86.71	86.73	86.58	86.62	190900.0
2007-08-14 15:00:00	TLT	Stock	86.62	86.63	86.52	86.62	263200.0
2007-08-14 16:00:00	TLT	Stock	86.6	86.6	86.56	86.56	1500.0
2007-08-14 09:00:00	CL	Stock	33.05	33.13	32.81	32.905	410800.0

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

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