PREVIEW / stock_1hour / 2008-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-18.parquet
  size:    831 KB
  rows:    40,321
  symbols: 3,291

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-04-18 04:00:00	AAPL	Stock	5.6071	5.6071	5.6071	5.6071	2800.0
2008-04-18 05:00:00	AAPL	Stock	5.5907	5.5907	5.5907	5.5907	5600.0
2008-04-18 06:00:00	AAPL	Stock	5.5893	5.6107	5.5821	5.6046	11200.0
2008-04-18 07:00:00	AAPL	Stock	5.6107	5.6786	5.6071	5.6786	821408.0
2008-04-18 08:00:00	AAPL	Stock	5.6782	5.6957	5.6217	5.6693	6221264.0
2008-04-18 09:00:00	AAPL	Stock	5.6668	5.7025	5.6564	5.6757	174074796.0
2008-04-18 10:00:00	AAPL	Stock	5.6757	5.74	5.66	5.7368	191228912.0
2008-04-18 11:00:00	AAPL	Stock	5.7361	5.7661	5.715	5.7632	165771228.0
2008-04-18 12:00:00	AAPL	Stock	5.7629	5.795	5.7386	5.7593	120422456.0
2008-04-18 13:00:00	AAPL	Stock	5.7589	5.7857	5.7554	5.7693	76007652.0
2008-04-18 14:00:00	AAPL	Stock	5.7689	5.775	5.7321	5.7522	87417624.0
2008-04-18 15:00:00	AAPL	Stock	5.7521	5.7604	5.7246	5.7543	158275936.0
2008-04-18 16:00:00	AAPL	Stock	5.7532	5.7639	5.7289	5.7589	22924328.0
2008-04-18 17:00:00	AAPL	Stock	5.7625	5.775	5.7625	5.7707	700084.0
2008-04-18 18:00:00	AAPL	Stock	5.7704	5.7704	5.7571	5.7575	180292.0
2008-04-18 19:00:00	AAPL	Stock	5.7575	5.7707	5.7575	5.7707	288064.0
2008-04-18 07:00:00	MSFT	Stock	29.55	29.69	29.55	29.65	6464.0
2008-04-18 08:00:00	MSFT	Stock	29.65	29.95	29.65	29.81	224810.0
2008-04-18 09:00:00	MSFT	Stock	29.89	30.05	29.73	29.75	16715285.0
2008-04-18 10:00:00	MSFT	Stock	29.74	29.97	29.61	29.93	8988387.0
2008-04-18 11:00:00	MSFT	Stock	29.92	30.0	29.88	29.95	5666512.0
2008-04-18 12:00:00	MSFT	Stock	29.95	30.1	29.93	30.0	9172286.0
2008-04-18 13:00:00	MSFT	Stock	30.0	30.05	29.94	30.03	5566396.0
2008-04-18 14:00:00	MSFT	Stock	30.04	30.08	29.97	30.025	6273146.0
2008-04-18 15:00:00	MSFT	Stock	30.02	30.07	29.93	30.0	13890989.0
2008-04-18 16:00:00	MSFT	Stock	30.01	30.11	29.951	30.04	4666606.0
2008-04-18 17:00:00	MSFT	Stock	30.02	30.18	30.0	30.18	39205.0
2008-04-18 18:00:00	MSFT	Stock	30.18	30.23	30.13	30.18	53889.0
2008-04-18 19:00:00	MSFT	Stock	30.2	30.21	30.2	30.2	1900.0
2008-04-18 04:00:00	NVDA	Stock	0.4645	0.4645	0.4645	0.4645	10560.0
2008-04-18 08:00:00	NVDA	Stock	0.4775	0.4775	0.474	0.4775	623000.0
2008-04-18 09:00:00	NVDA	Stock	0.4775	0.482	0.4725	0.4738	65715520.0
2008-04-18 10:00:00	NVDA	Stock	0.474	0.4753	0.469	0.4738	85838360.0
2008-04-18 11:00:00	NVDA	Stock	0.4738	0.4798	0.4735	0.4793	71041400.0
2008-04-18 12:00:00	NVDA	Stock	0.4793	0.4815	0.4775	0.4794	64967800.0
2008-04-18 13:00:00	NVDA	Stock	0.4795	0.483	0.479	0.4798	47010280.0
2008-04-18 14:00:00	NVDA	Stock	0.48	0.48	0.473	0.4742	77091120.0
2008-04-18 15:00:00	NVDA	Stock	0.4745	0.4755	0.4715	0.4755	101221600.0
2008-04-18 16:00:00	NVDA	Stock	0.475	0.4766	0.4732	0.475	16817480.0
2008-04-18 17:00:00	NVDA	Stock	0.4759	0.4759	0.4748	0.475	2933000.0
2008-04-18 18:00:00	NVDA	Stock	0.4755	0.4755	0.475	0.475	182000.0
2008-04-18 19:00:00	NVDA	Stock	0.476	0.476	0.4742	0.4742	43000.0
2008-04-18 07:00:00	AMZN	Stock	3.8	3.8055	3.8	3.8055	41540.0
2008-04-18 08:00:00	AMZN	Stock	3.8055	3.8235	3.805	3.8125	402560.0
2008-04-18 09:00:00	AMZN	Stock	3.8125	3.8955	3.8105	3.8755	37614180.0
2008-04-18 10:00:00	AMZN	Stock	3.875	3.965	3.8595	3.959	50366540.0
2008-04-18 11:00:00	AMZN	Stock	3.957	4.062	3.9565	4.051	46814640.0
2008-04-18 12:00:00	AMZN	Stock	4.051	4.1	4.0427	4.058	30155080.0
2008-04-18 13:00:00	AMZN	Stock	4.0575	4.0975	4.031	4.0514	37996180.0
2008-04-18 14:00:00	AMZN	Stock	4.051	4.0535	3.979	3.982	39179740.0

> showing 50 of 40,321 rows — these rows as CSV

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