PREVIEW / stock_1hour / 2007-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-02.parquet
  size:    648 KB
  rows:    30,697
  symbols: 2,490

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-03-02 07:00:00	AAPL	Stock	3.0757	3.1089	3.0757	3.0982	431480.0
2007-03-02 08:00:00	AAPL	Stock	3.0982	3.1036	3.0839	3.0964	4170236.0
2007-03-02 09:00:00	AAPL	Stock	3.0961	3.1264	3.0918	3.0993	154080752.0
2007-03-02 10:00:00	AAPL	Stock	3.0993	3.1161	3.0929	3.1129	129726996.0
2007-03-02 11:00:00	AAPL	Stock	3.1125	3.1132	3.0843	3.0914	90719804.0
2007-03-02 12:00:00	AAPL	Stock	3.0918	3.0996	3.0543	3.0679	132724424.0
2007-03-02 13:00:00	AAPL	Stock	3.0679	3.0732	3.0432	3.0632	115726772.0
2007-03-02 14:00:00	AAPL	Stock	3.0629	3.1	3.0471	3.0671	102821236.0
2007-03-02 15:00:00	AAPL	Stock	3.0675	3.0725	3.0507	3.0511	114889964.0
2007-03-02 16:00:00	AAPL	Stock	3.05	3.055	3.05	3.0536	4090436.0
2007-03-02 17:00:00	AAPL	Stock	3.0536	3.0579	3.0518	3.0579	204120.0
2007-03-02 18:00:00	AAPL	Stock	3.0557	3.0607	3.0554	3.0582	77000.0
2007-03-02 19:00:00	AAPL	Stock	3.0564	3.0582	3.0536	3.0536	179228.0
2007-03-02 07:00:00	MSFT	Stock	27.9	27.92	27.9	27.92	1100.0
2007-03-02 08:00:00	MSFT	Stock	28.0	28.02	27.93	28.0	38890.0
2007-03-02 09:00:00	MSFT	Stock	28.0	28.16	28.0	28.0	5995277.0
2007-03-02 10:00:00	MSFT	Stock	28.0	28.15	27.97	28.03	7183003.0
2007-03-02 11:00:00	MSFT	Stock	28.03	28.06	27.93	27.96	6457793.0
2007-03-02 12:00:00	MSFT	Stock	27.96	28.01	27.84	27.93	12112574.0
2007-03-02 13:00:00	MSFT	Stock	27.93	27.95	27.79	27.86	10716923.0
2007-03-02 14:00:00	MSFT	Stock	27.86	28.09	27.84	27.91	6552897.0
2007-03-02 15:00:00	MSFT	Stock	27.9	27.95	27.76	27.76	11640754.0
2007-03-02 16:00:00	MSFT	Stock	27.77	27.77	27.74	27.75	142012.0
2007-03-02 17:00:00	MSFT	Stock	27.78	27.78	27.76	27.77	1207.0
2007-03-02 18:00:00	MSFT	Stock	27.79	27.79	27.76	27.76	1596.0
2007-03-02 19:00:00	MSFT	Stock	27.77	27.77	27.77	27.77	122.0
2007-03-02 08:00:00	NVDA	Stock	0.505	0.505	0.505	0.505	60000.0
2007-03-02 09:00:00	NVDA	Stock	0.506	0.5097	0.5037	0.5058	46964760.0
2007-03-02 10:00:00	NVDA	Stock	0.5057	0.512	0.5045	0.5098	102561000.0
2007-03-02 11:00:00	NVDA	Stock	0.5099	0.5117	0.5025	0.5037	87077760.0
2007-03-02 12:00:00	NVDA	Stock	0.5035	0.505	0.498	0.5028	123645180.0
2007-03-02 13:00:00	NVDA	Stock	0.5028	0.5033	0.4985	0.5002	93652080.0
2007-03-02 14:00:00	NVDA	Stock	0.5002	0.5005	0.4958	0.4977	91592880.0
2007-03-02 15:00:00	NVDA	Stock	0.4977	0.5003	0.4952	0.4962	120683460.0
2007-03-02 16:00:00	NVDA	Stock	0.4962	0.4963	0.4958	0.4962	391560.0
2007-03-02 17:00:00	NVDA	Stock	0.497	0.5	0.496	0.4967	996900.0
2007-03-02 18:00:00	NVDA	Stock	0.4968	0.4968	0.4968	0.4968	30540.0
2007-03-02 19:00:00	NVDA	Stock	0.4978	0.4978	0.4978	0.4978	37800.0
2007-03-02 07:00:00	AMZN	Stock	1.95	1.95	1.95	1.95	2000.0
2007-03-02 08:00:00	AMZN	Stock	1.932	1.932	1.932	1.932	6000.0
2007-03-02 09:00:00	AMZN	Stock	1.9295	1.9435	1.912	1.928	13625260.0
2007-03-02 10:00:00	AMZN	Stock	1.9275	1.9295	1.914	1.926	26432320.0
2007-03-02 11:00:00	AMZN	Stock	1.9265	1.9265	1.914	1.9185	13023460.0
2007-03-02 12:00:00	AMZN	Stock	1.9185	1.919	1.896	1.8995	22524980.0
2007-03-02 13:00:00	AMZN	Stock	1.9	1.9025	1.888	1.8976	22083440.0
2007-03-02 14:00:00	AMZN	Stock	1.898	1.908	1.89	1.8985	14876280.0
2007-03-02 15:00:00	AMZN	Stock	1.8985	1.904	1.8845	1.8845	29079640.0
2007-03-02 16:00:00	AMZN	Stock	1.8855	1.892	1.8845	1.892	84100.0
2007-03-02 17:00:00	AMZN	Stock	1.89	1.89	1.89	1.89	8640.0
2007-03-02 19:00:00	AMZN	Stock	1.892	1.892	1.892	1.892	2000.0

> showing 50 of 30,697 rows — these rows as CSV

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