PREVIEW / stock_1hour / 2009-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-04.parquet
  size:    887 KB
  rows:    42,474
  symbols: 3,399

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
2009-11-04 06:00:00	AAPL	Stock	6.7857	6.7857	6.7857	6.7857	28000.0
2009-11-04 07:00:00	AAPL	Stock	6.7911	6.7982	6.775	6.7807	253288.0
2009-11-04 08:00:00	AAPL	Stock	6.7839	6.8212	6.7804	6.8125	2488080.0
2009-11-04 09:00:00	AAPL	Stock	6.8082	6.8368	6.7939	6.8332	71493128.0
2009-11-04 10:00:00	AAPL	Stock	6.8339	6.9232	6.8146	6.9218	96477360.0
2009-11-04 11:00:00	AAPL	Stock	6.9218	6.9221	6.8818	6.883	53637752.0
2009-11-04 12:00:00	AAPL	Stock	6.8842	6.8982	6.8775	6.8893	33872692.0
2009-11-04 13:00:00	AAPL	Stock	6.8882	6.89	6.8571	6.8732	26800536.0
2009-11-04 14:00:00	AAPL	Stock	6.8718	6.9182	6.8571	6.9096	79933728.0
2009-11-04 15:00:00	AAPL	Stock	6.9096	6.9132	6.8061	6.8164	107845920.0
2009-11-04 16:00:00	AAPL	Stock	6.8168	6.8643	6.8114	6.8239	8960756.0
2009-11-04 17:00:00	AAPL	Stock	6.8275	6.8393	6.8268	6.8321	521136.0
2009-11-04 18:00:00	AAPL	Stock	6.8304	6.835	6.8146	6.832	215488.0
2009-11-04 19:00:00	AAPL	Stock	6.8296	6.8364	6.8214	6.8286	151872.0
2009-11-04 06:00:00	MSFT	Stock	27.78	27.78	27.78	27.78	400.0
2009-11-04 07:00:00	MSFT	Stock	27.73	27.77	27.73	27.77	300.0
2009-11-04 08:00:00	MSFT	Stock	27.53	27.71	27.53	27.67	106029.0
2009-11-04 09:00:00	MSFT	Stock	27.67	27.92	27.62	27.89	5095475.0
2009-11-04 10:00:00	MSFT	Stock	27.9	28.12	27.83	28.11	10465736.0
2009-11-04 11:00:00	MSFT	Stock	28.11	28.26	28.07	28.169	6439533.0
2009-11-04 12:00:00	MSFT	Stock	28.17	28.23	28.09	28.22	3748396.0
2009-11-04 13:00:00	MSFT	Stock	28.22	28.26	28.14	28.15	3362557.0
2009-11-04 14:00:00	MSFT	Stock	28.14	28.39	28.1	28.38	9995993.0
2009-11-04 15:00:00	MSFT	Stock	28.38	28.38	28.04	28.06	17550447.0
2009-11-04 16:00:00	MSFT	Stock	28.07	28.4	28.05	28.32	6004096.0
2009-11-04 17:00:00	MSFT	Stock	28.34	28.36	28.26	28.28	185753.0
2009-11-04 18:00:00	MSFT	Stock	28.32	28.34	28.06	28.32	23645.0
2009-11-04 19:00:00	MSFT	Stock	28.32	28.43	28.32	28.35	114100.0
2009-11-04 08:00:00	NVDA	Stock	0.303	0.3038	0.303	0.3035	94000.0
2009-11-04 09:00:00	NVDA	Stock	0.3035	0.3058	0.3008	0.3032	90391040.0
2009-11-04 10:00:00	NVDA	Stock	0.3035	0.305	0.3002	0.3035	123086400.0
2009-11-04 11:00:00	NVDA	Stock	0.3035	0.3038	0.3025	0.3032	52833560.0
2009-11-04 12:00:00	NVDA	Stock	0.303	0.305	0.3028	0.3046	57370240.0
2009-11-04 13:00:00	NVDA	Stock	0.3047	0.305	0.3	0.3008	163132720.0
2009-11-04 14:00:00	NVDA	Stock	0.3008	0.3019	0.2982	0.3015	212808360.0
2009-11-04 15:00:00	NVDA	Stock	0.3015	0.3025	0.2985	0.2995	188705040.0
2009-11-04 16:00:00	NVDA	Stock	0.2992	0.3018	0.2992	0.3012	11980560.0
2009-11-04 17:00:00	NVDA	Stock	0.3002	0.3018	0.3002	0.3018	140320.0
2009-11-04 18:00:00	NVDA	Stock	0.3018	0.3035	0.3018	0.3035	199280.0
2009-11-04 19:00:00	NVDA	Stock	0.3038	0.3038	0.303	0.3035	144560.0
2009-11-04 04:00:00	AMZN	Stock	5.9355	5.9355	5.9355	5.9355	2000.0
2009-11-04 07:00:00	AMZN	Stock	5.95	5.95	5.95	5.95	18000.0
2009-11-04 08:00:00	AMZN	Stock	5.95	5.9875	5.95	5.962	391360.0
2009-11-04 09:00:00	AMZN	Stock	5.96	5.977	5.862	5.903	19597760.0
2009-11-04 10:00:00	AMZN	Stock	5.906	5.924	5.8722	5.9	23704660.0
2009-11-04 11:00:00	AMZN	Stock	5.899	5.9385	5.892	5.918	14255640.0
2009-11-04 12:00:00	AMZN	Stock	5.919	5.95	5.9155	5.93	10207580.0
2009-11-04 13:00:00	AMZN	Stock	5.9285	5.9335	5.904	5.9105	7865160.0
2009-11-04 14:00:00	AMZN	Stock	5.9115	5.9425	5.88	5.903	30642700.0
2009-11-04 15:00:00	AMZN	Stock	5.899	5.905	5.838	5.8545	41829140.0

> showing 50 of 42,474 rows — these rows as CSV

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