PREVIEW / stock_1hour / 2007-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-17.parquet
  size:    746 KB
  rows:    36,567
  symbols: 2,993

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-05-17 09:00:00	AAPL	Stock	3.8268	3.875	3.8268	3.8626	84303632.0
2007-05-17 10:00:00	AAPL	Stock	3.8625	3.8779	3.8536	3.8675	99098832.0
2007-05-17 11:00:00	AAPL	Stock	3.8671	3.8704	3.8504	3.8575	57139152.0
2007-05-17 12:00:00	AAPL	Stock	3.8579	3.8604	3.8404	3.8464	53464488.0
2007-05-17 13:00:00	AAPL	Stock	3.8461	3.8571	3.8429	3.8521	36807708.0
2007-05-17 14:00:00	AAPL	Stock	3.8525	3.9029	3.8486	3.8854	188347012.0
2007-05-17 15:00:00	AAPL	Stock	3.8854	3.9239	3.8829	3.9096	199011876.0
2007-05-17 16:00:00	AAPL	Stock	3.9096	3.9096	3.9086	3.9086	3207176.0
2007-05-17 09:00:00	MSFT	Stock	31.03	31.14	30.99	31.06	4678423.0
2007-05-17 10:00:00	MSFT	Stock	31.05	31.09	31.01	31.05	7283235.0
2007-05-17 11:00:00	MSFT	Stock	31.06	31.09	31.01	31.03	5176762.0
2007-05-17 12:00:00	MSFT	Stock	31.03	31.05	30.97	31.001	4369324.0
2007-05-17 13:00:00	MSFT	Stock	31.01	31.04	30.96	31.02	3217319.0
2007-05-17 14:00:00	MSFT	Stock	31.03	31.06	31.01	31.042	3700120.0
2007-05-17 15:00:00	MSFT	Stock	31.05	31.06	30.98	30.98	6012548.0
2007-05-17 16:00:00	MSFT	Stock	30.98	30.99	30.97	30.98	768401.0
2007-05-17 07:00:00	NVDA	Stock	0.5787	0.5787	0.5787	0.5787	6000.0
2007-05-17 08:00:00	NVDA	Stock	0.5832	0.5832	0.5832	0.5832	6000.0
2007-05-17 09:00:00	NVDA	Stock	0.582	0.5825	0.575	0.579	37709100.0
2007-05-17 10:00:00	NVDA	Stock	0.579	0.5833	0.576	0.579	63489360.0
2007-05-17 11:00:00	NVDA	Stock	0.579	0.58	0.574	0.5758	45489360.0
2007-05-17 12:00:00	NVDA	Stock	0.576	0.5767	0.5702	0.5705	57108240.0
2007-05-17 13:00:00	NVDA	Stock	0.5705	0.5728	0.5692	0.5712	59905020.0
2007-05-17 14:00:00	NVDA	Stock	0.5713	0.5753	0.569	0.5753	66912120.0
2007-05-17 15:00:00	NVDA	Stock	0.5753	0.5775	0.5717	0.5728	96834240.0
2007-05-17 16:00:00	NVDA	Stock	0.5728	0.5728	0.5708	0.5723	4751700.0
2007-05-17 17:00:00	NVDA	Stock	0.5723	0.5723	0.5717	0.5717	5904000.0
2007-05-17 18:00:00	NVDA	Stock	0.5722	0.5722	0.5722	0.5722	18000.0
2007-05-17 07:00:00	AMZN	Stock	3.1455	3.159	3.1455	3.159	14000.0
2007-05-17 08:00:00	AMZN	Stock	3.1575	3.1585	3.145	3.1525	837240.0
2007-05-17 09:00:00	AMZN	Stock	3.1525	3.176	3.1255	3.129	56534440.0
2007-05-17 10:00:00	AMZN	Stock	3.129	3.149	3.113	3.142	50483100.0
2007-05-17 11:00:00	AMZN	Stock	3.142	3.156	3.12	3.128	34381900.0
2007-05-17 12:00:00	AMZN	Stock	3.128	3.1318	3.101	3.1105	22565200.0
2007-05-17 13:00:00	AMZN	Stock	3.11	3.138	3.1045	3.1225	17610000.0
2007-05-17 14:00:00	AMZN	Stock	3.1225	3.1365	3.116	3.1255	17567180.0
2007-05-17 15:00:00	AMZN	Stock	3.126	3.1325	3.106	3.106	32170960.0
2007-05-17 16:00:00	AMZN	Stock	3.106	3.115	3.106	3.1095	2524340.0
2007-05-17 17:00:00	AMZN	Stock	3.1125	3.1125	3.109	3.109	120400.0
2007-05-17 18:00:00	AMZN	Stock	3.109	3.11	3.109	3.11	62400.0
2007-05-17 19:00:00	AMZN	Stock	3.112	3.1145	3.1095	3.11	36180.0
2007-05-17 09:00:00	TLT	Stock	87.6	87.68	87.56	87.68	62200.0
2007-05-17 10:00:00	TLT	Stock	87.69	87.72	87.53	87.57	66400.0
2007-05-17 11:00:00	TLT	Stock	87.57	87.65	87.56	87.65	28700.0
2007-05-17 12:00:00	TLT	Stock	87.62	87.67	87.5	87.51	104200.0
2007-05-17 13:00:00	TLT	Stock	87.52	87.56	87.41	87.46	49200.0
2007-05-17 14:00:00	TLT	Stock	87.46	87.51	87.45	87.48	26600.0
2007-05-17 15:00:00	TLT	Stock	87.48	87.5	87.46	87.46	57050.0
2007-05-17 16:00:00	TLT	Stock	87.51	87.51	87.51	87.51	700.0
2007-05-17 08:00:00	CL	Stock	33.29	33.29	33.29	33.29	200.0

> showing 50 of 36,567 rows — these rows as CSV

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