PREVIEW / stock_1hour / 2005-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-25.parquet
  size:    545 KB
  rows:    25,950
  symbols: 2,069

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
2005-08-25 08:00:00	AAPL	Stock	1.6411	1.6536	1.6393	1.6446	848120.0
2005-08-25 09:00:00	AAPL	Stock	1.6457	1.6604	1.6411	1.6486	63309036.0
2005-08-25 10:00:00	AAPL	Stock	1.6486	1.6564	1.6475	1.6539	52938424.0
2005-08-25 11:00:00	AAPL	Stock	1.6543	1.6554	1.6421	1.6457	42233828.0
2005-08-25 12:00:00	AAPL	Stock	1.6454	1.6454	1.6361	1.6432	30107196.0
2005-08-25 13:00:00	AAPL	Stock	1.6429	1.6464	1.6396	1.645	24537520.0
2005-08-25 14:00:00	AAPL	Stock	1.645	1.65	1.6439	1.6479	20280484.0
2005-08-25 15:00:00	AAPL	Stock	1.6479	1.6479	1.6425	1.6439	35804244.0
2005-08-25 16:00:00	AAPL	Stock	1.645	1.6468	1.6443	1.6468	1905876.0
2005-08-25 17:00:00	AAPL	Stock	1.645	1.6464	1.645	1.6464	22400.0
2005-08-25 18:00:00	AAPL	Stock	1.6482	1.6482	1.6482	1.6482	25200.0
2005-08-25 08:00:00	MSFT	Stock	26.8	26.87	26.8	26.87	16599.0
2005-08-25 09:00:00	MSFT	Stock	26.88	26.99	26.85	26.91	4696504.0
2005-08-25 10:00:00	MSFT	Stock	26.902	27.04	26.87	26.98	6174294.0
2005-08-25 11:00:00	MSFT	Stock	26.981	27.06	26.97	27.01	7524317.0
2005-08-25 12:00:00	MSFT	Stock	27.01	27.05	26.9	26.982	3365961.0
2005-08-25 13:00:00	MSFT	Stock	26.99	27.04	26.93	26.98	3450878.0
2005-08-25 14:00:00	MSFT	Stock	26.98	27.09	26.94	27.06	4767363.0
2005-08-25 15:00:00	MSFT	Stock	27.051	27.07	26.98	27.03	7531913.0
2005-08-25 16:00:00	MSFT	Stock	27.03	27.08	26.99	27.03	286602.0
2005-08-25 17:00:00	MSFT	Stock	27.04	27.05	27.03	27.05	304700.0
2005-08-25 18:00:00	MSFT	Stock	27.07	27.1	27.04	27.09	2820.0
2005-08-25 08:00:00	NVDA	Stock	0.2459	0.2459	0.2458	0.2459	72000.0
2005-08-25 09:00:00	NVDA	Stock	0.2447	0.245	0.2427	0.2429	27454320.0
2005-08-25 10:00:00	NVDA	Stock	0.243	0.2443	0.2421	0.244	75157080.0
2005-08-25 11:00:00	NVDA	Stock	0.2439	0.2455	0.2438	0.2447	33300240.0
2005-08-25 12:00:00	NVDA	Stock	0.2447	0.2456	0.2442	0.2449	25875120.0
2005-08-25 13:00:00	NVDA	Stock	0.245	0.2461	0.2448	0.245	33945480.0
2005-08-25 14:00:00	NVDA	Stock	0.245	0.2458	0.2448	0.2455	36177480.0
2005-08-25 15:00:00	NVDA	Stock	0.2456	0.2457	0.2442	0.2447	59311200.0
2005-08-25 16:00:00	NVDA	Stock	0.2447	0.2447	0.2442	0.2442	1840920.0
2005-08-25 17:00:00	NVDA	Stock	0.2442	0.2442	0.2442	0.2442	120000.0
2005-08-25 09:00:00	AMZN	Stock	2.1195	2.14	2.104	2.106	11797020.0
2005-08-25 10:00:00	AMZN	Stock	2.106	2.131	2.1055	2.1275	10432400.0
2005-08-25 11:00:00	AMZN	Stock	2.1275	2.132	2.1215	2.1265	9029480.0
2005-08-25 12:00:00	AMZN	Stock	2.126	2.1302	2.121	2.122	3330080.0
2005-08-25 13:00:00	AMZN	Stock	2.122	2.124	2.1165	2.1225	5258380.0
2005-08-25 14:00:00	AMZN	Stock	2.1225	2.126	2.1215	2.124	7040520.0
2005-08-25 15:00:00	AMZN	Stock	2.124	2.1245	2.111	2.115	12923840.0
2005-08-25 16:00:00	AMZN	Stock	2.1155	2.1165	2.113	2.1155	990920.0
2005-08-25 09:00:00	CL	Stock	26.295	26.305	26.18	26.24	203600.0
2005-08-25 10:00:00	CL	Stock	26.22	26.29	26.175	26.26	362400.0
2005-08-25 11:00:00	CL	Stock	26.265	26.315	26.245	26.25	232200.0
2005-08-25 12:00:00	CL	Stock	26.245	26.26	26.185	26.2	185600.0
2005-08-25 13:00:00	CL	Stock	26.195	26.245	26.175	26.215	325800.0
2005-08-25 14:00:00	CL	Stock	26.21	26.25	26.195	26.227	439800.0
2005-08-25 15:00:00	CL	Stock	26.23	26.235	26.185	26.22	579000.0
2005-08-25 17:00:00	CL	Stock	26.235	26.235	26.235	26.235	1000.0

> showing 48 of 25,950 rows — these rows as CSV

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